Excel Psychometric Statistics Calculator: Convert Normative Scores to Percentiles
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.