How to Use Descriptive Statistics in Excel

Written by stephanie ellen
  • Share
  • Tweet
  • Share
  • Pin
  • Email
How to Use Descriptive Statistics in Excel
Descriptive statistics helps you to make sense of numbers. (numbers image by Amer Delibasic from Fotolia.com)

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:
Moderate

Other People Are Reading

Things you need

  • Excel 2007 or Excel 2010

Show MoreHide

Instructions

  1. 1

    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.

  2. 2

    Click on a blank cell in a spreadsheet.

  3. 3

    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.

  4. 4

    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.

  5. 5

    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.

Don't Miss

Filter:
  • All types
  • Articles
  • Slideshows
  • Videos
Sort:
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the eHow.co.uk site, you consent to the use of cookies. For more information, please see our Cookie policy.