Wanu San
asked on
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you NBVC
ASKER
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.