STA1506
ASSIGNMENT 3
QUESTION 1
1.1
=AVERAGE(B2:B51)=75.22
=MEDIAN(B2:B51)=76
=MAX(B2:B51)-MIN(B2:B51)=43
=STDEV(B2:B51)=10.12
=STDEV(B2:B51)\ =AVERAGE(B2:B51)=0.13
=QUARTILE(B2:B51;1)=69
=QUARTILE(B2:B51;3)=81.75
1.2
Excel Analysis tool output : Descriptive statistics
Column1
Mean 75,22
Standard Error 1,43093804
Median 76
Mode 78
Standard Deviation 10,11825991
Sample Variance 102,3791837
-
Kurtosis 0,063227282
-
Skewness 0,246517467
Range 43
Minimum 51
Maximum 94
Sum 3761
Count 50
Largest(1) 94
Smallest(1) 51
Confidence
Level(95,0%) 2,87557765