Answer to Question #123370 in Statistics and Probability for ka

Question

In continuation with the data of performance scores of employees in previous example, perform the following:
a. Calculate the range and inter-quartile range
b. Calculate the z scores
c. Calculate the skewness and Kurtosis (using excel)
d. Comment on the distribution of the data
table below
52 33 70 95 57 61 47 60 57 64 54 94 38 61 89 48 50 39 94 63 59 31 88 46 68 88 93 48 82 82 72 73 74 70 92 76 98 91 80 68 32 33 31 75 54 48 62 53 36 64 63 66 92 98 91 42 36 54 71 86 84 55 33 43 91 34 64 67 89 78 47 62 97 92 53 56 68 55 36 67 93 42 51 77 36 93 51 66 44 66 63 33 68 79 92 76 83 53 86 76 35 40 43 46 55 41 36 39 42 96 42 77 60 53 38 51 95 56 93 63 48 69 49 33 95 37 83 64 83 62 96 34 85 32 40 85 39 59 77 62 35 34 39 92 54 89 36 45 83 34 86 90 39 61 88 86 55 33 77 40 69 54 30 38 79 77 44 59 95 34 38 91 80 90 58 40 88 45 95 71 80 43 89 53 61 40 31 61 58 53 88 94 91 63 60 94 98 53 53 45 50 34 75 74 90 98 87 66

Answer 1

a. Lowest value: 30

Highest value: 98

Range: 68

Lower quartile (xL): 45

Upper quartile (xU): 83

Interquartile range (xU-xL): 38

b. mean=63.351

sd=20.7

z-score for the first value equals to (52 -63.351)/20.7=-0.548

z-score for the last value equals to (66-63.351)/20.7=0.1279

c. using Excel:

Skewness: 0.09767

Kurtosis: -1.28542

d. mean closely equal to the median so we have normal distribution