Teach descriptive statistics in Excel in a very simple language

In this article, we will talk about descriptive statistics in Excel 2016. Descriptive statistics are used to quickly calculate numerical statistics such as mean, median, mode, standard deviation, range, minimum, maximum, and more in Microsoft Excel 2016.

We can use this tool to analyze performance rates, scores, scores and more.

The above may be confusing to some people, so let’s start with an example of ANOVA single factor . ( ANOVA: Single Factor : Analyzing the variance in which we have a dependent variable and an independent variable. For example, the dependent variable is blood pressure and the independent variable is the amount of salt consumption or a person’s weight.)

Here is a list of some points.

C: \ Users \ PC \ Desktop \ 12.png

In the tab, select Data > Data Analysis as shown below.

C: \ Users \ PC \ Desktop \ 23.png

Note: Can’t find data analysis button? Download the Analysis ToolPak plugin .

Click on Data Analysis to display its dialog box.

Now select Descriptive Statistics and click OK .

C: \ Users \ PC \ Desktop \ 32.png

The Descriptive Statistics dialog box appears. Fill in the options as shown below.

C: \ Users \ PC \ Desktop \ 41.png

Click OK to view details of your scores .

C: \ Users \ PC \ Desktop \ 52.png

As you can see, you can see the details of the entered data.

Leave a Reply

Your email address will not be published. Required fields are marked *