1. Excel functions to find descriptive statistics are:

a. Select Insert Function, and from the Or select a category list, select Statistical.

b. In the Select a function list, click AVERAGE, and click OK.

c. Enter the range in the Number1 box. Click OK. • For the median, use MEDIAN. • For the mode, use MODE.MULT (the dialogue box displays all modes). • For the population variance, use VAR.P. • For the sample variance, use VAR.S. • For the population standard deviation, use STDEV.P. • For the sample standard deviation, use STDEV.S.