Averages – Excel

Mean – arithmetic mean - Excel

=AVERAGE(range)

Median – middle point in a set of observations - Excel

=MEDIAN(range)

Mode – most common number in a set of observations - Excel

=MODE(range)

Weighted Average Mean – Excel

=SUMPRODUCT(A1:A2,B2:B3)/SUM(B2:B3)

	A Price	B Quantity
1	$50	10
2	$20	90

Geometric mean – Excel

=GEOMEAN(range)

Geometric mean can be used for a range of positive data in situations involving growth over time.