How to Calculate a Z

1. Open Excel 2007 and a blank spreadsheet.
2. Enter all of your data in one column. Each separate piece of data should be in its own cell.
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. 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. 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. 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.