Question

1,5, 14,1, 19, 15,30, 24,9,29,34, 10,25, 20,25 Using StatKey or other technology, find the following values for the above data. Click here to access StatKey (a) The mean and the standard deviation. Round your answers to one decimal place. mean standard deviation (b) The five number summary. Enter exact answers. The five number summary is

Answer 1

A ) Here we want to calculate mean and Standard deviation for given data

By using Excel we can calculate mean and SD as
Put all the data in excel worksheet then

For Mean

Excel command is    =Average(Select all the data values)

We get, Mean = 17.40 ...............( ANSWER)

For Standard deviation

Excel command is    =STDEV.S(Select all the data values)

we get , Standard deviation = 10.60    ...............( ANSWER)

=====================================================================

B ) Five number summary consists the following statistics

1 ) Minimum value

2 ) Maximum value

3) First quartile ( Q1 )

4) Second quartile ( Q2 )

5 ) Third quartile ( Q3 )

By using Excel we can calculate Five number summary as

Put all the data in excel worksheet then

Excel command is    =QUARTILE(Array,Quart)

By using the above command we can calculate the five number summary.

1 ) For Minimum value

Excel command is    =QUARTILE(Select all the data values,0)

we get  Minimum value = 1   ...............( ANSWER)

===========================================================

2 )

For First quartile ( Q1 )

Excel command is    =QUARTILE(Select all the data values,1)

we get  First quartile ( Q1 ) = 9.5 ...............( ANSWER)

================================================================

3 ) For Second quartile ( Q2 )

Excel command is    =QUARTILE(Select all the data values,2)

we get  Second quartile ( Q2 ) = 19 ...............( ANSWER)

=================================================================

4 ) For Third quartile ( Q3 )

Excel command is    =QUARTILE(Select all the data values,3)

we get  Third quartile ( Q3 )   = 25 ...............( ANSWER)

==============================================================================

4 ) For Maximum value

Excel command is    =QUARTILE(Select all the data values,4)

we get  Minimum value = 34 ...............( ANSWER)