Microsoft Excel for statistics > Excel Descriptive Statistics
Watch the video or read the article below:
Excel Descriptive Statistics: Overview
- The mean, mode, median and range.
- Variance and standard deviation.
- Count, maximum and minimum.
Using the descriptive statistics feature in Excel means that you won’t have to type in individual functions like MEAN or MODE. One button click will return a dozen different stats for your data set. If you want to calculate Excel descriptive statistics, you must have the Data Analysis Toolpak loaded in Excel. Click the “Data” tab in Excel. If you don’t see “Data analysis” on the right of the toolbar, you need to load the Toolpak first. See: Load the Excel Data Analysis Toolpak.
How to Calculate Excel Descriptive Statistics: Steps
Step 1: Type your data into Excel, in a single column. For example, if you have ten items in your data set, type them into cells A1 through A10.
Step 2: Click the “Data” tab and then click “Data Analysis” in the Analysis group.
Step 3: Highlight “Descriptive Statistics” in the pop-up Data Analysis window.
Step 4: Type an input range into the “Input Range” text box. For this example, type “A1:A10” into the box.
Step 5: Check the “Labels in first row” check box if you have titled the column in row 1, otherwise leave the box unchecked.
Step 6: Type a cell location into the “Output Range” box. For example, type “C1.” Make sure that two adjacent columns do not have data in them.
Step 7: Click the “Summary Statistics” check box and then click “OK” to display Excel descriptive statistics. A list of descriptive statistics will be returned in the column you selected as the Output Range.
That’s how to calculate Excel Descriptive Statistics!
Check out our YouTube channel for more Excel stats tips.
If you prefer an online interactive environment to learn R and statistics, this free R Tutorial by Datacamp is a great way to get started. If you're are somewhat comfortable with R and are interested in going deeper into Statistics, try this Statistics with R track.Comments are now closed for this post. Need help or want to post a correction? Please post a comment on our Facebook page and I'll do my best to help!