Batch Defects 1 1 2 2 3 4 4 4 5 5 6 5 7 6 8 7 9 9 10 9 11 12 12 12 13 15 14 17 15 20 16 21 17 23 18 23 19 25 20 26 21 27 22 27 23 28 24 29 25 29 construct a frequency distribution, a cumulative percentage distribution, and a combined histogram and cumulative percentage polygon in excel for the table.
| Batch | Defects |
| 1 | 1 |
| 2 | 2 |
| 3 | 4 |
| 4 | 4 |
| 5 | 5 |
| 6 | 5 |
| 7 | 6 |
| 8 | 7 |
| 9 | 9 |
| 10 | 9 |
| 11 | 12 |
| 12 | 12 |
| 13 | 15 |
| 14 | 17 |
| 15 | 20 |
| 16 | 21 |
| 17 | 23 |
| 18 | 23 |
| 19 | 25 |
| 20 | 26 |
| 21 | 27 |
| 22 | 27 |
| 23 | 28 |
| 24 | 29 |
| 25 | 29 |
construct a frequency distribution, a cumulative percentage distribution, and a combined histogram and cumulative percentage
A data can be raw or grouped, with some pro and cons associated with both of them. The raw data has each and every values and each value has some effect while in grouped data no matter what one does some information is always lost as we don’t have the exact value but the intervals.
It is one of the reason we can get different mean, median, mode or standard deviation with the same raw data which has been grouped in classes. If the data are in very huge amount then it is very difficult to analysis it in raw form but if it can be synthesis in grouped from then we can understand the behavior of data.
Step by step
Solved in 2 steps with 2 images
