Solved

Calculating T-SCORE inside Excel.

Posted on 2016-10-24
3
364 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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 500 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

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Suggested Solutions

This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
Lithium-ion batteries area cornerstone of today's portable electronic devices, and even though they are relied upon heavily, their chemistry and origin are not of common knowledge. This article is about a device on which every smartphone, laptop, an…
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

734 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