T-score and Percentile Calculations | XM Community
Skip to main content
Michael_Cooksey
Administrator
11 days ago
Question

T-score and Percentile Calculations

A
Level 1 ●
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

    J
    Level 4 ●●●●
    • jbk
    • 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
    • Nam Nguyen
    • QPN Level 8 ●●●●●●●●
    • 1091 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

    Nam Nguyen - XM Technology Consultant | DXCON Vietnam

    Leave a Reply


    Terms & Conditions