What is Descriptive Statistics in Excel?

Summarizing available information in statistics is known as descriptive statistics. In Excel, we also have a function for descriptive statistics. This inbuilt tool is located in the “Data” tab, and then in the “Data Analysis,” we will find the method for the descriptive statistics. This technique also provides us with various types of output options.

Steps to Enable Descriptive Statistics in Excel

How to use Descriptive Statistics in Excel?

Example #1

Now, let us look at the simple data from a test, which includes the scores of 10 students. Using this data of scores, we need descriptive statistics data analysis.

  • First, we must go to “File” and then “Options.” Next, we need to go to “Add-ins.” We may see all the inactive applications under “Add-ins” on the right-hand side. Select “Analysis Toolpak” and click on “Go.” Now we must see the “Data Analysis” option under the “Data” tab. We must click on “Data Analysis.” Thus, we may see all the available analysis techniques like Anova, T-Test, F-Test in Excel, Correlation, Histogram, Regression, Descriptive Statistics, and many more. Now, we will have all the add-ins available for Excel. Select “Analysis ToolPak” and click on “OK.”

We must click on “Data Analysis.” Thus, we may see all the available analysis techniques like Anova, T-Test, F-Test in Excel, Correlation, Histogram, Regression, Descriptive Statistics, and many more.

We must first copy this data to our Excel sheet.

  • Step 1: Then, Go to Data > Data Analysis.

  • Step 2: On clicking on “Data Analysis,” we get the list of all the available analysis techniques. After that, scroll down and select “Descriptive Statistics.”

  • Step 3: Under “Input Range,” select the ” Scores range,” including the heading. Then, check “Labels in the first row”, choose “Output Range,” give cell referenceCell ReferenceCell reference in excel is referring the other cells to a cell to use its values or properties. For instance, if we have data in cell A2 and want to use that in cell A1, use =A2 in cell A1, and this will copy the A2 value in A1.read more as D1 and check summary statistics.

  • Step 4: Next, we must click on “OK” to complete the task. In the D1 cell, we may see the summary report of descriptive statistics data analysis.

We got all kinds of statistical results from the selected data, i.e., scores.

The average score (mean) is 70.2, the standard deviation is 15.97. Also, the minimum score is 46. At the same time, the maximum score is 91. So, the total score sum is 702, and the total number of students in this sample is 10. Like this, we have all kinds of statistical results.

Example #2

We have learned how descriptive statistics works in the previous example. Download the workbook to this descriptive statistics in Excel.

We have a list of students, their age, gender, height, weight, weekly hours of study, and recent examination score details for a few students.

We have as many as five different categories to tell the statistical results. Therefore, we can conduct a descriptive statistical analysis to find all these.

  • Step 1: We mustgo to Data > Data Analysis.

  • Step 3: Under “Input Range,” we must select all the category ranges, including headings, i.e., C1:G26.

We can get the summary result in the same worksheet, different worksheets, and different workbooks. Then, based on the selection we give, it will show the summary report. We have demonstrated the summary in the same worksheet, i.e., from the J1 cell.

Since we have selected the headings, we need to tick the checkbox “Labels in the first row.” Because we have chosen the headers, it will be helpful while showing the results. Otherwise, understanding each category’s results would not be very clear.

And then tick the Summary Statistics option.

  • Step 4: After that, we must click on “OK” to compete for the test. We will get the descriptive statistics results from the J1 cell.

It has shown up all the statistical results for all five categories. So, for example, the total number of students is 25, the average age is 26.64, the average height is 5.244, the average weight is 67.44, and the average exam score is 57.8, which is relatively low compared to modern-day standards and many other results.

Things to Remember

  • Descriptive statistics in Excel is a bundle of many statistical results.“Label as first row” means the data range we have selected includes headings.We can find the average value using an AVERAGE in excelAVERAGE In ExcelThe AVERAGE function in Excel gives the arithmetic mean of the supplied set of numeric values. This formula is categorized as a Statistical Function. The average formula is =AVERAGE(read more function like this maximum value by MAX and minimum value by MIN functions.It will display the SUMMARY based on the selection we make.

This article is a guide to Descriptive Statistics in Excel. Here, we discuss using descriptive statistics tools in Excel and practical examples, and downloadable Excel templates. You may learn more about Excel from the following articles: –

  • Examples of Regression FormulaExcel Correlation Matrix – ExamplesT-TEST Excel