A descriptive analysis is used to summarize the data. The summaries can tell us information about the data before formal modeling or hypothesis testing tasks.
There are several methods to create summaries using Excel depending on the level of insights you need. The most popular methods used are descriptive statistics, pivot tables, and histograms.
Descriptive statistics are used to create a summary of the data. It simplifies data using certain indicators. The key indicators are mean, median, mode, standard error, variance, standard deviation, kurtosis, skewness and confidence levels.
Descriptive Statistics in Excel – Introduction
Descriptive Statistics – Explained
Here are is a video that explains how to work with Pivot Tables.
Pivot tables in Excel allow you to select specific rows and columns and summarize them in many ways. For example, you can see the number of values of a particular column, its sum, apply filters to it etc.
If we want a visual representation of a data summary in terms of its frequency, we use a Histogram.
Watch this video to master histograms under 8 minutes.
Download the Excel Workbook demonstrates the three topics from below!