ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
2
Data Analysis Tool
Author: Dr. Martin Schrepp
3
The goal of this tool is to make the analysis of UEQ (User Experience Questionnaire) data as easy as possible for you. You simply enter the data obtained from your respondents into the Data worksheet. The tool then automatically calculates all statistics necessary to interpret the results. In addition, several graphs are shown that you may want to use in your result presentations. Simply copy them to your word processor of presentation tool.
The instructions in this tool are in English. To make the interpretation of the results easier and to have the charts in your language you can switch the language in the following dropdown. This will only switch the items and scale names, not the instructions in the Excel.
4
5
Choose your Language: English
6
7
Please Note: Changing the language will show the UEQ items and the UEQ dimensions in the selected language. All other texts will remain in English.
8
9
The tool contains the following work sheets:
Data: Here you can enter the raw data of your evaluation. This is the only work sheet that you need to modify. Do not change the content of the other work sheets, you may destroy unintentionally some of the formulas in the cells!
DT: The order of the items (i.e. if the positive term is left or right in an item) is randomized in the questionnaire to minimized answer tendencies. Here the items are changed to a common order (negative term left, positive term right). The transformed data are used for all the further calculations.
Results: Main results of the questionnaire. Here the scale means and the mean and standard deviation per item are calculated.
Confidence_Intervals: Confidence intervals for the scale means and for the mean of each item are calculated.
Answer_Distributions: Here you can see the distributions of the answers (values 1 to 7) for the single items. This can help to find items that show a ploarization of opinions, i.e. where many negative and many positive answers can be found.
Scale_Consistency: Here the Cronbach-Alpha Coefficient and Guttmans Lambda2 coefficient per scale are calculated. Check here if the scales have a sufficiently high values. Scales with a small value (<0.5) should be treated carefully in the interpretation (if you have only a small sample size (< 50 responses) then interpret these values very carefully. In such cases a small value for these coefficients may result solely from sampling effects and may not indicate a real problem.
Benchmark: The benchmark shows you in an easy way how good the evaluated product is compared to the products in the benchmark data set. There is also a graphic that shows for each scale how the results are related to the products in the benchmark data set.
Inconsistencies: On this work sheet the data are analysed for inconsistent answers, i.e. answers from participants that answered at least a part of the items randomly. You may want to remove these data before you calculate the results.
Sample_Size: If you observe big error bars concerning the scale means you may ask yourself if you need to collect additional data. This sheet helps you to estimate how many data you need in order to reach a certain precision.
KPI_Calculation: There is an extension of the UEQ with 6 additional questions. This extension allows to calculate a KPI (single number representing the overall user experience). This work sheet is only relevant if you used this extension. It allows to enter the data obtained for the 6 additional questions and calculates the KPI.
Items: Contains the item and dimension names in the different languages. Used for switching the language. Please do not modify date in this sheet.
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100