Descriptive Statistics
Assuming a sample of data in range x
Sample total, $$\sum $$x =SUM(x) Sample size, n =COUNT(x) Sample mean, $$\sum $$x/n =AVERAGE(x) Sample variance, s2 =VAR(x) Sample standard deviation, s =STDEV(x) Mean squared deviation =VARP(x) Root mean squared deviation =STDEVP(x) Corrected sum of squares, Sxx =DEVSQ(x) Raw sum of squares, $$\sum $$x2 =SUMSQ(x) Minimum value =MIN(x) Maximum value =MAX(x) Range =MAX(x)-MIN(x) Lower Quartile, Q1* =QUARTILE(x, 1) Median, Q2 =MEDIAN(x) Upper Quartile, Q3* =QUARTILE(x, 3) Interquartile range, IQR =QUARTILE(x, 3) - QUARTILE(x, 1) Kth Percentile =PERCENTILE(x, K%) where K is a number between 0 and 100 Mode =MODE(x) Boxplot See http://www.coventry.ac.uk/ec/~nhunt/boxplot.htm *Note: There are several different definitions for the upper and lower quartiles, so the values calculated by Excel may not agree with your textbook or other statistical calculation tools.