Calculations using Excel for Mathematics General and Standard.

Calculate summary statistics: mean, mode, median

Mean: =AVERAGE(B1:B4)

=AVERAGE(B1:B4)

Mode: =MODE(B1:B4)

=MODE(B1:B4)

Median: =MEDIAN(B1:B4)

=MEDIAN(B1:B4)

where B1:B4 is the range of cells containing numerical data.

B1:B4