USING THE COMPUTER

EXCEL

• While Excel has the capability of producing many of the statistics in this chapter piecemeal, there is one Excel feature, Descriptive Statistics, that produces many of these statistics in one output.
• To use the Descriptive Statistics feature, begin by selecting the Data tab on the Excel worksheet. From the Analysis panel at the right top of the Data tab worksheet, click on Data Analysis. If your Excel worksheet does not show the Data Analysis option, then you can load it as an add-in following directions given in Chapter 2. From the Data Analysis pulldown menu, select Descriptive Statistics. In the Descriptive Statistics dialog box, enter the location of the data to be analyzed in Input Range. Check Labels in the First Row if your data contains a label in the first row (cell). Check the box beside Summary statistics. The Summary statistics feature computes a wide variety of descriptive statistics. The output includes the mean, the median, the mode, the standard deviation, the sample variance, a measure of kurtosis, a measure of skewness, the range, the minimum, the maximum, the sum and the count.