Question

Please download the file final.xlsx and refer to Worksheet A. The average (mean) quantity sold per transaction is _________. Round your answer to the nearest whole number, and enter just the number; e.g., enter 71.5 as 72.

Transaction number	Quantity	Unit price	Total
23	149	$               19.08	$        2,842.92
47	149	$               34.19	$        5,094.31
76	147	$               39.51	$        5,807.97
6	146	$               26.50	$        3,869.00
11	145	$               31.59	$        4,580.55
80	144	$               25.35	$        3,650.40
33	142	$               37.66	$        5,347.72
37	140	$               20.60	$        2,884.00
29	139	$               35.56	$        4,942.84
50	139	$               23.63	$        3,284.57
58	138	$               27.55	$        3,801.90
67	138	$               20.53	$        2,833.14
85	136	$               31.82	$        4,327.52
4	135	$               36.52	$        4,930.20
25	135	$               32.38	$        4,371.30
95	135	$               39.62	$        5,348.70
55	134	$               32.12	$        4,304.08
57	132	$               17.44	$        2,302.08
35	130	$               39.23	$        5,099.90
34	129	$               38.06	$        4,909.74
13	128	$               35.99	$        4,606.72
96	126	$               35.36	$        4,455.36
53	125	$               28.58	$        3,572.50
70	122	$               33.43	$        4,078.46
78	120	$               22.40	$        2,688.00
100	120	$               33.78	$        4,053.60
20	118	$               30.81	$        3,635.58
46	118	$               29.14	$        3,438.52
30	114	$               38.92	$        4,436.88
89	113	$               32.29	$        3,648.77
72	112	$               19.82	$        2,219.84
2	110	$               22.68	$        2,494.80
87	106	$               28.49	$        3,019.94
17	104	$               22.55	$        2,345.20
69	101	$               34.04	$        3,438.04
19	100	$               20.04	$        2,004.00
54	100	$               32.98	$        3,298.00
43	98	$               28.63	$        2,805.74
83	98	$               38.76	$        3,798.48
12	97	$               20.70	$        2,007.90
28	97	$               26.87	$        2,606.39
45	97	$               24.48	$        2,374.56
26	95	$               34.21	$        3,249.95
65	93	$               25.10	$        2,334.30
91	93	$               33.51	$        3,116.43
8	92	$               29.92	$        2,752.64
14	91	$               38.48	$        3,501.68
90	89	$               20.62	$        1,835.18
48	88	$               22.96	$        2,020.48
49	88	$               17.40	$        1,531.20
98	87	$               25.64	$        2,230.68
44	85	$               32.39	$        2,753.15
97	85	$               33.44	$        2,842.40
16	84	$               31.21	$        2,621.64
31	83	$               39.77	$        3,300.91
7	81	$               38.76	$        3,139.56
32	81	$               25.48	$        2,063.88
3	79	$               22.84	$        1,804.36
10	75	$               20.35	$        1,526.25
1	73	$               32.41	$        2,365.93
36	71	$               35.38	$        2,511.98
92	71	$               18.95	$        1,345.45
66	70	$               39.56	$        2,769.20
73	70	$               19.08	$        1,335.60
88	70	$               24.42	$        1,709.40
9	69	$               20.93	$        1,444.17
41	67	$               32.32	$        2,165.44
51	66	$               24.81	$        1,637.46
64	66	$               34.73	$        2,292.18
79	66	$               39.72	$        2,621.52
81	64	$               29.06	$        1,859.84
22	63	$               33.95	$        2,138.85
56	62	$               38.24	$        2,370.88
27	60	$               36.79	$        2,207.40
40	60	$               29.31	$        1,758.60
59	60	$               19.46	$        1,167.60
21	58	$               34.82	$        2,019.56
61	58	$               29.08	$        1,686.64
86	55	$               24.60	$        1,353.00
99	55	$               35.06	$        1,928.30
5	54	$               18.31	$           988.74
84	54	$               31.94	$        1,724.76
77	51	$               21.65	$        1,104.15
18	48	$               28.48	$        1,367.04
68	48	$               31.35	$        1,504.80
82	46	$               17.37	$           799.02
52	44	$               37.52	$        1,650.88
75	44	$               17.24	$           758.56
15	43	$               17.36	$           746.48
39	43	$               32.32	$        1,389.76
38	42	$               39.16	$        1,644.72
62	39	$               32.21	$        1,256.19
71	38	$               32.32	$        1,228.16
24	37	$               29.68	$        1,098.16
60	37	$               22.93	$           848.41
42	33	$               32.47	$        1,071.51
74	30	$               26.42	$           792.60
63	26	$               37.43	$           973.18
93	26	$               23.14	$           601.64
94	25	$               26.29	$           657.25

Answer 1

Transaction number	Quantity
23	149
47	149
76	147
6	146
11	145
80	144
33	142
37	140
29	139
50	139
58	138
67	138
85	136
4	135
25	135
95	135
55	134
57	132
35	130
34	129
13	128
96	126
53	125
70	122
78	120
100	120
20	118
46	118
30	114
89	113
72	112
2	110
87	106
17	104
69	101
19	100
54	100
43	98
83	98
12	97
28	97
45	97
26	95
65	93
91	93
8	92
14	91
90	89
48	88
49	88
98	87
44	85
97	85
16	84
31	83
7	81
32	81
3	79
10	75
1	73
36	71
92	71
66	70
73	70
88	70
9	69
41	67
51	66
64	66
79	66
81	64
22	63
56	62
27	60
40	60
59	60
21	58
61	58
86	55
99	55
5	54
84	54
77	51
18	48
68	48
82	46
52	44
75	44
15	43
39	43
38	42
62	39
71	38
24	37
60	37
42	33
74	30
63	26
93	26
94	25
Average quantity per transaction = Using average function in MS excel	88.37
or
Average quantity per transaction =sum of quanity/no of orders	8837/100	88.37
sum of quantity	8837