In: Statistics and Probability
Find the Z-score farthest from 0 for these values. Would this value be considered an outlier? Why or why not?
| 7.82 |
| 8.21 |
| 8.9 |
| 8.61 |
| 7.18 |
| 7.63 |
| 8.94 |
| 8.44 |
| 8.43 |
| 8.2 |
| 7.5 |
| 8.57 |
| 8.79 |
| 7.53 |
| 8.86 |
| 8.88 |
| 7.73 |
| 6.78 |
| 8.07 |
| 7.96 |
| 8.3 |
| 8.43 |
| 9.06 |
| 9.85 |
| 8.93 |
| 7.44 |
| 9.19 |
| 8.75 |
| 7.86 |
| 8.39 |
| 7.68 |
| 7.18 |
| 8.24 |
| 6.93 |
| 9.01 |
| 6.5 |
| 7.79 |
| 9 |
| 7 |
| 5.02 |
| 6 |
| 8.33 |
| 9.05 |
| 7.46 |
| 8.49 |
| 9.14 |
| 8.42 |
| 8.52 |
| 8.39 |
| 8 |
| 7.25 |
| 7.81 |
| 8.8 |
| 10.45 |
| 9.61 |
| 8.16 |
| 7.04 |
| 8.26 |
| 8.75 |
| 7 |
| 7.64 |
| 7.98 |
| 8.55 |
| 7.32 |
| 6.36 |
| 9.19 |
| 7.93 |
| 6 |
| 7.83 |
| 6.14 |
| 7.89 |
| 7.5 |
| 7.54 |
| 8 |
| 7.93 |
| 7.43 |
| 7.63 |
| 7.83 |
| 8.18 |
| 8.24 |
| 7.4 |
| 8.34 |
| 8.46 |
| 8.66 |
| 8.57 |
| 8.23 |
| 7.05 |
| 7.96 |
| 7.71 |
| 8.82 |
| 7.68 |
| 8.27 |
| 5.75 |
| 6.9 |
| 7.43 |
| 7.6 |
| 8.46 |
| 8.09 |
| 7.13 |
| 9.8 |
Mean of values = 7.9993
Variance of values = 0.801093
Standard deviation of values = 0.895
( To obtain these values store values in excel from C2 to C101 in column X) and use the respective formula, mean : =AVERAGE(C2:C101), variance : =VARP(C2:C101), std deviation : =SQRT(C103)
and then obtain Z = ( X - mean )/SD
assign outlier if Z value is greater than +3 or less than -3
| X | Z | Status |
| 7.82 | -0.20033 | outlier |
| 8.21 | 0.235409 | not outlier |
| 8.9 | 1.006326 | not outlier |
| 8.61 | 0.682318 | not outlier |
| 7.18 | -0.91538 | not outlier |
| 7.63 | -0.41261 | not outlier |
| 8.94 | 1.051017 | not outlier |
| 8.44 | 0.492381 | not outlier |
| 8.43 | 0.481209 | not outlier |
| 8.2 | 0.224236 | not outlier |
| 7.5 | -0.55785 | not outlier |
| 8.57 | 0.637627 | not outlier |
| 8.79 | 0.883426 | not outlier |
| 7.53 | -0.52434 | not outlier |
| 8.86 | 0.961635 | not outlier |
| 8.88 | 0.983981 | not outlier |
| 7.73 | -0.30088 | not outlier |
| 6.78 | -1.36229 | not outlier |
| 8.07 | 0.078991 | not outlier |
| 7.96 | -0.04391 | not outlier |
| 8.3 | 0.335963 | not outlier |
| 8.43 | 0.481209 | not outlier |
| 9.06 | 1.18509 | not outlier |
| 9.85 | 2.067734 | not outlier |
| 8.93 | 1.039844 | not outlier |
| 7.44 | -0.62489 | not outlier |
| 9.19 | 1.330335 | not outlier |
| 8.75 | 0.838736 | not outlier |
| 7.86 | -0.15564 | not outlier |
| 8.39 | 0.436518 | not outlier |
| 7.68 | -0.35674 | not outlier |
| 7.18 | -0.91538 | not outlier |
| 8.24 | 0.268927 | not outlier |
| 6.93 | -1.1947 | not outlier |
| 9.01 | 1.129226 | not outlier |
| 6.5 | -1.67512 | not outlier |
| 7.79 | -0.23384 | not outlier |
| 9 | 1.118053 | not outlier |
| 7 | -1.11649 | not outlier |
| 5.02 | -3.32869 | outlier |
| 6 | -2.23376 | not outlier |
| 8.33 | 0.369482 | not outlier |
| 9.05 | 1.173917 | not outlier |
| 7.46 | -0.60254 | not outlier |
| 8.49 | 0.548245 | not outlier |
| 9.14 | 1.274471 | not outlier |
| 8.42 | 0.470036 | not outlier |
| 8.52 | 0.581763 | not outlier |
| 8.39 | 0.436518 | not outlier |
| 8 | 0.000782 | not outlier |
| 7.25 | -0.83717 | not outlier |
| 7.81 | -0.2115 | not outlier |
| 8.8 | 0.894599 | not outlier |
| 10.45 | 2.738097 | not outlier |
| 9.61 | 1.799589 | not outlier |
| 8.16 | 0.179546 | not outlier |
| 7.04 | -1.0718 | not outlier |
| 8.26 | 0.291273 | not outlier |
| 8.75 | 0.838736 | not outlier |
| 7 | -1.11649 | not outlier |
| 7.64 | -0.40144 | not outlier |
| 7.98 | -0.02156 | not outlier |
| 8.55 | 0.615281 | not outlier |
| 7.32 | -0.75896 | not outlier |
| 6.36 | -1.83154 | not outlier |
| 9.19 | 1.330335 | not outlier |
| 7.93 | -0.07743 | not outlier |
| 6 | -2.23376 | not outlier |
| 7.83 | -0.18915 | not outlier |
| 6.14 | -2.07734 | not outlier |
| 7.89 | -0.12212 | not outlier |
| 7.5 | -0.55785 | not outlier |
| 7.54 | -0.51316 | not outlier |
| 8 | 0.000782 | not outlier |
| 7.93 | -0.07743 | not outlier |
| 7.43 | -0.63606 | not outlier |
| 7.63 | -0.41261 | not outlier |
| 7.83 | -0.18915 | not outlier |
| 8.18 | 0.201891 | not outlier |
| 8.24 | 0.268927 | not outlier |
| 7.4 | -0.66958 | not outlier |
| 8.34 | 0.380654 | not outlier |
| 8.46 | 0.514727 | not outlier |
| 8.66 | 0.738181 | not outlier |
| 8.57 | 0.637627 | not outlier |
| 8.23 | 0.257755 | not outlier |
| 7.05 | -1.06063 | not outlier |
| 7.96 | -0.04391 | not outlier |
| 7.71 | -0.32323 | not outlier |
| 8.82 | 0.916945 | not outlier |
| 7.68 | -0.35674 | not outlier |
| 8.27 | 0.302445 | not outlier |
| 5.75 | -2.51308 | not outlier |
| 6.9 | -1.22822 | not outlier |
| 7.43 | -0.63606 | not outlier |
| 7.6 | -0.44613 | not outlier |
| 8.46 | 0.514727 | not outlier |
| 8.09 | 0.101337 | not outlier |
| 7.13 | -0.97124 | not outlier |
| 9.8 | 2.011871 | not outlier |