Question

QUESTION

1. A reading program for fourth graders at Wiley Elementary School in Raleigh randomly selected 10 books from their recommended titles. The number of pages in each book is given below:

   176

   224

   175

   126

   80

   144

   194

   64

   198

   177

   What is the standard deviation of the number of pages in these books? (round to two decimal places)

QUESTION

1. The table below lists tap water lead content in parts per billion for 71 residences in Flint, MI, in 2015.

   0	104	10	6	5	0	3	0	13	4	2	2
   8	6	2	1	1	0	2	7	3	5	5	0
   0	5	5	42	22	8	20	6	2	5	3	2
   3	2	3	4	21	7	3	42	0	7	0	6
   28	18	1	2	3	1	5	0	3	10	2	3
   2	5	2	3	0	3	9	11	0	0	0

   Use Excel to calculate the following for this data set. Round all answers to two decimal places.

   Mean:

   Median:

   Mode:  

   Range:

   Standard Deviation:

QUESTION

1. The following data are the 2012-2013 salaries in thousands of dollars for 14 randomly selected Carolina Panthers football players:

   465	490	490	490	540	540	540
   700	770	1308	1500	2400	7750	8500

   Use Excel to calculate the following. Round all answers to two decimal places if they are not whole numbers. If there is no mode, write NONE for the mode.

   Mean:

   Median:

   Modes: (smaller) , larger

   Range:

   Standard Deviation:

QUESTION 8

1. The following data are the in-state tuition for a full time student at 15 randomly selected community colleges in North Carolina:

   1294	1090	1241	1074	1336
   1337	1452	1424	1344	1413
   1379	1380	1419	1414	1382

   Use Excel to calculate the following. Round to two decimal places for results that are not whole numbers. If there is no mode, write NONE for the mode.

   Mean:

   Median:

   Mode:

   Range:

   Standard Deviation:

Please, show me your all works. Thanks.

Answer 1

QUESTION 1

Let x be the number of pages in each book. Then Standard deviation of x is calculated by the below formula:

x
176	20.2	408.04
224	68.2	4651.24
175	19.2	368.64
126	-29.8	888.04
80	-75.8	5745.64
144	-11.8	139.24
194	38.2	1459.24
64	-91.8	8427.24
198	42.2	1780.84
177	21.2	449.44
1558		24317.6

= 155.8

=

=51.9803

Standard deviation of the number of pages in these books is 51.98

QUESTION 2

Enter the given data in the excel sheet. I have done it in cell A1 to A71. Now apply the below formula in any of the blank cells to get the answer. You will get the below answers once you apply the formula.

1. Mean: =AVERAGE (A1:A71) = 7.29
2. Median: =MEDIAN (A1:A71) = 3
3. Mode:  =MOD.SNGL(A1:A71) = 0
4. Range: =MAX (A1:A71)-MIN (A1:A71) = 104
5. Standard Deviation: = STDEV.S(A1:A71) = 14.33

QUESTION 3

Enter the given data in the excel sheet. I have done it in cell A1 to A14. Now apply the below formula in any of the blank cells to get the answer. You will get the below answers once you apply the formula.

1. Mean: =AVERAGE (A1:A14) = 1891.64
2. Median: =MEDIAN (A1:A14) = 620
3. Mode:  =MOD.SNGL(A1:A14) = 490,540
4. Range: =MAX (A1:A14)-MIN (A1:A14) = 8035
5. Standard Deviation: = STDEV.S(A1:A14) = 2700.87

QUESION 4

Enter the given data in the excel sheet. I have done it in cell A1 to A15. Now apply the below formula in any of the blank cells to get the answer. You will get the below answers once you apply the formula.

1. Mean: =AVERAGE (A1:A15) = 1331.93
2. Median: =MEDIAN (A1:A15) = 1379
3. Mode:  =MOD.SNGL(A1:A15) = NONE
4. Range: =MAX (A1:A15)-MIN (A1:A15) = 3778
5. Standard Deviation: = STDEV.S(A1:A15) = 115.19

This is how we can directly apply formula in excel and do the problems. Else we can follow the same method of problem 1 to calculate mean and standard devaition for all other questions also. To calculate median, we have to arrange the data in either ascending or descending order and then select the middle item. To calculate mode, we have to find the most frequently appearing observation. To calculate range we have to find the difference of the highest value and lowest value.