Question: Use the data below for Twentyfirst Century Laundry for the weights of loads of clothes processed through their washing department in a week. A) Apply
| Use the data below for Twentyfirst Century Laundry for the weights of loads of clothes processed through their washing department in a week. A) Apply the Excel Descriptive Statistics tool to compute the mean, standard deviation, and other relevant statistics, and interpret the results in a meaningful fashion. B) Use the Frequency Distribution and Histogram Excel template (on the next red worksheet tab or create on your own) to construct a frequency distribution and histogram for the data. From what type of distribution might you suspect the data are drawn? Experiment with the number of cells to create a visually appealing histogram and use the Excel Histogram tool to verify the results. Note: You may use the next worksheet tab template or create the descriptive statistics and histogram using the Excel tools. | |||||||||
| 69 | 3 | 1 | 72 | 93 | 3 | 80 | 6 | 5 | 36 |
| 42 | 2 | 64 | 44 | 15 | 77 | 49 | 85 | 82 | 102 |
| 28 | 70 | 41 | 30 | 25 | 45 | 31 | 49 | 49 | 49 |
| 13 | 42 | 27 | 13 | 45 | 31 | 14 | 34 | 32 | 39 |
| 19 | 29 | 12 | 19 | 30 | 14 | 21 | 14 | 14 | 52 |
| 7 | 13 | 18 | 8 | 14 | 19 | 18 | 21 | 21 | 5 |
| 94 | 19 | 6 | 107 | 19 | 2 | 41 | 7 | 15 | 15 |
| 53 | 8 | 90 | 55 | 2 | 64 | 16 | 12 | 27 | 53 |
| 35 | 16 | 35 | 38 | 3 | 9 | 9 | 9 | 11 | 39 |
| 16 | 17 | 18 | 23 | 74 | 25 | 26 | 58 | 59 | 62 |
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
