Jack continues to get inquiries from other TRL departments regarding quality, customer satisfaction, and operational performance. Jack wants your group to summarize some data from the Group Project - Data Excel File using statistical tools and analysis:

A. design histograms and frequency distributions utilizing the data including in the Customer Satisfaction Survey tab. B. design a frequency distribution and histogram for the wheel weight samples in the worksheet Wheel Weight. C. Correlations among the variables provided in the worksheet Procurement Survey.

Comment on the charts for A and B, as well as the significant of the correlations from Part C.

Procurement Survey
Delivery speed	Price level	Price flexibility	Manufacturing image	Overall service	Salesforce image	Product quality	Usage Level	Satisfaction Level	Size of firm	Purchasing Structure	Industry	Buying Type
4.1	0.6	6.9	4.7	2.4	2.3	5.2	32	4.2	0	0	1	1
1.8	3	6.3	6.6	2.5	4	8.4	43	4.3	1	1	0	1
3.4	5.2	5.7	6	4.3	2.7	8.2	48	5.2	1	1	1	2
2.7	1	7.1	5.9	1.8	2.3	7.8	32	3.9	1	1	1	1
6	0.9	9.6	7.8	3.4	4.6	4.5	58	6.8	0	0	1	3
1.9	3.3	7.9	4.8	2.6	1.9	9.7	45	4.4	1	1	1	2
4.6	2.4	9.5	6.6	3.5	4.5	7.6	46	5.8	0	0	1	1
1.3	4.2	6.2	5.1	2.8	2.2	6.9	44	4.3	1	1	0	2
5.5	1.6	9.4	4.7	3.5	3	7.6	63	5.4	0	0	1	3
4	3.5	6.5	6	3.7	3.2	8.7	54	5.4	1	1	0	2
2.4	1.6	8.8	4.8	2	2.8	5.8	32	4.3	0	0	0	1
3.9	2.2	9.1	4.6	3	2.5	8.3	47	5	0	0	1	2
2.8	1.4	8.1	3.8	2.1	1.4	6.6	39	4.4	1	1	0	1
3.7	1.5	8.6	5.7	2.7	3.7	6.7	38	5	0	0	1	1
4.7	1.3	9.9	6.7	3	2.6	6.8	54	5.9	0	0	0	3
3.4	2	9.7	4.7	2.7	1.7	4.8	49	4.7	0	0	0	3
3.2	4.1	5.7	5.1	3.6	2.9	6.2	38	4.4	0	1	1	2
4.9	1.8	7.7	4.3	3.4	1.5	5.9	40	5.6	0	0	0	2
5.3	1.4	9.7	6.1	3.3	3.9	6.8	54	5.9	0	0	1	3
4.7	1.3	9.9	6.7	3	2.6	6.8	55	6	0	0	0	3
3.3	0.9	8.6	4	2.1	1.8	6.3	41	4.5	0	0	0	2
3.4	0.4	8.3	2.5	1.2	1.7	5.2	35	3.3	0	0	0	1
3	4	9.1	7.1	3.5	3.4	8.4	55	5.2	0	1	0	3
2.4	1.5	6.7	4.8	1.9	2.5	7.2	36	3.7	1	1	0	1
5.1	1.4	8.7	4.8	3.3	2.6	3.8	49	4.9	0	0	0	2
4.6	2.1	7.9	5.8	3.4	2.8	4.7	49	5.9	0	0	1	3
2.4	1.5	6.6	4.8	1.9	2.5	7.2	36	3.7	1	1	0	1
5.2	1.3	9.7	6.1	3.2	3.9	6.7	54	5.8	0	0	1	3
3.5	2.8	9.9	3.5	3.1	1.7	5.4	49	5.4	0	0	1	3
4.1	3.7	5.9	5.5	3.9	3	8.4	46	5.1	1	1	0	2
3	3.2	6	5.3	3.1	3	8	43	3.3	1	1	0	1
2.8	3.8	8.9	6.9	3.3	3.2	8.2	53	5	0	1	0	3
5.2	2	9.3	5.9	3.7	2.4	4.6	60	6.1	0	0	0	3
3.4	3.7	6.4	5.7	3.5	3.4	8.4	47	3.8	1	1	0	1
2.4	1	7.7	3.4	1.7	1.1	6.2	35	4.1	1	1	0	1
1.8	3.3	7.5	4.5	2.5	2.4	7.6	39	3.6	1	1	1	1
3.6	4	5.8	5.8	3.7	2.5	9.3	44	4.8	1	1	1	2
4	0.9	9.1	5.4	2.4	2.6	7.3	46	5.1	0	0	1	3
0	2.1	6.9	5.4	1.1	2.6	8.9	29	3.9	1	1	1	1
2.4	2	6.4	4.5	2.1	2.2	8.8	28	3.3	1	1	1	1
1.9	3.4	7.6	4.6	2.6	2.5	7.7	40	3.7	1	1	1	1
5.9	0.9	9.6	7.8	3.4	4.6	4.5	58	6.7	0	0	1	3
4.9	2.3	9.3	4.5	3.6	1.3	6.2	53	5.9	0	0	0	3
5	1.3	8.6	4.7	3.1	2.5	3.7	48	4.8	0	0	0	2
2	2.6	6.5	3.7	2.4	1.7	8.5	38	3.2	1	1	1	1
5	2.5	9.4	4.6	3.7	1.4	6.3	54	6	0	0	0	3
3.1	1.9	10	4.5	2.6	3.2	3.8	55	4.9	0	0	1	3
3.4	3.9	5.6	5.6	3.6	2.3	9.1	43	4.7	1	1	1	2
5.8	0.2	8.8	4.5	3	2.4	6.7	57	4.9	0	0	1	3
5.4	2.1	8	3	3.8	1.4	5.2	53	3.8	0	0	1	3
3.7	0.7	8.2	6	2.1	2.5	5.2	41	5	0	0	0	2
2.6	4.8	8.2	5	3.6	2.5	9	53	5.2	1	1	1	2
4.5	4.1	6.3	5.9	4.3	3.4	8.8	50	5.5	1	1	0	2
2.8	2.4	6.7	4.9	2.5	2.6	9.2	32	3.7	1	1	1	1
3.8	0.8	8.7	2.9	1.6	2.1	5.6	39	3.7	0	0	0	1
2.9	2.6	7.7	7	2.8	3.6	7.7	47	4.2	0	1	1	2
4.9	4.4	7.4	6.9	4.6	4	9.6	62	6.2	1	1	0	2
5.4	2.5	9.6	5.5	4	3	7.7	65	6	0	0	0	3
4.3	1.8	7.6	5.4	3.1	2.5	4.4	46	5.6	0	0	1	3
2.3	4.5	8	4.7	3.3	2.2	8.7	50	5	1	1	1	2
3.1	1.9	9.9	4.5	2.6	3.1	3.8	54	4.8	0	0	1	3
5.1	1.9	9.2	5.8	3.6	2.3	4.5	60	6.1	0	0	0	3
4.1	1.1	9.3	5.5	2.5	2.7	7.4	47	5.3	0	0	1	3
3	3.8	5.5	4.9	3.4	2.6	6	36	4.2	0	1	1	2
1.1	2	7.2	4.7	1.6	3.2	10	40	3.4	1	1	1	1
3.7	1.4	9	4.5	2.6	2.3	6.8	45	4.9	0	0	0	2
4.2	2.5	9.2	6.2	3.3	3.9	7.3	59	6	0	0	0	3
1.6	4.5	6.4	5.3	3	2.5	7.1	46	4.5	1	1	0	2
5.3	1.7	8.5	3.7	3.5	1.9	4.8	58	4.3	0	0	0	3
2.3	3.7	8.3	5.2	3	2.3	9.1	49	4.8	1	1	1	2
3.6	5.4	5.9	6.2	4.5	2.9	8.4	50	5.4	1	1	1	2
5.6	2.2	8.2	3.1	4	1.6	5.3	55	3.9	0	0	1	3
3.6	2.2	9.9	4.8	2.9	1.9	4.9	51	4.9	0	0	0	3
5.2	1.3	9.1	4.5	3.3	2.7	7.3	60	5.1	0	0	1	3
3	2	6.6	6.6	2.4	2.7	8.2	41	4.1	1	1	0	1
4.2	2.4	9.4	4.9	3.2	2.7	8.5	49	5.2	0	0	1	2
3.8	0.8	8.3	6.1	2.2	2.6	5.3	42	5.1	0	0	0	2
3.3	2.6	9.7	3.3	2.9	1.5	5.2	47	5.1	0	0	1	3
1	1.9	7.1	4.5	1.5	3.1	9.9	39	3.3	1	1	1	1
4.5	1.6	8.7	4.6	3.1	2.1	6.8	56	5.1	0	0	0	3
5.5	1.8	8.7	3.8	3.6	2.1	4.9	59	4.5	0	0	0	3
3.4	4.6	5.5	8.2	4	4.4	6.3	47	5.6	0	1	1	2
1.6	2.8	6.1	6.4	2.3	3.8	8.2	41	4.1	1	1	0	1
2.3	3.7	7.6	5	3	2.5	7.4	37	4.4	0	1	0	1
2.6	3	8.5	6	2.8	2.8	6.8	53	5.6	1	1	0	2
2.5	3.1	7	4.2	2.8	2.2	9	43	3.7	1	1	1	1
2.4	2.9	8.4	5.9	2.7	2.7	6.7	51	5.5	1	1	0	2
2.1	3.5	7.4	4.8	2.8	2.3	7.2	36	4.3	0	1	0	1
2.9	1.2	7.3	6.1	2	2.5	8	34	4	1	1	1	1
4.3	2.5	9.3	6.3	3.4	4	7.4	60	6.1	0	0	0	3
3	2.8	7.8	7.1	3	3.8	7.9	49	4.4	0	1	1	2
4.8	1.7	7.6	4.2	3.3	1.4	5.8	39	5.5	0	0	0	2
3.1	4.2	5.1	7.8	3.6	4	5.9	43	5.2	0	1	1	2
1.9	2.7	5	4.9	2.2	2.5	8.2	36	3.6	1	1	0	1
4	0.5	6.7	4.5	2.2	2.1	5	31	4	0	0	1	1
0.6	1.6	6.4	5	0.7	2.1	8.4	25	3.4	1	1	1	1
6.1	0.5	9.2	4.8	3.3	2.8	7.1	60	5.2	0	0	1	3
2	2.8	5.2	5	2.4	2.7	8.4	38	3.7	1	1	0	1
3.1	2.2	6.7	6.8	2.6	2.9	8.4	42	4.3	1	1	0	1
2.5	1.8	9	5	2.2	3	6	33	4.4	0	0	0	1

