Homework SourseThe following is a sample of the Number of Days it takes to
The following is a sample of the Number of Days it takes to sell a new Car at xyz Please use Excel .
| 5 |
| 4 |
| 3 |
| 4 |
| 8 |
| 15 |
| 10 |
| 11 |
| 16 |
| 15 |
| 14 |
| 13 |
| 20 |
| 14 |
| 15 |
| 9 |
| 10 |
| 15 |
| 20 |
| 4 |
| 9 |
| 8 |
| 10 |
| 14 |
| 15 |
| 18 |
| 20 |
| 21 |
| 9 |
| 8 |
Solution
.............................................
..................................................
The Inter Quartile Range (IQR) is
IQR =Q3 - Q1= 15 - 8.25 = 6.75
Q1 = FIRST QUARTILE OF THE DATA
Q3 = THIRD QUARTILE OF THE DATA
| Mean | 11.9 |
| Standard Error | 0.954541474 |
| Median | 12 |
| Mode | 15 |
| Standard Deviation | 5.228238973 |
| Sample Variance | 27.33448276 |
| Kurtosis | -0.888561151 |
| Skewness | 0.009523982 |
| Range | 18 |
| Minimum | 3 |
| Maximum | 21 |
| Sum | 357 |
| Count | 30 |
