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

2/5(25y - 50) + 25y simplified

Vitek1552 [10]

Answer:

$35y - 20$

Step-by-step explanation:

here's the solution :-

=》

$\frac{2}{5} (25y - 50) + 25y$

=》

$10y - 20 + 25y$

=》

$35y - 20$

3 0

2 years ago

Read 2 more answers

The price of a cup coffee was 2.40 yesterday. Today, the price fell to 2.15 find the percentage decrease. Round the answer to th

irakobra [83]

ANSWER

The percentage decrease is 10.4%.

EXPLANATION

To calculate percentage decrease, use the formula,

Percentage decrease

$= \frac{new \: price - old \: price}{old \: price} \times 100\%$

Yesterday the price of coffee was 2.40. This is the old price.

Today the price is 2.15. This is the new price.

$= \frac{2.15 - 2.40}{2.40} \times 100\%$

$= \frac{ - 0.25}{2.40} \times 100\%$

$= - 0. 10416667 \times 100\%$

$= - 10.416667\%$

To the nearest tenth, we have:

$- 10.4\%$

Therefore the percentage decrease is 10.4%.

8 0

3 years ago

Express the sum of the polymonial 3x^2+15x-56 and the square of the binomial (x-8) as a polynomial in standard form.

tester [92]

Given:

Polynomial is $3x^2+15x-56$ .