Use these Excel functions to calculate common descriptive statistics from student-related datasets like grades, study hours, or survey responses.
| Statistic | Excel Function | Example |
|---|---|---|
| Mean (Average) | =AVERAGE(range) |
Average GPA of 5 students in A2:A6:=AVERAGE(A2:A6) |
| Median | =MEDIAN(range) |
Median study hours from B2:B10:=MEDIAN(B2:B10) |
| Mode | =MODE.SNGL(range) |
Most common quiz score in C2:C12:=MODE.SNGL(C2:C12) |
| Standard Deviation (sample) | =STDEV.S(range) |
Std dev of grades in D2:D20:=STDEV.S(D2:D20) |
| Variance (sample) | =VAR.S(range) |
Variance of test scores in E2:E20:=VAR.S(E2:E20) |
| Range | =MAX(range)-MIN(range) |
Range of weekly screen time:=MAX(F2:F12)-MIN(F2:F12) |
| Minimum | =MIN(range) |
Lowest midterm score:=MIN(G2:G15) |
| Maximum | =MAX(range) |
Highest final score:=MAX(H2:H15) |
| Count | =COUNT(range) |
Count how many students submitted homework:=COUNT(I2:I30) |
| Quartile | =QUARTILE.INC(range, quart) |
1st quartile of project grades:=QUARTILE.INC(J2:J25, 1) |
| Interquartile Range (IQR) | =QUARTILE.INC(range,3)-QUARTILE.INC(range,1) |
IQR for student GPAs:=QUARTILE.INC(K2:K20,3)-QUARTILE.INC(K2:K20,1) |
| Skewness | =SKEW(range) |
Skewness of class attendance:=SKEW(L2:L30) |
| Kurtosis | =KURT(range) |
Kurtosis of pop quiz scores:=KURT(M2:M30) |