System Usability Scale (SUS) study using Qualtrics and Excel

If you are here you probably have an idea what is System Usability Scale, if not there are plenty of information online to learn more about it. The problem with SUS is that it requires some calculation and I was not able to find a tool that can handle both Matrix survey and SUS calculations so I decided to come up with my own solution.

Like always I am using my blog as a note taking tool for my future reference, but if someone else find it useful, it will be my pleasure.

That’s what I did

1. Setup you Matrix survey on Qualtrics and publish it

2. Once you have some inputs from users, go to Data&Analysis =>Export Data => Excel => Download all fields

3. Open the file, select and copy all the responses to another Excel sheet.

Your another Excel sheet should look something like this.

Basically what we do here is using formula to match text with points:

Strongly Disagree: 1 point

Disagree: 2 points

Neutral: 3 points

Agree: 4 points

Strongly Agree: 5 points

Here is a formula I am using to convert text into points:

=IF(AND(B2=”Agree”), 4, IF(OR(B2=”Disagree”), 2, IF(OR(B2=”Strongly Disagree”), 1, IF(OR(B2=”Neutral”), 3, IF(OR(B2=”Strongly Agree”), 5)))))

Calculating X (odd):

=(SUM(L2,N2,P2,R2,T2))-5

Calculating Y (even):

=25-SUM(M2,O2,Q2,S2,U2)

Total SUS score

=(W2+V2)*2.5

Some resources I was using:

Simplifying Data Analysis: Mastering Excel's IF Statements with Multiple Conditions

System Usability Scale: What it is, Calculation + Usage

If you want to use my file, you can download it here