UMUX score calculator by UXtweak 🔧🐝.xlsx

	A	B	C	D	E	F	G	H	I
1	Created by UXtweak🔧🐝
2	Participant	Q1 Meets requirements	Q2 Frustrating (neg)	Q3 Ease of use	Q4 Too much correcting (neg)	Q2_R (reverse-coded)	Q4_R (reverse-coded)	Raw sum (Q1+Q2+Q3_R+Q4_R)	UMUX 0–100
3	P01	1	7	1	7	1	1	4	0.0
4	P02	5	2	1	7	7	6	13	37.5
5	P03	3	3	1	1	7	5	16	50.0
6	P04	6	7	1	1	7	1	15	45.8
7	P05	4	1	2	5	6	7	16	50.0
8	P06	3	7	1	1	7	1	12	33.3
9	P07	3	4	1	1	7	4	15	45.8
10	P08	2	7	1	3	7	1	9	20.8
11	P09	3	1	1	1	7	7	18	58.3
12	P10	3	1	5	1	3	7	22	75.0
13	P11	5	7	1	1	7	1	14	41.7
14	P12	3	4	1	1	7	4	15	45.8
15	P13	2	7	4	1	4	1	14	41.7
16	P14	3	6	1	2	7	2	12	33.3
17	P15	3	1	1	1	7	7	18	58.3
18	P16	2	7	1	1	7	1	11	29.2
19	P17	1	5	1	1	7	3	12	33.3
20	P18	3	1	1	1	7	7	18	58.3
21	P19	7	7	6	1	2	1	21	70.8
22	P20	1	7	1	7	7	1	4	0.0
23
24
25
26	Summary
27	Completed responses (rows with all 4 items):	20
28	Average UMUX (0–100):	41.5
29
30	Item means (1–7):
31	Q1 Useful	3
32	Q2 Easy	5
33	Q3 Frustrating (original)	2
34	Q3_R (reverse-coded)	6
35	Q4 Too much correcting (original)	2
36	Q4_R (reverse-coded)	3
37
38	Notes:
39	Enter integers 1–7. Q3 and Q4 are negatively worded; the sheet auto-reverse-codes.
40
41	*For a deeper explanation, read our article, Usability Metric for User Experience (UMUX) 101.
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