Please provide details on how to solve this problem if youre
Please provide details on how to solve this problem if you\'re using Excel or Minitab.
Solution
In excel paste the data in column A. Find the length of each cell using the command LEN.
Run Data analysis to obtain the discriptive staistics. To obtain quartile use the function quartile.EXC
| Average | 9.123349 | Standard Deviation | 2.81898 |
| Median | 9 | Mode | 8 |
| Ist Quartile | 7 | Mid range | 5 |
| 3rd Quartile | 11 | Mid hinge | 9 |
| Minmum | 1 | IQR | 4 |
| Maximum | 29 |
