370 83 169 70 137 69 18 72 126 15 2 2 4 47 63 12 13 147 41 44 76 47 22 178 250 3

Question

370 83 169 70 137 69 18 72 126 15 2 2 4 47 63 12 13 147 41 44 76 47 22 178 250 32 14 28 1 25 179 68 147 209 43 68 78 233 53 29 61 39 11 90 42 163 182 136 16 57 25 437 28 12 50 39 45 79 106 75 28 75 24 45 43 18 8 54 7 46 95 598 12 2 31 2 4 7 6 9 51 50 13 25 36 152 13 53 174 106 26 11 123 79 23 27 107 32 315 81 211 99 24 219 55 70 133 211 110 172 96 147 293 51 120 87 117 37 120 368 106 634 190 108 23 14 29 35 68 141 157 17 36 4 30 10 76 26 19 123 a. Calculate ALL summary statistics for the data using the Descriptive Statistics functionin Excel. Provide the entire table output from Excel. Include the 95% Confidence Level in the output. b. Construct a 95% confidence interval for the population mean number of production workers. c. Write your answer from part (b) in one sentence giving an appropriate interpretation for this estimate.

Explanation / Answer

ALL WORK DONE IN EXCEL

a) First copy and paste the data in excel spreadsheet. Then go to "Data" tab and then "Data Analysis" tab. Then a dialogue box will be opened. Select "Descriptive Statistics" and OK. Then in the input range select the data column, and check Summary statistics and Confidence Level for Mean (default is 95%), then click OK. You will get the output below.

b) Confidence interval for the population mean number of production workers :-

Using the "CONFIDENCE" function we get the 95% confidence interval for the population mean number of production workers (70.03398,103.8803), assuming the sample from Normal distribution.

c) I think the estimate of confidence interval is not a good one because the data here are much spread.

Column1 Mean 86.95714286 Standard Error 8.634426847 Median 52 Mode 2 Standard Deviation 102.1639162 Sample Variance 10437.46578 Kurtosis 10.32308766 Skewness 2.795676485 Range 633 Minimum 1 Maximum 634 Sum 12174 Count 140 Confidence Level(95.0%) 17.07179643

Related Questions

Navigate

• Browse (All)
• Browse 3
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.