University of Windsor Pivot Table Excel Quiz If you look at the 2 practice files, your completed assignment should look like the ‘practice’ file containing | Course Hero

University of Windsor Pivot Table Excel Quiz If you look at the 2 practice files, your completed assignment should look like the ‘practice’ file containing two versions of each of the pivot tables – one file with the copied and pasted123 Pivot tables which have already been created for you, and, the completed file also containing the Pivot Tables that you would create that would have enabled you to create those copied Pivot tables.

One of the ‘practice’ files contains Pivot Tables which are Pivot tables that were copied and pasted123. The other ‘practice’ file contain Pivot Tables which were copied and pasted 123 and the original Pivot Tables that allowed us to create these copied and pasted123.

To complete your Excel quiz on Pivot Tables, you will be given a file containing an Excel file with the copied and pasted123 Pivot tables, and, you will be completing this file by creating the original Pivot Tables that were used to copy and paste123 these Pivot Tables. On completion of your quiz (and your assignment) your file should look like the ‘practice’ file with both the copied Pivot Tables and the original Pivot tables that you would have used to create the copied tables.

the document (pivot table assignment) is the assignment we need to deal with

the document (practice question) and (Practice SOLNS(2)) are example and solutions A
1
2
3
4
5
6
7
8
9
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
B
Version AAAA
C
D
E
F
G
H
I
home
Other
Other
Canada
Mich/Ohio
Ontario
Canada
Ontario
Other
Ontario
Mich/Ohio
Ontario
Mich/Ohio
USA
Mich/Ohio
Ontario
Canada
Canada
Mich/Ohio
Ontario
Other
Canada
Canada
Ontario
Mich/Ohio
Other
USA
USA
Canada
USA
Ontario
Mich/Ohio
Canada
Mich/Ohio
USA
USA
Other
Mich/Ohio
Mich/Ohio
USA
Other
Ontario
Mich/Ohio
Ontario
Mich/Ohio
Other
Canada
Ontario
Ontario
USA
USA
Other
Canada
Canada
Ontario
Canada
Mich/Ohio
USA
Ontario
Ontario
Mich/Ohio
Mich/Ohio
USA
USA
Mich/Ohio
Canada
Ontario
Other
Mich/Ohio
Canada
Mich/Ohio
Ontario
Canada
Other
USA
Mich/Ohio
Ontario
Other
Mich/Ohio
Ontario
Canada
USA
Other
Ontario
USA
Other
USA
Mich/Ohio
USA
Other
USA
Ontario
Mich/Ohio
Mich/Ohio
Mich/Ohio
Other
Other
reason
tourist
work
sports
tourist
sports
work
work
tourist
tourist
sports
work
work
sports
tourist
tourist
tourist
sports
on route
sports
sports
tourist
sports
tourist
sports
work
sports
work
sports
sports
sports
work
sports
on route
sports
tourist
sports
tourist
tourist
tourist
sports
on route
sports
tourist
tourist
tourist
sports
sports
work
work
sports
work
sports
sports
tourist
tourist
tourist
sports
tourist
tourist
tourist
sports
tourist
sports
sports
work
sports
on route
sports
sports
sports
tourist
tourist
sports
tourist
tourist
sports
work
work
sports
on route
sports
tourist
sports
sports
sports
sports
tourist
tourist
sports
on route
tourist
work
work
work
on route
tourist
others?
0
0
2
0
2
0
0
0
1
2
0
0
2
1
1
1
2
2
2
2
1
0
1
0
0
0
0
0
1
1
0
1
1
1
1
1
1
1
1
1
1
2
1
1
1
2
2
0
0
2
1
2
2
1
1
2
2
2
2
2
1
2
1
1
1
1
1
2
2
2
2
2
2
2
2
0
1
1
0
0
0
2
0
0
2
2
1
1
2
0
0
0
0
0
1
0
gender
female
female
female
male
female
female
female
male
male
female
female
female
female
male
male
male
male
female
male
male
male
male
male
male
female
male
female
male
male
male
female
male
female
male
male
male
male
male
male
male
female
male
male
male
male
male
male
female
male
male
male
male
male
male
male
male
male
male
male
male
male
male
male
male
male
male
female
female
female
female
male
male
female
male
male
female
male
male
female
female
female
male
female
female
female
female
male
male
female
female
female
female
female
female
female
female
nights
2
3
4
2
2
1
2
2
4
2
1
3
5
2
3
2
3
1
2
2
2
3
3
5
1
4
3
4
2
5
2
5
1
2
4
3
3
3
4
2
1
3
3
3
3
3
3
2
3
3
3
2
4
3
3
2
3
3
4
2
3
3
4
4
1
5
1
4
2
4
2
2
4
4
2
3
3
2
3
1
3
4
5
3
4
4
2
2
2
1
3
1
1
1
1
2
age
midage
midage
midage
midage
midage
midage
midage
midage
midage
midage
midage
midage
midage
young
midage
midage
midage
senior
midage
midage
midage
young
senior
midage
midage
midage
midage
young
midage
young
young
midage
young
midage
senior
midage
midage
young
midage
young
young
midage
young
midage
midage
midage
midage
young
midage
midage
senior
midage
midage
midage
senior
midage
midage
midage
midage
midage
young
midage
midage
young
senior
young
midage
midage
midage
midage
midage
midage
midage
midage
midage
young
midage
senior
young
senior
midage
midage
young
young
midage
midage
senior
midage
midage
midage
midage
midage
midage
midage
midage
senior
average daily
expenses
$87.10
$90.00
$162.00
$82.50
$121.00
$75.00
$93.00
$78.00
$113.10
$100.00
$95.00
$60.00
$135.00
$105.00
$115.50
$77.90
$123.40
$148.50
$102.70
$128.70
$92.50
$79.00
$118.00
$67.50
$71.50
$85.70
$78.25
$63.00
$115.50
$126.00
$81.00
$91.20
$95.80
$98.50
$111.60
$94.50
$86.30
$114.00
$108.20
$119.20
$115.70
$111.10
$93.00
$91.60
$109.00
$124.20
$121.90
$68.00
$69.00
$152.50
$128.40
$147.20
$149.00
$88.40
$94.80
$162.20
$104.00
$151.40
$153.60
$130.30
$101.00
$147.00
$81.00
$132.70
$94.00
$113.40
$84.00
$168.70
$137.00
$163.10
$102.80
$106.40
$139.40
$122.60
$128.40
$65.00
$103.40
$91.20
$68.00
$63.00
$72.00
$120.90
$98.30
$67.50
$151.40
$167.40
$86.50
$94.50
$127.10
$67.00
$83.40
$77.00
$70.00
$62.00
$129.10
$71.00
J
K
L
M
N
O
Row Labels
sports
tourist
work
on route
Grand Total
Count of reason
40
32
17
7
96
gender
male
Count of age
Row Labels
Canada
Mich/Ohio
Ontario
Other
USA
Grand Total
Column Labels
young
2
4
3
1
10
midage
8
8
8
6
11
41
senior
2
2
1
1
1
7
Grand Total
12
14
12
8
12
58
Count of reason
Row Labels
Canada
Mich/Ohio
Ontario
Other
USA
Grand Total
Column Labels
on route
6.25%
8.33%
4.76%
11.76%
5.56%
7.29%
sports
56.25%
29.17%
38.10%
35.29%
55.56%
41.67%
tourist
25.00%
37.50%
42.86%
29.41%
27.78%
33.33%
work
12.50%
25.00%
14.29%
23.53%
11.11%
17.71%
Row Labels
60-70
70-80
80-90
90-100
100-110
110-120
120-130
130-140
140-150
150-160
160-170
Grand Total
Count of average daily expenses
11
10
10
15
10
10
12
5
4
4
5
96
Average of average daily expenses
Row Labels
on route
sports
tourist
work
Grand Total
Column Labels
midage
$93.37
$122.16
$109.73
$78.68
$108.83
senior
$105.75
young
$105.75
$93.92
$104.00
$74.50
$94.76
Grand Total
$100.44
$114.40
$107.11
$82.75
$105.35
P
NAME
ID
1
2
3
4
5
6
7
8
9
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
$96.38
$104.53
$100.70
Grand Total
100.00%
100.00%
100.00%
100.00%
100.00%
100.00%
ID
1
2
3
4
5
6
7
8
9
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
language
French
Spanish
French
French
French
English
Spanish
French
French
Spanish
Spanish
English
Spanish
Spanish
English
English
English
Spanish
English
English
English
English
Spanish
English
English
French
Spanish
French
English
French
Spanish
English
English
English
French
English
French
Spanish
French
English
French
English
English
Spanish
gender
male
male
male
male
male
female
female
male
male
female
female
female
female
male
male
male
female
male
female
female
female
female
female
female
male
male
male
male
female
male
female
female
female
male
female
female
female
female
female
female
female
female
female
female
type
extensive
minimal
minimal
minimal
minimal
extensive
minimal
extensive
minimal
extensive
minimal
extensive
extensive
minimal
minimal
minimal
extensive
extensive
extensive
extensive
extensive
extensive
minimal
extensive
minimal
extensive
extensive
minimal
extensive
extensive
extensive
extensive
extensive
minimal
minimal
extensive
minimal
extensive
minimal
extensive
minimal
extensive
extensive
extensive
age
34
64
41
36
42
75
48
35
46
55
51
26
63
74
51
48
40
30
41
44
67
74
32
40
52
50
46
56
51
42
59
72
56
30
25
69
43
63
43
23
43
42
23
58
satisfaction
satis.
very sat.
satis.
satis.
satis.
very dis.
dissat.
satis.
satis.
dissat.
dissat.
very sat.
dissat.
very sat.
neutral
neutral
neutral
satis.
neutral
neutral
very dis.
very dis.
dissat.
neutral
neutral
satis.
satis.
satis.
neutral
satis.
dissat.
very dis.
neutral
neutral
very dis.
very dis.
very dis.
dissat.
very dis.
very sat.
very dis.
neutral
very sat.
dissat.
time
very long
short
short
long
long
very long
long
long
normal
very long
short
normal
long
normal
normal
short
long
long
very long
very long
normal
very long
normal
very long
normal
normal
normal
short
normal
very long
normal
very long
long
short
long
long
short
very long
normal
very long
normal
very long
very long
normal
amount in
dispute
6.6
71.3
136
115.1
50.5
126.3
74.6
151.7
76.4
132.1
193
193.9
154.9
186.6
122.2
145.2
43.1
17.9
107.8
154.5
125.4
159
194
92.6
52.4
119.8
114.1
99.7
71
162.4
82.2
74.2
11
187.1
169.3
146.2
105.3
131.5
99.4
133
185.8
154.2
19.4
6.3
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
English
French
French
English
Spanish
Spanish
English
Spanish
English
English
English
English
French
English
English
English
Spanish
French
English
Spanish
French
French
English
English
Spanish
Spanish
Spanish
English
English
English
Spanish
French
French
Spanish
English
Spanish
French
English
English
Spanish
Spanish
Spanish
Spanish
Spanish
Spanish
English
Spanish
female
male
female
female
male
male
female
female
female
female
male
male
male
female
female
female
male
female
female
male
male
male
male
female
female
male
female
male
female
female
female
male
male
male
male
female
male
male
male
female
male
male
male
female
female
female
male
extensive
minimal
minimal
extensive
extensive
minimal
extensive
extensive
extensive
extensive
extensive
minimal
minimal
extensive
extensive
extensive
minimal
minimal
extensive
minimal
extensive
minimal
extensive
extensive
extensive
extensive
minimal
minimal
extensive
extensive
extensive
extensive
extensive
extensive
minimal
extensive
minimal
extensive
minimal
extensive
minimal
extensive
extensive
extensive
minimal
extensive
minimal
75
58
38
72
44
69
30
57
75
68
46
51
60
75
68
66
71
37
70
51
37
51
41
75
57
38
25
30
71
67
69
46
35
34
42
56
58
48
64
63
73
40
28
58
32
63
72
very dis.
satis.
dissat.
very dis.
satis.
very sat.
very sat.
dissat.
very dis.
very dis.
satis.
neutral
satis.
very dis.
very dis.
very dis.
very sat.
dissat.
very dis.
very sat.
satis.
very sat.
satis.
very dis.
dissat.
satis.
dissat.
neutral
very dis.
very dis.
dissat.
satis.
satis.
very sat.
neutral
dissat.
very sat.
satis.
satis.
dissat.
very sat.
very sat.
very sat.
neutral
dissat.
dissat.
very sat.
short
short
normal
very long
long
long
normal
very long
long
very long
normal
short
normal
long
normal
short
normal
short
long
short
very long
short
normal
normal
short
normal
long
short
very long
very long
very long
normal
long
normal
long
very long
normal
normal
long
very long
long
long
short
very long
normal
normal
long
22.1
103.4
143.2
17.9
154.4
187
129.4
92.3
91.4
22.8
119.8
7.4
52
119.4
6.4
49
148
61.5
82.9
125.9
32.7
153
184.7
158.6
17.4
9.3
34.7
119.6
127
31.7
37.6
94.9
18.8
155
113.8
145.4
168.9
35.5
27.9
170.2
50.8
167.6
74.7
176.4
172.9
143.7
166.4
92
93
94
95
96
97
98
99
100
English
English
Spanish
Spanish
French
French
English
English
Spanish
female
female
female
female
female
male
female
female
male
extensive
extensive
minimal
extensive
minimal
minimal
extensive
extensive
extensive
70
75
31
59
24
50
30
68
69
very dis.
very dis.
very dis.
dissat.
very dis.
satis.
very sat.
very dis.
very dis.
long
long
short
long
long
long
very long
long
normal
85.4
41.4
150.6
111.2
95.4
47.6
21.6
58.9
165.7
Row Labels
English
Spanish
French
Grand Total
Count of language
43.00%
33.00%
24.00%
100.00%
Count of language
Row Labels
very dis.
dissat.
neutral
satis.
very sat.
Grand Total
Column Labels
English
44.19%
2.33%
32.56%
9.30%
11.63%
100.00%
French
20.83%
8.33%
0.00%
62.50%
8.33%
100.00%
Spanish
6.06%
48.48%
3.03%
12.12%
30.30%
100.00%
Count of gender
Row Labels
English
French
Spanish
Grand Total
Column Labels
female
32.00%
7.00%
18.00%
57.00%
male
11.00%
17.00%
15.00%
43.00%
Grand Total
43.00%
24.00%
33.00%
100.00%
Count of satisfaction
Row Labels
English
French
Spanish
Grand Total
Column Labels
very dis.
19
5
1
25
dissat.
1
2
16
19
neutral
7
very sat.
5
1
8
5
Average of amount in dispute
Row Labels
English
French
Spanish
Grand Total
Column Labels
female
$88.16
$122.84
$115.41
$101.02
male
$101.42
$93.50
$119.65
$104.65
Grand Total
$91.55
$102.06
$117.33
$102.58
Count of age
Column Labels
gender
Grand Total
26.00%
19.00%
15.00%
23.00%
17.00%
100.00%
female
Row Labels
20-29
30-39
40-49
50-59
60-69
70-80
Grand Total
female
10.53%
12.28%
15.79%
19.30%
21.05%
21.05%
100.00%
Row Labels
0-20
20-40
40-60
60-80
80-100
100-120
120-140
140-160
160-180
180-200
Grand Total
Count of amount in dispute
11
9
9
7
10
11
10
16
9
8
100
male
2.33%
23.26%
30.23%
23.26%
11.63%
9.30%
100.00%
Grand Total
7.00%
17.00%
22.00%
21.00%
17.00%
16.00%
100.00%
Grand Total
32
7
18
57
ID
1
2
3
4
5
6
7
8
9
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
language
French
Spanish
French
French
French
English
Spanish
French
French
Spanish
Spanish
English
Spanish
Spanish
English
English
English
Spanish
English
English
English
English
Spanish
English
English
French
Spanish
French
English
French
Spanish
English
English
English
French
English
French
Spanish
French
English
French
English
English
Spanish
gender
male
male
male
male
male
female
female
male
male
female
female
female
female
male
male
male
female
male
female
female
female
female
female
female
male
male
male
male
female
male
female
female
female
male
female
female
female
female
female
female
female
female
female
female
type
extensive
minimal
minimal
minimal
minimal
extensive
minimal
extensive
minimal
extensive
minimal
extensive
extensive
minimal
minimal
minimal
extensive
extensive
extensive
extensive
extensive
extensive
minimal
extensive
minimal
extensive
extensive
minimal
extensive
extensive
extensive
extensive
extensive
minimal
minimal
extensive
minimal
extensive
minimal
extensive
minimal
extensive
extensive
extensive
age
34
64
41
36
42
75
48
35
46
55
51
26
63
74
51
48
40
30
41
44
67
74
32
40
52
50
46
56
51
42
59
72
56
30
25
69
43
63
43
23
43
42
23
58
satisfaction
satis.
very sat.
satis.
satis.
satis.
very dis.
dissat.
satis.
satis.
dissat.
dissat.
very sat.
dissat.
very sat.
neutral
neutral
neutral
satis.
neutral
neutral
very dis.
very dis.
dissat.
neutral
neutral
satis.
satis.
satis.
neutral
satis.
dissat.
very dis.
neutral
neutral
very dis.
very dis.
very dis.
dissat.
very dis.
very sat.
very dis.
neutral
very sat.
dissat.
time
very long
short
short
long
long
very long
long
long
normal
very long
short
normal
long
normal
normal
short
long
long
very long
very long
normal
very long
normal
very long
normal
normal
normal
short
normal
very long
normal
very long
long
short
long
long
short
very long
normal
very long
normal
very long
very long
normal
amount in
dispute
6,6
71,3
136
115,1
50,5
126,3
74,6
151,7
76,4
132,1
193
193,9
154,9
186,6
122,2
145,2
43,1
17,9
107,8
154,5
125,4
159
194
92,6
52,4
119,8
114,1
99,7
71
162,4
82,2
74,2
11
187,1
169,3
146,2
105,3
131,5
99,4
133
185,8
154,2
19,4
6,3
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
English
French
French
English
Spanish
Spanish
English
Spanish
English
English
English
English
French
English
English
English
Spanish
French
English
Spanish
French
French
English
English
Spanish
Spanish
Spanish
English
English
English
Spanish
French
French
Spanish
English
Spanish
French
English
English
Spanish
Spanish
Spanish
Spanish
Spanish
Spanish
English
Spanish
female
male
female
female
male
male
female
female
female
female
male
male
male
female
female
female
male
female
female
male
male
male
male
female
female
male
female
male
female
female
female
male
male
male
male
female
male
male
male
female
male
male
male
female
female
female
male
extensive
minimal
minimal
extensive
extensive
minimal
extensive
extensive
extensive
extensive
extensive
minimal
minimal
extensive
extensive
extensive
minimal
minimal
extensive
minimal
extensive
minimal
extensive
extensive
extensive
extensive
minimal
minimal
extensive
extensive
extensive
extensive
extensive
extensive
minimal
extensive
minimal
extensive
minimal
extensive
minimal
extensive
extensive
extensive
minimal
extensive
minimal
75
58
38
72
44
69
30
57
75
68
46
51
60
75
68
66
71
37
70
51
37
51
41
75
57
38
25
30
71
67
69
46
35
34
42
56
58
48
64
63
73
40
28
58
32
63
72
very dis.
satis.
dissat.
very dis.
satis.
very sat.
very sat.
dissat.
very dis.
very dis.
satis.
neutral
satis.
very dis.
very dis.
very dis.
very sat.
dissat.
very dis.
very sat.
satis.
very sat.
satis.
very dis.
dissat.
satis.
dissat.
neutral
very dis.
very dis.
dissat.
satis.
satis.
very sat.
neutral
dissat.
very sat.
satis.
satis.
dissat.
very sat.
very sat.
very sat.
neutral
dissat.
dissat.
very sat.
short
short
normal
very long
long
long
normal
very long
long
very long
normal
short
normal
long
normal
short
normal
short
long
short
very long
short
normal
normal
short
normal
long
short
very long
very long
very long
normal
long
normal
long
very long
normal
normal
long
very long
long
long
short
very long
normal
normal
long
22,1
103,4
143,2
17,9
154,4
187
129,4
92,3
91,4
22,8
119,8
7,4
52
119,4
6,4
49
148
61,5
82,9
125,9
32,7
153
184,7
158,6
17,4
9,3
34,7
119,6
127
31,7
37,6
94,9
18,8
155
113,8
145,4
168,9
35,5
27,9
170,2
50,8
167,6
74,7
176,4
172,9
143,7
166,4
92
93
94
95
96
97
98
99
100
English
English
Spanish
Spanish
French
French
English
English
Spanish
female
female
female
female
female
male
female
female
male
extensive
extensive
minimal
extensive
minimal
minimal
extensive
extensive
extensive
70
75
31
59
24
50
30
68
69
very dis.
very dis.
very dis.
dissat.
very dis.
satis.
very sat.
very dis.
very dis.
long
long
short
long
long
long
very long
long
normal
85,4
41,4
150,6
111,2
95,4
47,6
21,6
58,9
165,7
Row Labels
English
Spanish
French
Grand Total
Count of language
43,00%
33,00%
24,00%
100,00%
Count of language
Row Labels
very dis.
dissat.
neutral
satis.
very sat.
Grand Total
Column Labels
English
44,19%
2,33%
32,56%
9,30%
11,63%
100,00%
French
20,83%
8,33%
0,00%
62,50%
8,33%
100,00%
Spanish
6,06%
48,48%
3,03%
12,12%
30,30%
100,00%
Count of gender
Row Labels
English
French
Spanish
Grand Total
Column Labels
female
32,00%
7,00%
18,00%
57,00%
male
11,00%
17,00%
15,00%
43,00%
Grand Total
43,00%
24,00%
33,00%
100,00%
Count of satisfaction
Row Labels
English
French
Spanish
Grand Total
Column Labels
very dis.
19
5
1
25
dissat.
1
2
16
19
neutral
7
very sat.
5
1
8
5
Average of amount in dispute
Row Labels
English
French
Spanish
Grand Total
Column Labels
female
$88,16
$122,84
$115,41
$101,02
male
$101,42
$93,50
$119,65
$104,65
Grand Total
$91,55
$102,06
$117,33
$102,58
Count of age
Column Labels
gender
Grand Total
26,00%
19,00%
15,00%
23,00%
17,00%
100,00%
female
Row Labels
20-29
30-39
40-49
50-59
60-69
70-80
Grand Total
female
10,53%
12,28%
15,79%
19,30%
21,05%
21,05%
100,00%
Row Labels
0-20
20-40
40-60
60-80
80-100
100-120
120-140
140-160
160-180
180-200
Grand Total
Count of amount in dispute
11
9
9
7
10
11
10
16
9
8
100
male
2,33%
23,26%
30,23%
23,26%
11,63%
9,30%
100,00%
Grand Total
7,00%
17,00%
22,00%
21,00%
17,00%
16,00%
100,00%
Row Labels
English
Spanish
French
Grand Total
Count of language
43,00%
33,00%
24,00%
100,00%
Count of language
Row Labels
very dis.
dissat.
neutral
satis.
very sat.
Grand Total
Column Labels
English
44,19%
2,33%
32,56%
9,30%
11,63%
100,00%
Count of gender
Row Labels
English
French
Spanish
Grand Total
Grand Total
32
7
18
57
Column Labels
female
32,00%
7,00%
18,00%
57,00%
gender
female
Count of satisfaction
Row Labels
English
French
Spanish
Grand Total
Column Labels
very dis.
19
5
1
25
Average of amount in dispute
Row Labels
English
French
Spanish
Grand Total
Count of age
Column Labels
female
$88,16
$122,84
$115,41
$101,02
Column Labels
French
20,83%
8,33%
0,00%
62,50%
8,33%
100,00%
Spanish
6,06%
48,48%
3,03%
12,12%
30,30%
100,00%
male Grand Total
11,00%
43,00%
17,00%
24,00%
15,00%
33,00%
43,00%
100,00%
dissat.
1
2
16
19
neutral
7
1
8
male Grand Total
$101,42
$91,55
$93,50
$102,06
$119,65
$117,33
$104,65
$102,58
Row Labels
20-29
30-39
40-49
50-59
60-69
70-80
Grand Total
Row Labels
0-20
20-40
40-60
60-80
80-100
100-120
120-140
140-160
160-180
180-200
Grand Total
female
10,53%
12,28%
15,79%
19,30%
21,05%
21,05%
100,00%
Count of amount in dispute
11
9
9
7
10
11
10
16
9
8
100
male Grand Total
2,33%
7,00%
23,26%
17,00%
30,23%
22,00%
23,26%
21,00%
11,63%
17,00%
9,30%
16,00%
100,00% 100,00%
Grand Total
26,00%
19,00%
15,00%
23,00%
17,00%
100,00%
very sat.
5
5
Grand Total
32
7
18
57

Purchase answer to see full
attachment