Jack continues to get inquiries from other TRL departments regarding quality, customer satisfaction, and operational performance. Jack wants your group to summarize some data from the Group Project - Data Excel File using statistical tools and analysis:

A. Create histograms and frequency distributions utilizing the data including in the Customer Satisfaction Survey tab. B. Create a frequency distribution and histogram for the wheel weight samples in the worksheet Wheel Weight. C. Correlations among the variables provided in the worksheet Procurement Survey.

Comment on the charts for A and B, as well as the significant of the correlations from Part C.

Wheel Weight
Sample	Weight
1	4.88
2	4.92
3	5.02
4	4.97
5	5.00
6	4.99
7	4.86
8	5.07
9	5.04
10	4.87
11	4.77
12	5.14
13	5.04
14	5.00
15	4.88
16	4.91
17	5.09
18	4.97
19	4.98
20	5.07
21	5.03
22	5.12
23	5.08
24	4.86
25	5.11
26	4.92
27	5.18
28	4.93
29	5.12
30	5.08
31	4.75
32	4.99
33	5.00
34	4.91
35	5.18
36	4.95
37	4.63
38	4.89
39	5.11
40	5.05
41	5.03
42	5.02
43	4.96
44	5.04
45	4.93
46	5.06
47	5.07
48	5.00
49	5.03
50	5.00
51	4.95
52	4.99
53	5.02
54	4.90
55	5.10
56	5.01
57	4.84
58	5.01
59	4.88
60	4.97
61	4.97
62	5.06
63	5.06
64	5.04
65	4.87
66	5.00
67	5.03
68	5.02
69	5.02
70	5.06
71	5.21
72	5.09
73	4.97
74	5.01
75	4.90
76	4.89
77	4.93
78	5.16
79	5.02
80	5.01
81	5.10
82	5.03
83	5.07
84	4.92
85	5.08
86	4.96
87	4.74
88	4.91
89	5.12
90	5.00
91	4.93
92	4.88
93	4.88
94	4.81
95	5.16
96	5.03
97	4.87
98	5.09
99	4.94
100	5.08
101	4.97
102	5.23
103	5.12
104	5.09
105	5.12
106	4.93
107	4.79
108	5.10
109	5.12
110	4.86
111	5.00
112	4.94
113	4.95
114	4.95
115	4.87
116	5.09
117	4.94
118	5.01
119	5.04
120	5.05
121	5.05
122	4.97
123	4.96
124	4.96
125	4.99
126	5.04
127	4.91
128	5.19
129	5.03
130	4.99
131	5.12
132	4.97
133	4.88
134	5.07
135	5.01
136	4.89
137	4.95
138	5.09
139	5.09
140	4.89
141	4.93
142	4.85
143	5.03
144	4.92
145	5.09
146	4.99
147	4.92
148	4.87
149	4.90
150	5.02
151	5.21
152	5.02
153	4.9
154	5
155	5.16
156	5.03
157	4.96
158	5.04
159	4.98
160	5.07
161	5.02
162	5.08
163	4.85
164	4.9
165	4.97
166	5.09
167	4.89
168	4.87
169	5.01
170	4.97
171	5.87
172	5.33
173	5.11
174	5.07
175	4.93
176	4.99
177	5.04
178	5.14
179	5.09
180	5.06
181	4.85
182	4.93
183	5.04
184	5.09
185	5.07
186	4.99
187	5.01
188	4.88
189	4.93
190	5.1
191	4.94
192	4.88
193	4.89
194	4.89
195	4.85
196	4.82
197	5.02
198	4.9
199	4.73
200	5.04
201	5.07
202	4.81
203	5.04
204	5.03
205	5.01
206	5.14
207	5.12
208	4.89
209	4.91
210	4.97
211	4.98
212	5.01
213	5.01
214	5.09
215	4.93
216	5.04
217	5.11
218	5.07
219	4.95
220	4.86
221	5.13
222	4.95
223	5.22
224	4.81
225	4.91
226	4.95
227	4.94
228	4.81
229	5.11
230	4.81
231	4.97
232	5.07
233	5.03
234	4.81
235	4.95
236	4.89
237	5.08
238	4.93
239	4.99
240	4.94
241	5.13
242	5.02
243	5.07
244	4.82
245	5.03
246	4.85
247	4.89
248	4.82
249	5.18
250	5.02
251	5.05
252	4.88
253	5.08
254	4.98
255	5.02
256	4.99
257	5.02
258	5.03
259	5.02
260	5.07
261	4.95
262	4.95
263	4.94
264	5.12
265	5.08
266	4.91
267	4.96
268	4.96
269	4.94
270	5.19
271	4.91
272	5.01
273	4.93
274	5.05
275	4.96
276	4.92
277	4.95
278	5.08
279	4.97
280	5.04
281	4.94
282	4.98
283	5.03
284	5.05
285	4.91
286	5.09
287	5.21
288	4.87
289	5.02
290	4.81
291	4.96
292	5.06
293	4.86
294	4.96
295	4.99
296	4.94
297	5.06
298	4.95
299	5.02
300	5.01
301	5.04
302	5.01
303	5.02
304	5.03
305	5.18
306	5.08
307	5.14
308	4.92
309	4.97
310	4.92
311	5.14
312	4.92
313	5.03
314	4.98
315	4.76
316	4.94
317	4.92
318	4.91
319	4.96
320	5.02
321	5.13
322	5.13
323	4.92
324	4.98
325	4.89
326	4.88
327	5.11
328	5.11
329	5.08
330	5.03
331	4.94
332	4.88
333	4.91
334	4.86
335	4.89
336	4.91
337	4.87
338	4.93
339	5.14
340	4.87
341	4.98
342	4.88
343	4.88
344	5.01
345	4.93
346	4.93
347	4.99
348	4.91
349	4.96
350	4.78

