Excel Psychometric Statistics Calculator: Convert Normative Scores to Percentiles

Written By: S. Marc Testa, Ph.D.
Published On: 05/23/2016

Here is a calculator that converts the following to percentiles:

  • T (M=50, SD=10)
  • z (M=0, SD=1)
  • SS (M=100, SD=15)
  • ss (M=10, SD=3)

This simple, but EXTREME Excel calculator is meant to replace the lengthy traditional look-up table. An added benefit is that this spreadsheet allows the user to type or paste several raw scores at once and convert them into percentiles for eventual transfer or copying to a report. I have this spread sheet either open on my desktop or in dual view on an iPad Pro while creating tables for a report.

Similar Pages


twitter facebook

© 2012 - 2018 Neuropsych Now

Licensed under a Creative Commons Attribution-NC-ND 4.0 International License

Privacy · Terms