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

Unit 10 | Lesson 5 Lesson Checkpoint: Show What You Know Question Navigator Choose the answer. 2. (1 pt) Which answer is the mos

WARRIOR [948]

The answer is B.about 400, because if you multiply 18 by 24 you get the answer without rounding, and that answer would be 434; once 434 is rounded to the closest possible answer, you get that the answer, which is, as stated before, B. about 400.

3 0

3 years ago

Billy drove 1 half of the 7.5 miles between his house and the mall. How many miles did he drive?

lara31 [8.8K]

Billy drove 3.75 miles. You find the answer by dividing 7.5 by 2

8 0

3 years ago

James earns 20 allowance every month and 30 for each a on his report card

Svetach [21]

Answer:

Part A - the independant variable is the monthly allowance, and the dependent amount is the one that he has to get As for in order to receive it.

Part B - y = 30x + 20

Step-by-step explanation:

7 0

3 years ago

PLEASE HELP SMART PEOPLE WILL MARK BRAINLIEST

sergey [27]

Answer:

$\angle YPR = 42^o$

Step-by-step explanation:

Its given:

$\angle FPY = 90^o \\ \angle YPR + \angle FPR = 90^0 \\ 4p + 80 + 5p + 82 = 90^o \\ 9p = -72^o \\ p = -8 \\ \\ \angle YPR = 5(-8) + 82 = 42^o$

5 0

3 years ago

Find the mean of this set of numbers.

Lilit [14]

The answer would C. You must remember for the mean you need to add up all of the numbers, then divide the answer by the number of numbers you have.
Ex:
5,3,7,2,1
All of these numbers added up together is 18.In order to find out the mean, we need to divide the answer(18) by 5 because there are 5 numbers.
Hope this helps!

4 0

3 years ago