In: Statistics and Probability
Miles |
40001 |
53402 |
53500 |
59817 |
59902 |
63436 |
64090 |
64342 |
64544 |
65605 |
66998 |
67998 |
69568 |
69922 |
71978 |
72069 |
73341 |
74276 |
74425 |
77098 |
77202 |
77437 |
77539 |
79294 |
82256 |
82464 |
85092 |
85288 |
85586 |
85861 |
86813 |
88798 |
89323 |
89341 |
89641 |
92609 |
92857 |
94219 |
95066 |
95774 |
97831 |
101769 |
102534 |
105662 |
109465 |
116269 |
116803 |
118444 |
121352 |
138114 |
Please find if there are any outliers in this data set using the Z-score. This must be done in excel so please show the formulas used!
Z-Score Formula:
where X is the Miles each values and is average of Miles data and is the Standard deviation of the Miles data.
So first calculate the Average and Standard deviation using formula in excel.
Where dollar sign using for fixed the position of Average and Standard deviation value.
I have write the formula of Z-score, Average and Standard Deviation in the square bracket:
If Z-Score less than -3, it's means there are outliers. but in our Z-score there is no value which is less than -3.
If Z-Score greater than +3, It's means there are outliers. But in our Z-Score there is no value which is greater than +3.
Therefore there is no outliers in Miles data.