Customer Satisfaction Survey
Region	Quality	Ease of Use	Price	Service
NA	4	1	3	4
NA	4	4	4	5
NA	4	5	4	3
NA	5	4	4	4
NA	5	4	5	4
NA	5	5	3	5
NA	5	4	4	2
NA	5	5	4	5
NA	4	4	4	5
NA	4	5	4	5
NA	4	5	1	4
NA	5	5	4	4
NA	5	4	3	3
NA	4	5	4	4
NA	5	4	3	5
NA	5	5	2	5
NA	5	4	2	5
NA	5	4	2	5
NA	4	5	4	4
NA	4	4	5	4
NA	4	4	2	4
NA	4	3	3	4
NA	5	5	2	5
NA	5	3	4	3
NA	5	4	4	5
NA	5	5	2	5
NA	5	5	5	3
NA	4	4	5	4
NA	5	4	4	4
NA	5	1	5	5
NA	5	4	3	5
NA	4	5	1	4
NA	4	4	3	5
NA	5	3	4	4
NA	5	5	2	4
NA	5	4	4	4
NA	5	5	4	4
NA	5	5	4	5
NA	4	3	3	5
NA	5	4	4	3
NA	5	4	3	4
NA	5	5	1	5
NA	5	4	5	4
NA	3	4	3	4
NA	5	4	2	4
NA	5	5	4	5
NA	5	5	3	4
NA	5	4	4	4
NA	5	4	4	4
NA	5	4	4	5
NA	5	4	1	4
NA	5	4	5	5
NA	5	5	3	4
NA	5	4	4	5
NA	4	3	5	5
NA	5	4	4	4
NA	5	5	5	5
NA	5	5	4	5
NA	4	4	4	4
NA	5	4	5	5
NA	4	5	5	4
NA	5	5	5	4
NA	5	5	3	5
NA	5	4	4	4
NA	5	4	5	2
NA	4	4	5	5
NA	4	4	4	5
NA	5	4	4	4
NA	5	4	3	5
NA	5	4	5	4
NA	5	5	4	5
NA	5	4	4	4
NA	5	4	5	2
NA	5	3	4	5
NA	5	4	5	5
NA	5	4	1	5
NA	4	5	3	5
NA	3	5	2	5
NA	5	5	4	4
NA	4	4	3	5
NA	3	2	4	5
NA	1	4	3	4
NA	4	5	3	5
NA	5	5	4	4
NA	4	5	5	5
NA	5	5	4	5
NA	5	5	4	4
NA	4	2	4	5
NA	5	4	5	4
NA	5	4	5	4
NA	5	5	4	3
NA	5	5	5	5
NA	4	5	5	3
NA	5	5	4	5
NA	4	4	5	5
NA	5	5	3	4
NA	4	5	2	4
NA	5	5	5	4
NA	4	5	4	3
NA	4	5	5	4
SA	5	4	3	5
SA	5	4	2	4
SA	5	4	5	5
SA	4	2	4	5
SA	5	4	4	5
SA	4	5	2	5
SA	5	4	4	4
SA	4	5	3	5
SA	4	4	4	3
SA	4	4	2	4
SA	5	4	3	4
SA	3	3	5	5
SA	5	4	3	4
SA	5	4	2	5
SA	4	4	3	4
SA	4	4	3	5
SA	1	5	3	4
SA	5	4	2	4
SA	4	4	4	4
SA	4	4	5	5
SA	5	4	2	4
SA	4	4	5	5
SA	4	4	4	3
SA	3	3	4	5
SA	5	4	4	4
SA	4	4	4	1
SA	4	5	5	5
SA	4	1	4	5
SA	4	5	4	4
SA	4	4	4	5
SA	5	4	3	4
SA	4	4	4	5
SA	5	5	4	3
SA	5	5	4	4
SA	4	4	2	4
SA	4	4	4	5
SA	5	4	4	5
SA	5	4	4	4
SA	5	4	1	4
SA	3	4	4	5
SA	4	3	5	4
SA	4	4	2	3
SA	5	4	3	3
SA	4	3	4	5
SA	5	3	5	5
SA	5	4	4	4
SA	5	4	4	4
SA	3	4	3	4
SA	4	4	1	4
SA	4	3	4	3
Eur	4	5	5	3
Eur	4	4	4	2
Eur	3	4	5	4
Eur	3	4	1	3
Eur	4	4	5	5
Eur	5	5	5	5
Eur	5	5	5	1
Eur	4	5	5	4
Eur	3	4	4	4
Eur	3	5	3	3
Eur	4	4	5	4
Eur	5	4	5	5
Eur	5	3	4	4
Eur	5	5	4	5
Eur	3	4	4	4
Eur	4	5	4	5
Eur	4	5	4	4
Eur	5	4	4	5
Eur	4	5	4	4
Eur	3	5	3	4
Eur	4	4	4	2
Eur	5	5	3	4
Eur	5	3	4	5
Eur	4	5	2	4
Eur	4	3	4	4
Eur	5	4	3	3
Eur	2	4	4	4
Eur	5	4	5	4
Eur	4	5	4	3
Eur	5	4	1	5
Pac	5	4	4	5
Pac	5	5	5	5
Pac	4	4	4	4
Pac	4	3	4	4
Pac	5	4	5	4
Pac	4	4	4	4
Pac	5	5	4	5
Pac	4	2	3	3
Pac	3	4	4	4
Pac	5	4	4	5
China	5	5	4	4
China	5	5	4	3
China	4	4	3	3
China	4	4	3	3
China	4	4	3	2
China	4	4	3	3
China	4	4	3	2
China	3	4	3	3
China	3	4	2	2
China	2	3	2	1