week3.xlsx

Descriptives

Enter the data in the blue highlighted area and the results will show in the yellow highlighted area.
Data
1 Mean 3.7500
1 Median 3.0000
2 Mode 1.0000 2 ERROR:#N/A ERROR:#N/A ERROR:#N/A (Returns more than one mode)
2 Sample Variance 7.9286
4 Sample Standard Deviation 2.8158
5 Population Variance 6.9375
6 Population Standard Deviation 2.6339 To find boundary for outliers
9 Range 8.0000
Count (n) 8.0000 1.5 IQR 6
Min 1.0000 Lower boundary Q1-1.5IQR -4.5000
Quartile 1 1.5000 Upper boundary Q3+1.5IQR 11.5000
Median 3.0000 Identify outliers in your given data set. If the data is not between the lower and upper boundary then it is an outlier
Quartile3 5.5000
Max 9.0000
Interquartile Range (IQR) 4.0000