We have all the company employees’ salary, age, and gender information in an Excel spreadsheet. Let us look at some advanced descriptive statistics in Excel examples for clear understanding: Example #1: Descriptive Statistics of Human Resources, Including the HeadersĬonsider the following human resource data of a textile company.

Thus, we can calculate descriptive statistics in Excel using Analysis ToolPak to summarize the dataset. The highest score (largest value) is 97, and the lowest (smallest value) is 42. Step 8: Click OK to get the results using descriptive statistics in excel.Īs shown in the above image, we have obtained all kinds of descriptive statistics for the given data (students’ scores). We can also choose all four options in Excel. Step 7: Select any one of the statistics options as required. Step 6: For Output Range, choose the cell where we want to place our descriptive statistics result. Since we have selected the input range without headers, we can ignore the Labels in First Row check box. Step 5: For Input Range, choose the Score column, i.e., the cell range B2:B11. Step 4: The Descriptive Statistics window pops up. Choose ‘ Descriptive Statistics’ and click OK. Step 3: The ‘ Data Analysis’ window with a list of ‘ Analysis Tools’ options appears. Step 2: Select the ‘ Data Analysis’ option under the Data tab. We will run descriptive statistics in Excel with the following steps:

Choose ‘Analysis ToolPak.’Ĭlick OK to enable the Data Analysis option under the Data tab.įollowing is the table with a list of scores obtained by students in an examination. You can see a list of available add-ins options. Click on Excel Add-ins from the ‘Manage’ drop-down.Choose ‘Add-ins’ in the window as highlighted below. Once you select ‘Options,’ the ‘Excel Options’ window pops up.

Likewise, we can perform a whole set of descriptive statistics in Excel using the Analysis ToolPak. For instance, the range will show us the highs and lows of the data set.

Variance, Range, and Standard Deviation mainly show how data dispersion affects the data set’s mean.

Mode, Mean, and Median functions to find the distribution by various points.

MIN, MAX, COUNT, Frequency, and Percent functions show how often a value occurs in the dataset.

In this sense, Excel has the following formulas to perform descriptive statistical calculations: The quantitative analysis of the data set is calculated by describing the relationship between one variable with another. The function simplifies lengthy worksheets and enables users to understand the data better. The values can be a collection of opinions or observations. Descriptive statistics in Excel summarizes and organizes the values of a given dataset.

Descriptive statistics excel mac