Excel PERCENTRANK help
 

Hi!

I need help with the PERCENTRANK excel function for my data set....

I have a data set of several physical abilities tasks, such as pushups,
situps, pullups,
running a certain distance, etc. I have calculated all of the percentranks
for each individual's score on each task, but I cannot figure out how to get
the percentrank for the timed tests. For example, the 100 meter run, as a
timed task, the individual with the fasted time (lowest number in seconds)
should show up as 100% for the percentrank score, but the opposite is
happening. Excel is giving the higher percents to the individual's with a
higher times, because excel is equating the larger number in the data set to
a better score, thus a higher percent.

Is there a function to invert or reverse code the timed data scores?

Thanks for all of your help!

Excel PERCENTRANK help
 

=1-Percentrank()
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"Erica.DC" wrote:

Hi!

I need help with the PERCENTRANK excel function for my data set....

I have a data set of several physical abilities tasks, such as pushups,
situps, pullups,
running a certain distance, etc. I have calculated all of the percentranks
for each individual's score on each task, but I cannot figure out how to get
the percentrank for the timed tests. For example, the 100 meter run, as a
timed task, the individual with the fasted time (lowest number in seconds)
should show up as 100% for the percentrank score, but the opposite is
happening. Excel is giving the higher percents to the individual's with a
higher times, because excel is equating the larger number in the data set to
a better score, thus a higher percent.

Is there a function to invert or reverse code the timed data scores?

Thanks for all of your help!

Excel PERCENTRANK help
 

John,

Thank you soooooo much....you are awesome!

I really appreciate it.


-Erica

"John Bundy" wrote:

=1-Percentrank()
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"Erica.DC" wrote:

Hi!

I need help with the PERCENTRANK excel function for my data set....

I have a data set of several physical abilities tasks, such as pushups,
situps, pullups,
running a certain distance, etc. I have calculated all of the percentranks
for each individual's score on each task, but I cannot figure out how to get
the percentrank for the timed tests. For example, the 100 meter run, as a
timed task, the individual with the fasted time (lowest number in seconds)
should show up as 100% for the percentrank score, but the opposite is
happening. Excel is giving the higher percents to the individual's with a
higher times, because excel is equating the larger number in the data set to
a better score, thus a higher percent.

Is there a function to invert or reverse code the timed data scores?

Thanks for all of your help!

Excel PERCENTRANK help
 

You are welcome. And I am pretty awesome ;) j/k
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"Erica.DC" wrote:

John,

Thank you soooooo much....you are awesome!

I really appreciate it.


-Erica

"John Bundy" wrote:

=1-Percentrank()
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"Erica.DC" wrote:

Hi!

I need help with the PERCENTRANK excel function for my data set....

I have a data set of several physical abilities tasks, such as pushups,
situps, pullups,
running a certain distance, etc. I have calculated all of the percentranks
for each individual's score on each task, but I cannot figure out how to get
the percentrank for the timed tests. For example, the 100 meter run, as a
timed task, the individual with the fasted time (lowest number in seconds)
should show up as 100% for the percentrank score, but the opposite is
happening. Excel is giving the higher percents to the individual's with a
higher times, because excel is equating the larger number in the data set to
a better score, thus a higher percent.

Is there a function to invert or reverse code the timed data scores?

Thanks for all of your help!