Question: Problem 4-5 Datacrackers, Inc. Datacrackers, Inc., generated preliminary data from a client's process as found in the data below. A) Apply the Excel Descriptive Statistics
| Problem 4-5 | Datacrackers, Inc. |
| |||||||||
| Datacrackers, Inc., generated preliminary data from a client's process as found in the data below. 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 (found on the next worksheet tab) 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. Interpret your results from parts A and B for managerial purposes. |
| ||||||||||
| 2.5 | 3.9 | 3.8 | 4.9 | 3.6 | 3.5 | 2.9 | 3.8 | 2.5 | 1.9 | ||
| 4.9 | 4.4 | 3.6 | 4 | 2.4 | 4 | 2.4 | 4.1 | 3.4 | 3 | ||
| 3.6 | 3.9 | 2.5 | 4.2 | 3.1 | 4.1 | 5 | 1.7 | 3.3 | 4.5 | ||
| 4.3 | 3.1 | 4 | 2.4 | 5 | 3.7 | 3 | 4.3 | 3.8 | 4 | ||
| 1.9 | 2.7 | 3.8 | 4.4 | 2 | 4.5 | 4.1 | 4.7 | 2.6 | 4.6 | ||
| 3.9 | 3.7 | 4 | 3.5 | 4.3 | 3.7 | 3.8 | 3.2 | 2.5 | 4.6 | ||
| 3.2 | 3.6 | 3.2 | 4.8 | 5 | 2.8 | 3.8 | 3.1 | 3 | 3.9 | ||
| 4 | 3.7 | 3.5 | 5 | 3.9 | 3.4 | 3.2 | 3.6 | 4.3 | 1.7 | ||
| 3.1 | 4.9 | 2.6 | 3.5 | 3.5 | 2.8 | 4.3 | 2.3 | 3.8 | 3.9 | ||
| 3.6 | 3.6 | 3.7 | 3.2 | 5.3 | 2.5 | 3.2 | 3.4 | 3.4 | 4.3 | ||
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
Study Help