STA1506 ASSIGNMENT 3 FULL DETAILED SOLUTIONS UNISA 2021

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