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 |