T-score and Percentile Calculations
How to automate conversion from a raw score to a percentile?
formula for converting percentile to T-score or z-score
t-score, z- score, P value calculator
Videos
I'm using Excel to score a psychometric test that I use. It's been working great and spits out the raw score. Now I'm trying to automate the next step, which is conversion from the raw score to a t-score/percentile. Right now, I need to manually look up the raw score each time and see what t-score it corresponds with. I’m hoping to automate that entirely.
This is an example of the conversion table: https://i.imgur.com/nJuGqiB.png.
I need something that can use the conversion table to convert the raw scores in each of these domains into percentiles,
Here's where I'm at right now: https://i.imgur.com/idrnz6O.png. I need to figure out how to get the t-score and percentile column to convert and fill automatically.
Would appreciate any pointers in how I go about automating this.