Question

he will use the cet scores worksheet in data sets. descriptive statistics: note that the name of each function in excel is as given in the spreadsheet, except for the mean which uses the average function, and the range which is max - min. enter the appropriate functions into the spreadsheet to compute the following, and write the formula you would type into excel after each definition (note there are 98 scores listed in column b and the cell range b4:b101 has been named scores). 1. mean the arithmetic average.

Explanation:

Step1: Recall Excel function for mean

The function to calculate the arithmetic - average (mean) in Excel is AVERAGE.

Step2: Use the named range

Since the cell range B4:B101 is named "scores", the formula to calculate the mean in Excel is =AVERAGE(scores).

Answer:

=AVERAGE(scores)