descriptive statistics

What is Descriptive Statistics: How to calculate it in excel using the Data Analysis Tool Pack

What is descriptive statistics

Descriptive statistics are used to describe, show or summaries the basic features of a data set in a meaningful way. It provides basic summaries of the data like mean, median etc. It is very useful as if we only present data it wouldn’t make any meaning but while using descriptive analysis the same data can be presented in a very meaningful way.

How to use Descriptive Statistics in Excel

To use Descriptive Statistics in Excel we will use Data Analysis tool pack. First we will go in Data tab Data Analysis. After clicking Data Analysis a new box will come like below image.

What is Descriptive Statistics
What is Descriptive Statistics

This tool box contains different options like Descriptive … Continue Reading