How do you calculate percentile in excel? How many students scored lower than 490?

1 answer:

3 0

Calculate rank percentile in Excel

To calculate the rank percentile of a list data, you can use a formula. Select a blank cell that you will place the rank percentile at, type this formula =RANK. EQ(B2,$B$2:$B$9,1)/COUNT($B$2:$B$9), press Enter key and drag fill handle down to calculate all rank percentiles.

You might be interested in

Write the slope-intercept form equation of the line that passes through (1,-1) and (2, 2).

mixer [17]

Answer:

The answer to your question is y= 3x - 4.

Step-by-step explanation:

Plot the points (1,-1) and (2,2) and get your slope, in the case of slope-intercept form "m" using the rise/run method. You rise 3 units and run one unit to the right to get from (1,-1) to (2,2), so your slope is 3/1 or just simply 3. -4 is your y-intercept, or "b", because if you plot the two aforementioned points (1,-1) and (2,2) and make a line with them, your line meets the y-axis at the point (0, -4). Hope this helps!

4 0

2 years ago

The gardener is going to cover the path with sand. If one bag of sand can cover 5yd^2, how many bags must be a whole number.

Nesterboy [21]

5 a bag of bags be can cover2 garden

5 0

3 years ago

What is 2700 divided 90

crimeas [40]

Answer:

Step-by-step explanation:

2700/90 = 30