2 years ago

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

Filbert makes $14 per hour. If he makes time and a half for overtime, how much will he make for working 63 hours?

Marina CMI [18]

Answer:

$1323.00

Step-by-step explanation:

A simple equation that can be used to figure this out is:

p*1.5*o=t

The variables mean:

p- hourly pay

o- hours worked overtime

t- total amount of money earned.

(Also, the 1.5 is always used to calculate overtime, no matter what job, unless otherwise specified, and as referred in the problem as "time and a half").

So, to finally work out this problem:

($14*1.5)*63=?

first, (14*1.5)= $21

($21*63)= $1323.

4 0

2 years ago

Evaluate and reduce:

AfilCa [17]

Answer:

-31/8

Please mark me as brainliest

6 0