Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Calculating T-SCORE inside Excel.

Posted on 2016-10-24
3
Medium Priority
?
1,043 Views
Last Modified: 2016-11-04
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
0
Comment
Question by:Wanu San
  • 2
3 Comments
 

Author Comment

by:Wanu San
ID: 41859558
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
 
LVL 23

Accepted Solution

by:
NBVC earned 2000 total points
ID: 41860277
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
 

Author Closing Comment

by:Wanu San
ID: 41875087
Thank you NBVC
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.
How can you see what you are working on when you want to see it while you to save a copy? Add a "Save As" icon to the Quick Access Toolbar, or QAT. That way, when you save a copy of a query, form, report, or other object you are modifying, you…

572 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question