Hi

I need some help to understand which formula in Excel I should use for:

1. Calculate the mean, median, and mode
2. Calculate the mean and median excluding the maximum value
3. Calculate the variance and range
4. Calculate the variance and the range excluding the maximum value

I have to following information:

Value of the product
6.65		Mean	14
6.66		Median	6.695
6.66		Mode	6.66
6.66		Excluded value mean
6.69		Excluded value median
6.69		Variance	0.001
6.69		Range
6.7		Excluded value variance
6.7		Excluded value range
6.7
6.71
6.71
6.74
6.74

Thank you!