software

I have a list of 75 test scores, and I have to calculate the percentile
of each test score and what percentile corresponds to what score.
Anybody have any ideas to make this easier? I already put all the test
scores in order.--
ddawg09
------------------------------------------------------------------------
ddawg09's Profile: www.excelforum.com/member.php...oamp;userid=31205
View this thread: www.excelforum.com/showthread...hreadid=514082Normalize the scores to the maximum (not perfect) scoSay you have 75 scores in column A sorted from highest at the top to lowest.
In B1 enter:

=A1/$A$1 and copy down thru B75. Format column B as percentage.
or
=100*A1/$A$1 and copy down thru B75. Format column B as number fixed places 0If you had thousands of scores you would bin them. For example, all scores
between 74.5% and 75.5% would be in the 75th percentile.
--
Gary's Studentquot;ddawg09quot; wrote:

gt;
gt; I have a list of 75 test scores, and I have to calculate the percentile
gt; of each test score and what percentile corresponds to what score.
gt; Anybody have any ideas to make this easier? I already put all the test
gt; scores in order.
gt;
gt;
gt; --
gt; ddawg09
gt; ------------------------------------------------------------------------
gt; ddawg09's Profile: www.excelforum.com/member.php...oamp;userid=31205
gt; View this thread: www.excelforum.com/showthread...hreadid=514082
gt;
gt;

IGNORE MY PREVIOUS POST:Percentile is related to position in the list rather than relative score.
In B1 use:
=(COUNT(A:A)-ROW())/COUNT(A:A)*100

Percentile should represent the percent of the population with scores lower
than the given score.

--
Gary''s Studentquot;Gary''s Studentquot; wrote:

gt; Normalize the scores to the maximum (not perfect) sco
gt;
gt;
gt; Say you have 75 scores in column A sorted from highest at the top to lowest.
gt; In B1 enter:
gt;
gt; =A1/$A$1 and copy down thru B75. Format column B as percentage.
gt; or
gt; =100*A1/$A$1 and copy down thru B75. Format column B as number fixed places 0
gt;
gt;
gt; If you had thousands of scores you would bin them. For example, all scores
gt; between 74.5% and 75.5% would be in the 75th percentile.
gt; --
gt; Gary's Student
gt;
gt;
gt; quot;ddawg09quot; wrote:
gt;
gt; gt;
gt; gt; I have a list of 75 test scores, and I have to calculate the percentile
gt; gt; of each test score and what percentile corresponds to what score.
gt; gt; Anybody have any ideas to make this easier? I already put all the test
gt; gt; scores in order.
gt; gt;
gt; gt;
gt; gt; --
gt; gt; ddawg09
gt; gt; ------------------------------------------------------------------------
gt; gt; ddawg09's Profile: www.excelforum.com/member.php...oamp;userid=31205
gt; gt; View this thread: www.excelforum.com/showthread...hreadid=514082
gt; gt;
gt; gt;


=(RANK(A2,$A$2:$A$76,-1)-COUNTIF($A$2:$A$76,A2))/COUNTA($A$2:$A$76)
Does not require the list to be sorted

On Sun, 19 Feb 2006 03:40:27 -0800, Gary''s Student
gt; wrote:

gt;IGNORE MY PREVIOUS POST:
gt;
gt;
gt;Percentile is related to position in the list rather than relative score.
gt;In B1 use:
gt;=(COUNT(A:A)-ROW())/COUNT(A:A)*100
gt;
gt;Percentile should represent the percent of the population with scores lower
gt;than the given score.You might also want to look at the PERCENTILE and PERCENTRANK
functions. They do not require sorting of your data.

I really appreciated the other suggestions too, by GS and hightide. To
me they showed a nice way to present the concept in class.

HTH
Kostis Vezerides