Calculating T-SCORE inside Excel.

Hi

I need to calculate the T-SCORE Values that would represent the Values of

100 T-SCORE Value
90 T-SCORE Value
80 T-SCORE Value
70 T-SCORE Value
60 T-SCORE Value
50 T-SCORE Value
40 T-SCORE Value
30 T-SCORE Value
20 T-SCORE Value
10 T-SCORE Value
0 T-SCORE Value


based on the data that I have in Column J. The formulas needs to be kept inside the Orange Box in Column J itself. I have attached the sample excel sheet with the data.

Please check the following thread for reference -
https://www.experts-exchange.com/questions/28977913/What-is-the-Difference-between-Percentile-and-T-Score-where-to-use-which-one.html

I am using Excel 2016 Professional Plus x64

Thanks
T-Score.xlsx
Wanu SanAsked:
Who is Participating?
 
NBVCCommented:
As per Austin's reply in your link on your original question, you just need to multiply your Z-Score by 50 and add 10 to get the T-Score.

so  formula: =ZScoreResult*50+10
1
 
Wanu SanAuthor Commented:
Can someone please provide the exact syntax for T-Score Calculation in Excel, just as crystal provided the one for Z-SCORE, in this link -
https://www.experts-exchange.com/questions/28978630/Calculating-Z-SCORE-inside-Excel.html

Or if it is not directly possible to be calculated within Excel ?

Thanks for any ideas.
0
 
Wanu SanAuthor Commented:
Thank you NBVC
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.