Now click on Input Range and highlight the scores in column A (i.e. A dialog box appears as in Figure 2.įigure 2 – Dialog box for Excel’s data analysis tool To use the tool, select Data > Analysis|Data Analysis and choose the Descriptive Statistics option. The output from the tool is shown in the right side of Figure 1. Excel provides a data analysis tool called Descriptive Statistics which produces a summary of the key statistics for a data set.Įxample 1: Provide a table of the most common descriptive statistics for the scores in column A of Figure 1.įigure 1 – Output from Descriptive Statistics data analysis tool
