Converting Variables into Z Scores in Excel

3,826 views · Published 25 June 2015 · 9:45 · Indexed 9 October 2026

Channel: Dr. Todd Grande · 2015 · Education

Watch on YouTube

This video demonstrates how to convert variables into Z scores in Microsoft Excel. Z scores have a mean of 0 and a standard deviation of 1 and allow comparisons between different assessment results.

More from this channel

• 27:55 Psychoactive Drug Usage by Disorder: An Overview for Counselors

  Dr. Todd Grande

  4,909 views · 28 November 2014

• 12:32 Substituting Values in Excel using the Index and Match Functions

  Dr. Todd Grande

  3,102 views · 12 March 2015

• 7:29 Transposing Arrays in Excel

  Dr. Todd Grande

  3,929 views · 29 March 2015

• 15:31 Substitute, Replace, and Find Functions in Excel

  Dr. Todd Grande

  368 views · 6 April 2015

• 9:28 Graphing a Frequency Distribution in Excel Using the "Histogram" Feature

  Dr. Todd Grande

  514 views · 25 May 2015

• 13:13 Conducting a T-Test using the T.TEST Function in Excel

  Dr. Todd Grande

  3,569 views · 14 June 2015

• 14:44 Creating and Interpreting Scatterplots in Excel

  Dr. Todd Grande

  1,388 views · 2 July 2015

• 8:02 Creating a User Defined Function to Convert Z Scores into T Scores in Excel VBA

  Dr. Todd Grande

  385 views · 7 July 2015