2. If you average the responses to the first seven questions by customer, how closely are those averages correlated to the satisfaction score? Include a scatter chart in your analysis.

Hint: use a regression analysis, check the appropriate boxes to display a useful chart for your analysis and use theR²value as a reference in your discussion.

Burrito Brothers
Customer survey Results
	Customer Number																											Customer survey responses
	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	Avg	Std. dev.				Avg	Std. dev.
Menu was easy to read	3	5	5	5	5	5	5	5	5	5	4	5	5	4	3	5	4	5	5	5	5	5	5	3	5	4.64	0.69			Menu was easy to read
Order was prepared correctly	3	4	5	4	5	4	3	5	4	5	3	4	5	4	4	5	3	4	5	5	5	4	5	4	5	4.28	0.72			Order was prepared correctly
Food was tasty	2	4	5	2	5	5	4	4	3	4	3	5	5	5	3	4	3	4	3	4	3	4	5	3	4	3.84	0.92			Food was tasty
Food was served hot	2	5	4	3	5	5	5	5	2	3	1	5	5	4	2	3	1	5	3	3	4	5	5	2	3	3.60	1.36			Food was served hot
Employees were courteous and polite	4	4	5	3	5	4	4	5	3	4	3	4	5	5	4	4	3	4	4	4	4	4	4	4	4	4.04	0.60			Employees were courteous and polite
Restaurant was clean	5	4	5	3	5	4	4	5	3	3	3	4	5	5	5	4	3	4	3	4	4	4	4	5	3	4.04	0.77			Restaurant was clean
Value for price paid	4	5	5	2	5	5	5	5	2	3	2	5	5	5	4	3	2	5	3	3	3	5	5	4	3	3.92	1.16			Value for price paid
Overall satisfaction	2	4	5	3	5	4	4	5	2	4	3	4	5	4	3	4	3	4	3	4	4	4	5	3	4	3.80	0.85			Overall satisfaction
Likely to dine with us again?	2	4	5	2	5	4	4	5	2	3	2	4	5	4	3	3	2	4	5	3	3	4	5	3	3	3.56	1.06			Likely to dine with us again?
Likely to recommend us to friends?	2	4	5	2	5	4	4	5	1	3	2	4	5	4	2	3	2	4	5	3	3	4	5	2	3	3.44	1.20			Likely to recommend us to friends?
Average score: items 1-7	2.9	4.3	4.9	2.9	5.0	4.4	4.2	4.9	2.7	3.7	2.6	4.4	5.0	4.4	3.3	3.8	2.6	4.3	3.9	3.8	3.8	4.3	4.8	3.3	3.7
																																1	2	3	4
How often do you eat at here? First time, less than once/month, 1-3 times a month, weekly, [1,2,3,4]	2	2	4	1	1	4	3	1	1	2	3	4	4	3	2	1	1	4	1	2	3	3	4	2	3	2.44	1.13			Use the count if funtion to find out many customers often eat there and what type of food they get.	Count	7	5	6	5
What was the main ingredient: chicken, beef, pork, beans [1,2,3,4]	1	1	3	4	1	1	2	2	3	4	2	2	2	3	1	1	2	1	3	4	1	1	2	3	1	2.04	1.04				Count	10	7	5	3

Burrito Brothers
Weights of Burritos (Pounds)
Sample Number	Weights
1	1.13		Descriptive Statistics		Bin	Frequency
2	1.10
3	1.17
4	1.08
5	1.09
6	1.05
7	1.09
8	1.12
9	1.09
10	1.07
11	1.07
12	1.15
13	1.13
14	0.97
15	1.17
16	1.15
17	1.09
18	1.01
19	1.05
20	1.10
21	1.09
22	1.03
23	1.09
24	1.02
25	1.14
26	1.08
27	1.11
28	1.08
29	1.04
30	1.10
31	1.01
32	1.03
33	1.12
34	1.13
35	1.20
36	1.10
37	1.20
38	1.07
39	0.96
40	1.18
41	1.11
42	1.13
43	1.07
44	1.17
45	1.02
46	1.15
47	1.10
48	1.18
49	1.04
50	1.13
51	1.18
52	1.14
53	1.13
54	1.14
55	1.16
56	1.07
57	1.07
58	1.17
59	1.06
60	1.04
61	1.16
62	1.15
63	1.03
64	1.08
65	1.09
66	1.16
67	1.19
68	1.04
69	1.12
70	1.10
71	1.18
72	1.11
73	1.05
74	1.13
75	1.14
76	1.13
77	1.03
78	1.17
79	1.09
80	1.16
81	1.10
82	1.06
83	1.12
84	1.17
85	1.18
86	1.13
87	1.04
88	1.06
89	1.11
90	1.06
91	1.07
92	1.16
93	1.07
94	1.10
95	1.10
96	1.13
97	1.09
98	1.13
99	1.15
100	1.18
101	1.06
102	1.17
103	1.08
104	1.14
105	1.13
106	1.15
107	1.05
108	1.07
109	1.09
110	1.11
111	1.09
112	1.03
113	1.07
114	1.09
115	1.06
116	1.09
117	1.11
118	1.13
119	1.15
120	1.10
121	1.01
122	1.11
123	1.08
124	1.10
125	1.04
126	1.11
127	1.05
128	1.11
129	1.03
130	1.07
131	1.03
132	1.05
133	1.14
134	1.10
135	1.09
136	1.09
137	1.10
138	1.07
139	1.06
140	1.07
141	1.07
142	1.07
143	1.12
144	1.12
145	1.15
146	1.17
147	1.10
148	1.15
149	1.08
150	1.09