11 Descriptive Statistics in Excel
Below is a list of some of the formulae that makes Excel a good start to analysis.
|
Name |
Symbol |
Command |
Notes |
|
Mean |
μ or x̅ |
=AVERAGE(B2:B5) |
|
|
Median |
x̃ |
=MEDIAN(B2:B5) |
|
|
Mode |
M |
=MODE(B2:B5) |
Only returns one value! |
|
Standard Deviation |
s |
=STDEV.S(B2:B5) |
Sample only |
|
Standard Deviation |
σ |
=STDEV.P(B2:B5) |
Population, we rarely use this |
|
Range |
R |
=MAX(B2:B5) – MIN(B2:B5) |
|
|
Maximum |
|
=MAX(B2:B5) |
|
|
Minimum |
|
=MIN(B2:B5) |
|
|
Count |
N or n |
=COUNT(B2:B5) |
|
|
Sample Skew |
|
=SKEW(B2:B5) |
Population: SKEW.P() |
|
Kurtosis |
|
=KURT(B2:B5) |
|
|
Percentile |
Pn |
=PERCENTILE(B2:B5, 0.36) |
For P36
|
|
Quartile |
Qn |
=QUARTILE(B2:B5, 3) |
For Q3
|
|
Correlation |
r |
=CORREL(B2:B5,C2:C5) |
Or PEARSON() |
|
Covariance |
cov(X,Y) |
=COVARIANCE.S(B2:B5,C2:C5) |
Sample data! |
