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

The Charleston family has less than 500 Dalmatians. There are six times as many Dalmatians with black spots on their right ears

ANEK [815]

Let x be the number of Dalmatians without black spots.
So, x+6x is close to 500, which means x=71.
71*7=497, which is the total number of Dalmatians.
Giving away 6% of this will give you around 467 Dalmatians left.

Answer:467 Dalmatians

7 0

3 years ago

Read 2 more answers

Daniel [21]

Answer:

a,c,d

Step-by-step explanation:

8 0

2 years ago

Which point is in the solution set of the given system of inequalities 3x+y>-3,x+2y<4

Dima020 [189]

Step 1. Solve both inequalities for $y$ :
$3x+y\ \textgreater \ -3$
$y\ \textgreater \ -3x-3$

$x+2y\ \textless \ 4$
$2y\ \textless \ -x+4$
$y\ \textless \ - \frac{1}{2} x+2$

Step 2. To check a point in the solution of the given system of inequalities, look for the intercepts of the lines $-3x-3$ and $- \frac{1}{2} x+2$ :

$y=-3x-3$ (1)
$y=- \frac{1}{2} x+2$ (2)

Replace (1) in (2):
$-3x-3=- \frac{1}{2} x+2$
Solve for $x$ :
$\frac{5}{2} x=-5$
$x=-2$ (3)

Replace (3) in (1):
$y=-3x-3$
$y=-3(-2)-3$
$y=6-3$
$y=3$

We can conclude that the point (-2,3) is in the solution of the system if <span>inequalities</span>; also any point inside the dark shaded area of the graph of the system of inequalities is also a solution of the system.