T-score and Percentile Calculations | XM Community
Skip to main content
Question

T-score and Percentile Calculations


Forum|alt.badge.img+1

Hi,

 

I have one main question with 8 sub questions within it on a Likert Scale. I have the mean and SD from a separate survey and want to calculate the t-score and then percentile using that from all of the 8 variables and create the t-score and percentile as two new variables. Right now, I used the field editor to calculate the t-score since it's just a formula. however, I have the code for percentile and want to figure out how to embed that to create a variable. 

 

if (tScore >= 72) return 99; if (tScore == 71) return 98; etc. etc.

2 replies

  • Level 4 ●●●●
  • 194 replies
  • August 27, 2024

If you want to assign 99 in the new variable (if tscore >= 72), you can just use filter for that tscore  in data analysis and assign the value in the variable you need.

 

 


Nam Nguyen
QPN Level 8 ●●●●●●●●
Forum|alt.badge.img+28
  • QPN Level 8 ●●●●●●●●
  • 1090 replies
  • August 27, 2024
avimintz wrote:

Hi,

 

I have one main question with 8 sub questions within it on a Likert Scale. I have the mean and SD from a separate survey and want to calculate the t-score and then percentile using that from all of the 8 variables and create the t-score and percentile as two new variables. Right now, I used the field editor to calculate the t-score since it's just a formula. however, I have the code for percentile and want to figure out how to embed that to create a variable. 

 

if (tScore >= 72) return 99; if (tScore == 71) return 98; etc. etc.

Hi @avimintz 

Since t-score is a custom field product, you kinda can’t use it in other operation. So I suggest you to do everything within the survey flow

You can add some surveyflow element at the end https://www.qualtrics.com/support/survey-platform/survey-module/survey-flow/survey-flow-overview/#Introduction

With Math Operations, you can calculate t-score and use it in the future operation. (the syntax is a bit tricky, be patience)

With Branches and Embedded Data you can do some if else loop as you want and have a embedded field that represent percentile

Hope this helps


Leave a Reply