How to Calculate a Z-Score in Excel 2007

Written by jordan whitehouse
  • Share
  • Tweet
  • Share
  • Pin
  • Email
How to Calculate a Z-Score in Excel 2007
Put away your calculator and use Excel to determine your z-scores. (Comstock Images/Comstock/Getty Images)

A z-score, also called a "standard score" or a "z-value," is a statistical tool that tells the readers of your data how much a number deviates from a mean. To manually calculate a z-score, you'd have to subtract the mean from your data point and divide that result by the standard deviation. A much easier way to calculate z-scores is by using a function that is available to you in Microsoft Excel 2007.

Skill level:
Moderately Easy

Other People Are Reading

Instructions

  1. 1

    Open Excel 2007 and a blank spreadsheet.

  2. 2

    Enter all of your data in one column. Each separate piece of data should be in its own cell.

  3. 3

    Click on an empty cell within the spreadsheet and then calculate the mean of your data by entering an average function in the formula bar and hitting "Enter." The mean will be displayed in the empty cell. If your data was listed in cells B3 to B52, your function would look like this: "Average (B3:B52)."

  4. 4

    Click on another empty cell within your spreadsheet and then calculate the standard deviation of your data by entering a standard deviation function in the formula bar and hitting "Enter." If your data was listed in cells B3 to B52, your function would look like this: "STDEV (B3:B52)."

  5. 5

    Click on an empty cell in the spreadsheet and then click on the "fx" button, located beside the formula bar. Enter the cell number that you would like to calculate a z-score for in the "X" box. Enter the mean you calculated in Step 3 in the "Mean" box. Enter the standard deviation you calculated in Step 4 in the "Standard_dev" box.

  6. 6

    Click "OK." The z-score for the number you entered in the "X" box will be displayed in the empty cell you selected in Step 5.

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.