Descriptive Statistics: Provides summaries of data, ... Excel will generate a table with descriptive statistics, including mean, median, mode, standard deviation, and more.

You can generate these values individually, group them together and label them as appropriate to create a table of descriptive statistics. Open a spreadsheet and select an empty cell.

Find the Descriptive Statistics tool by clicking on Data and then Data Analysis in the ribbon. (Note: If you don’t have the Data Analysis option, you will need to install the Analysis ToolPak add-in.