Question

11	12	11	10	14	15	16	12	11	10	12
20	13	32	35	14	41	12	10	11	12	12
13	16	14	17	18	19	12	13	14	10	10
14	11	10	12	14	12	13	16	14	17	19
20	15	25	15	45	45	44	41	40	14	18
19	24	20	26	36	34	30	31	50	15	12

Find the following:

Mean? (1) Median (2), and Mode?

Find : Q3, Q1, D7, D9, P3, P30, P28, P88, P98

Answer 1

We Find All these Values using Excel Commands

First Put All The Data in a Single column Like in A and Name the Column as 'x'.

and whenever we write Command select all the values in a column 'x'.

So therefore for Mean, Command is "=average(x)"

So therefore we get Mean=19.29

For Median, Command is "=Median(x)"

Median = 14.5

For Mode, Command is "=Mode(x)"

Mode=12

For Q3, The Command is "=Quartile(x,3)"

We get, Q3=20

For Q1, The Command is "=Quartile(x,1)"

We get, Q1= 12

For D7 We can use Percentile command as P70, because there is no command for Deciles.

So therefore, Command is "=Percentile(x,0.7)"

here 0.7 because of 70th percentile which is nothing but 7th Decile i.e. D7

We get, D7=19

For D9, The Command is "=Percentile(x,0.9)"

We get, D9=38

For P3, The Command is "=Percentile(x,0.03)"

0.03 because we want 3rd Percentile.

So therefore, P3=10

For P30, The Command is "=Percentile(x,0.3)"

We get, P30=12

For P28 , "=Percentile(x,0.28)"

We get, P28=12

For P88, "=Percentile(x,0.88)"

We get, P88=35.2

For P98, "=Percentile(x,0.98)"

We get, P98=45