Descriptive statistics is the branch of statistics that describes a set of data in basic terms. A common example of a descriptive statistic is the mean, sometimes called an average, which is calculated by adding up all of the numbers in a data set and dividing by the number of items in the set. Instead of making tedious calculations like this by hand, you can use Excel functions to calculate descriptive statistics for you.
- Skill level:
Other People Are Reading
Things you need
- Excel 2007 or Excel 2010
Type your data into the spreadsheet. For example, you might type a list of heights into column A or a list of egg prices in column F.
Click on a blank cell in a spreadsheet.
Click on the "Formulas" tab on the Excel toolbar, then click on "More Functions" in the Function Library. Click on "Statistical" and then mouse over the function for a description, and if it is the function you need, click on it to open a dialogue box for the function. For example, "Median" returns the median, or the middle number in the data set.
Type the location of your data into the text box. For example, if your data is in cells A1 to A3, type "A1:A3" into the "Number 1" text box.
Click on the "OK" button. Excel will perform the calculation and return the answer in your chosen cell.
Tips and warnings
- You don't have to type the data into a single column. However, most of Excel's features use column entries for correct formatting. For example, if you want to create a graph from your data, your entries must be in column format in order for the graph to display correctly.
- 20 of the funniest online reviews ever
- 14 Biggest lies people tell in online dating sites
- Hilarious things Google thinks you're trying to search for