Scores Obtained
Student A Student B
92 50 Student A
71 79
53 50 Mean 71.65957
86 71 Standard Error 2.236125
75 71 Median 74
63 62 Mode 92
66 50 Standard Deviation 15.3301
64 64 Sample Variance 235.012
82 70 Kurtosis -1.061244
46 85 Skewness -0.184879
48 53 Range 49
47 77 Minimum 46
76 64 Maximum 95
69 58 Sum 3368
94 50 Count 47
74 54
48 81
49 74
80 63
68 63
70 59
76 89
63 90
92 63
83 51
73 77
95 75
71 53
92 75
94 66
74 74
54 92
51 86
58 80
76 85
80 72
78 72
75 84
86 47
71 63
53 45
91 80
51 85
47 76
78 63
94 49
91 48
Student B Descriptive statistics provide a summary o
Mean 67.82979 Why Do We Use Descriptive Statistics i
Standard Error 1.961073
Median 70 1. Quick Data Summary – Instead of calculating each function
Mode 63
Standard Deviation 13.44444 2. Understand Distribution – Helps to know whether your data
Sample Variance 180.753
Kurtosis -1.146396 3. Detect Outliers – By looking at min, max, and standard devia
Skewness -0.035691
Range 47 4. Decision Making – Businesses use it to see sales performanc
Minimum 45
Maximum 92
Sum 3188
Count 47
provide a summary of dataset
escriptive Statistics in Excel?
ead of calculating each function separately, you get everything in one report.
Helps to know whether your data is spread out, symmetric, skewed, etc.
at min, max, and standard deviation.
es use it to see sales performance, quality control, customer behavior, etc.