Project Overview:
You have been hired by an investment group that wants to learn more about what drives restaurant sales. You have been provided a sample of 173 restaurants located in a medium-sized city. You know the restaurants’ average weekly sales, as well as a number of other variables such as food type, if has road frontage, number of competitors within a certain distance, etc. See the legend on the right side of the attached Excel spreadsheet for definitions of all variables (including coding dummy variables and categorical variables).
As the consultant, you will make decisions about what you wish to analyze and communicate to your client. You will analyze this informationUSING ONLY the tools learnedso far which are the following: mean, median, mode, correlation, causality, standard deviation, interquartile range, percentiles, outliers, descriptive and inferential statistics, measures of central tendency, measures of dispersion, data visualization, qualitative and quantitative variables, and dependent/independent variables). Be as thorough as possible given the length requirement (see instructions below).Your task is to help the investor better understand the data that has been collected. What can they learn from the attached data set?
Your audience is your client, the investment group. You can assume that your audience has some very basic knowledge of statistics, and you should explain the implications of statistics you generate to this audience. (They understand mean, median, mode–the basics–but might not fully understand concepts like standard deviation, percentiles, etc. so those require a more thorough explanation as to what the information is communicating. They might understand basic graphs, but be sure that your client is able to understand the “takeaways” of your graphs and report. DO NOT ORPHAN THE GRAPHS.
Firm 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
Gross Sales
213400
300700
188900
422800
399100
99800
87800
201300
253200
364900
364200
476200
538600
472400
152400
208600
186600
202600
222600
655600
335500
253200
165700
645600
376500
477600
265400
276600
819800
886800
90800
746800
248700
69800
997600
725200
356400
476500
879800
266500
477500
364500
312400
423500
126500
SWAM
YES
YES
YES
NO
YES
YES
YES
NO
NO
YES
NO
NO
YES
NO
NO
YES
YES
NO
YES
NO
YES
YES
NO
NO
NO
NO
YES
NO
NO
NO
NO
YES
YES
YES
NO
NO
NO
YES
NO
NO
NO
NO
YES
NO
NO
SWAM
1
1
1
0
1
1
1
0
0
1
0
0
1
0
0
1
1
0
1
0
1
1
0
0
0
0
1
0
0
0
0
1
1
1
0
0
0
1
0
0
0
0
1
0
0
Franchise
NO
YES
NO
NO
NO
NO
NO
NO
NO
YES
NO
NO
YES
NO
NO
NO
NO
NO
NO
YES
NO
YES
NO
YES
NO
NO
NO
NO
YES
YES
NO
NO
NO
NO
YES
NO
NO
NO
YES
NO
NO
NO
NO
NO
NO
Franchise
0
1
0
0
0
0
0
0
0
1
0
0
1
0
0
0
0
0
0
1
0
1
0
1
0
0
0
0
1
1
0
0
0
0
1
0
0
0
1
0
0
0
0
0
0
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
254300
267500
284500
367300
365700
678400
348700
897700
758600
154300
87700
934500
376500
487600
238900
982500
257800
69800
588800
88800
475300
276500
987000
143200
476500
687500
568700
125400
347600
265300
982300
764400
565700
446300
1065400
264700
923000
153600
375500
472300
265400
967800
66700
91200
125000
829800
255300
NO
NO
NO
NO
YES
YES
NO
YES
NO
YES
NO
NO
YES
NO
NO
NO
YES
NO
NO
YES
YES
YES
NO
NO
NO
NO
NO
YES
NO
YES
NO
YES
NO
NO
NO
NO
YES
YES
YES
NO
NO
YES
NO
NO
NO
NO
YES
0
0
0
0
1
1
0
1
0
1
0
0
1
0
0
0
1
0
0
1
1
1
0
0
0
0
0
1
0
1
0
1
0
0
0
0
1
1
1
0
0
1
0
0
0
0
1
NO
NO
YES
NO
NO
YES
NO
YES
NO
NO
NO
YES
NO
NO
NO
YES
NO
NO
YES
NO
NO
NO
YES
NO
NO
NO
NO
NO
NO
NO
YES
NO
YES
NO
YES
NO
NO
NO
NO
NO
NO
YES
NO
NO
NO
YES
NO
0
0
1
0
0
1
0
1
0
0
0
1
0
0
0
1
0
0
1
0
0
0
1
0
0
0
0
0
0
0
1
0
1
0
1
0
0
0
0
0
0
1
0
0
0
1
0
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
1666200
325000
352600
736500
163400
923400
265400
758600
254300
375600
586500
69300
1134600
323400
384500
926400
768300
471200
275400
586500
597400
336500
458900
94600
127500
583400
376500
697600
154300
775400
867900
143600
225400
364200
465700
1028500
1077800
826400
1299600
936800
362300
466600
687500
798600
880900
1187800
99700
NO
NO
NO
YES
NO
NO
NO
YES
YES
YES
NO
YES
NO
YES
NO
YES
NO
NO
YES
YES
YES
NO
NO
NO
NO
YES
NO
YES
NO
YES
NO
YES
NO
NO
NO
NO
YES
YES
NO
YES
YES
NO
NO
NO
NO
NO
NO
0
0
0
1
0
0
0
1
1
1
0
1
0
1
0
1
0
0
1
1
1
0
0
0
0
1
0
1
0
1
0
1
0
0
0
0
1
1
0
1
1
0
0
0
0
0
0
YES
NO
NO
NO
NO
YES
NO
NO
NO
NO
YES
NO
YES
NO
YES
NO
NO
NO
NO
NO
NO
NO
NO
NO
NO
NO
NO
NO
NO
NO
YES
NO
NO
NO
NO
YES
YES
YES
YES
NO
NO
NO
NO
NO
YES
YES
NO
1
0
0
0
0
1
0
0
0
0
1
0
1
0
1
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
1
0
0
0
0
1
1
1
1
0
0
0
0
0
1
1
0
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
88100
265600
967800
465400
87600
556600
385600
557600
77500
129800
239000
236400
462300
366400
1408900
802900
709200
902900
1022900
430200
399900
209300
702900
702200
200200
109200
882200
100100
197400
209900
463400
264300
1066600
897800
NO
YES
YES
NO
NO
NO
NO
NO
YES
NO
NO
NO
NO
YES
NO
NO
NO
YES
NO
YES
YES
NO
NO
YES
NO
NO
NO
YES
NO
YES
NO
NO
NO
YES
0
1
1
0
0
0
0
0
1
0
0
0
0
1
0
0
0
1
0
1
1
0
0
1
0
0
0
1
0
1
0
0
0
1
NO
NO
YES
NO
NO
YES
NO
NO
NO
NO
NO
NO
NO
NO
YES
YES
NO
NO
YES
NO
NO
NO
YES
YES
NO
NO
YES
NO
NO
NO
NO
NO
YES
YES
0
0
1
0
0
1
0
0
0
0
0
0
0
0
1
1
0
0
1
0
0
0
1
1
0
0
1
0
0
0
0
0
1
1
Website
YES
NO
NO
YES
YES
NO
NO
YES
NO
NO
NO
YES
YES
YES
NO
NO
NO
NO
NO
YES
NO
NO
NO
YES
YES
NO
NO
NO
YES
YES
NO
NO
NO
NO
YES
YES
NO
NO
YES
YES
YES
NO
NO
NO
NO
Website
1
0
0
1
1
0
0
1
0
0
0
1
1
1
0
0
0
0
0
1
0
0
0
1
1
0
0
0
1
1
0
0
0
0
1
1
0
0
1
1
1
0
0
0
0
Road Frontage
NO
YES
NO
NO
NO
YES
NO
NO
YES
NO
NO
YES
YES
NO
NO
NO
NO
YES
NO
YES
NO
NO
NO
YES
NO
YES
NO
NO
YES
YES
NO
NO
NO
NO
YES
YES
NO
NO
YES
YES
YES
NO
NO
YES
NO
Road Frontage
0
1
0
0
0
1
0
0
1
0
0
1
1
0
0
0
0
1
0
1
0
0
0
1
0
1
0
0
1
1
0
0
0
0
1
1
0
0
1
1
1
0
0
1
0
Competitors
112
103
91
112
104
140
133
152
149
137
141
155
124
110
161
173
159
148
91
62
76
70
127
72
150
91
90
82
69
78
131
150
101
79
58
72
81
70
55
90
122
109
99
138
130
Marketing %
3.5
3.7
3.6
4.2
4.3
4.2
3.1
3.4
3.5
3.4
3.2
4.1
3.9
3.8
3.5
3.3
3.2
3.1
3.4
4.3
3.7
3.6
2.8
3.9
3.5
4.1
3
3.2
4.5
4.7
3.4
3.9
3.4
3.2
3.8
4.6
4
4.1
4.9
4.1
3.7
3.3
3.5
3.3
3.1
YES
NO
NO
NO
NO
YES
NO
NO
NO
NO
NO
YES
YES
YES
NO
NO
NO
NO
NO
NO
YES
YES
YES
NO
NO
YES
NO
NO
YES
NO
YES
YES
YES
NO
NO
NO
YES
NO
YES
YES
NO
YES
YES
NO
NO
YES
YES
1
0
0
0
0
1
0
0
0
0
0
1
1
1
0
0
0
0
0
0
1
1
1
0
0
1
0
0
1
0
1
1
1
0
0
0
1
0
1
1
0
1
1
0
0
1
1
NO
NO
NO
YES
NO
NO
YES
YES
NO
NO
NO
NO
NO
NO
NO
YES
NO
NO
YES
NO
NO
NO
YES
NO
NO
YES
YES
YES
NO
NO
NO
NO
NO
NO
YES
NO
YES
YES
YES
YES
NO
NO
NO
NO
YES
YES
YES
0
0
0
1
0
0
1
1
0
0
0
0
0
0
0
1
0
0
1
0
0
0
1
0
0
1
1
1
0
0
0
0
0
0
1
0
1
1
1
1
0
0
0
0
1
1
1
129
118
110
103
99
76
121
88
85
120
132
134
125
130
100
77
99
131
88
99
87
102
67
107
67
59
56
89
78
94
68
55
59
71
49
109
88
93
59
76
101
60
103
98
87
69
77
3.3
3
3.6
3.5
3.7
3.9
3.7
4.5
4.6
3.9
3.4
5.1
4
5.5
3.1
5.8
4.3
2.9
3.4
3.3
3.7
3.4
5.1
2.6
3.3
4.1
4
3.4
3.4
3.3
4.9
4.7
4.8
4.2
4.8
4.1
4.6
4
3.6
4
3.3
5.9
2.8
3.4
3
5.4
4
NO
NO
NO
NO
YES
YES
NO
NO
NO
NO
NO
NO
YES
NO
NO
YES
YES
NO
NO
YES
NO
NO
YES
NO
YES
YES
NO
NO
NO
YES
YES
NO
NO
NO
NO
YES
YES
NO
NO
YES
NO
NO
NO
NO
NO
NO
NO
0
0
0
0
1
1
0
0
0
0
0
0
1
0
0
1
1
0
0
1
0
0
1
0
1
1
0
0
0
1
1
0
0
0
0
1
1
0
0
1
0
0
0
0
0
0
0
YES
YES
NO
NO
NO
NO
NO
NO
NO
YES
YES
NO
YES
NO
NO
YES
YES
YES
NO
YES
YES
YES
YES
NO
NO
YES
YES
YES
NO
NO
NO
YES
NO
YES
NO
YES
YES
YES
YES
YES
NO
NO
NO
YES
YES
YES
NO
1
1
0
0
0
0
0
0
0
1
1
0
1
0
0
1
1
1
0
1
1
1
1
0
0
1
1
1
0
0
0
1
0
1
0
1
1
1
1
1
0
0
0
1
1
1
0
44
132
124
78
99
56
105
85
82
84
100
99
58
100
87
71
74
86
87
66
54
88
99
111
104
76
86
66
76
48
44
90
88
76
66
75
62
100
88
76
89
78
67
90
58
44
99
4.6
3.1
2.8
3.9
3.6
4.8
3.3
4.4
4.1
4.2
4.9
4.6
5.1
3.2
3.7
6.1
6
4.7
3.3
5
5.1
4.6
5
4.1
3.9
4.4
4.2
5.4
3.6
5.3
4.1
3.2
2.8
2.9
3
4.9
4.7
5
5.2
5.3
4.5
4.1
4.2
4.4
4
6.3
3.4
NO
YES
YES
NO
NO
YES
NO
YES
NO
NO
NO
NO
YES
NO
YES
YES
YES
YES
YES
NO
NO
NO
NO
YES
NO
NO
YES
NO
NO
NO
YES
NO
YES
YES
0
1
1
0
0
1
0
1
0
0
0
0
1
0
1
1
1
1
1
0
0
0
0
1
0
0
1
0
0
0
1
0
1
1
NO
YES
YES
YES
NO
NO
NO
NO
YES
NO
YES
NO
NO
NO
YES
YES
YES
NO
YES
YES
YES
NO
NO
YES
YES
NO
YES
NO
NO
YES
YES
NO
YES
YES
0
1
1
1
0
0
0
0
1
0
1
0
0
0
1
1
1
0
1
1
1
0
0
1
1
0
1
0
0
1
1
0
1
1
117
88
67
66
90
56
77
67
99
105
117
89
67
66
49
69
70
55
56
80
68
80
67
56
77
109
74
99
126
133
102
100
66
75
3.3
2.9
3.5
3.7
3
4.2
3.8
4.1
2.2
2.5
2.7
3.3
3.3
3.4
5.5
4.7
4.6
4.9
6.1
4.4
4.1
3.4
5.4
5.2
2.9
3.6
4.9
2.8
3.6
3.7
3.9
4
5.7
5.5
Meals Tax
YES
YES
NO
NO
NO
NO
YES
YES
YES
NO
NO
NO
YES
NO
NO
YES
NO
NO
NO
YES
YES
NO
NO
NO
YES
YES
NO
NO
NO
NO
NO
NO
NO
YES
YES
YES
NO
NO
NO
NO
YES
YES
YES
NO
NO
Meals Tax
1
1
0
0
0
0
1
1
1
0
0
0
1
0
0
1
0
0
0
1
1
0
0
0
1
1
0
0
0
0
0
0
0
1
1
1
0
0
0
0
1
1
1
0
0
Food Type
American
Asian
Mexican
American
Other
American
American
Italian
Asian
Italian
Mexican
Mexican
American
Mexican
Asian
Asian
Asian
Italian
Other
American
Asian
Asian
Asian
Mexican
Italian
Mexican
Asian
Italian
American
American
Asian
Mexican
Mexican
Asian
American
Other
American
American
American
Asian
Mexican
Mexican
Italian
Italian
Other
Asian
0
1
0
0
0
0
0
0
1
0
0
0
0
0
1
1
1
0
0
0
1
1
1
0
0
0
1
0
0
0
1
0
0
1
0
0
0
0
0
1
0
0
0
0
0
Italian
0
0
0
0
0
0
0
1
0
1
0
0
0
0
0
0
0
1
0
0
0
0
0
0
1
0
0
1
0
0
0
0
0
0
0
0
0
0
0
0
0
0
1
1
0
Mexican
0
0
1
0
0
0
0
0
0
0
1
1
0
1
0
0
0
0
0
0
0
0
0
1
0
1
0
0
0
0
0
1
1
0
0
0
0
0
0
0
1
1
0
0
0
Other
0
0
0
0
1
0
0
0
0
0
0
0
0
0
0
0
0
0
1
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
1
0
0
0
0
0
0
0
0
1
YES
NO
NO
NO
NO
YES
YES
YES
NO
NO
NO
NO
YES
YES
NO
NO
NO
NO
NO
YES
YES
NO
NO
NO
NO
NO
NO
YES
YES
YES
NO
NO
NO
NO
NO
YES
YES
NO
NO
YES
YES
NO
NO
NO
NO
YES
YES
1
0
0
0
0
1
1
1
0
0
0
0
1
1
0
0
0
0
0
1
1
0
0
0
0
0
0
1
1
1
0
0
0
0
0
1
1
0
0
1
1
0
0
0
0
1
1
Asian
Asian
Asian
Other
Mexican
American
Asian
American
Mexican
Asian
Asian
American
Asian
Mexican
Italian
Mexican
Mexican
Asian
American
Asian
American
Mexican
American
Italian
Mexican
Mexican
Asian
Asian
Mexican
Mexican
American
American
American
Mexican
American
Asian
American
Asian
Mexican
Mexican
Mexican
American
Asian
Asian
Other
American
Mexican
1
1
1
0
0
0
1
0
0
1
1
0
1
0
0
0
0
1
0
1
0
0
0
0
0
0
1
1
0
0
0
0
0
0
0
1
0
1
0
0
0
0
1
1
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
1
0
0
0
0
0
0
0
0
1
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
1
0
0
0
1
0
0
0
0
1
0
1
1
0
0
0
0
1
0
0
1
1
0
0
1
1
0
0
0
1
0
0
0
0
1
1
1
0
0
0
0
0
1
0
0
0
1
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
1
0
0
YES
YES
NO
NO
NO
YES
NO
NO
NO
NO
YES
NO
NO
NO
NO
YES
YES
YES
NO
NO
NO
NO
NO
YES
NO
NO
NO
NO
NO
NO
YES
YES
NO
NO
NO
NO
NO
NO
YES
YES
NO
NO
YES
NO
NO
YES
NO
1
1
0
0
0
1
0
0
0
0
1
0
0
0
0
1
1
1
0
0
0
0
0
1
0
0
0
0
0
0
1
1
0
0
0
0
0
0
1
1
0
0
1
0
0
1
0
American
Asian
Asian
Asian
Italian
American
Italian
American
Italian
Mexican
Asian
Asian
American
Asian
Mexican
Mexican
Italian
Asian
American
American
American
Italian
Italian
Asian
Asian
Mexican
Other
Italian
Italian
American
American
Asian
Italian
Mexican
American
American
American
American
Italian
Mexican
Asian
Asian
Mexican
Mexican
Italian
Italian
Asian
0
1
1
1
0
0
0
0
0
0
1
1
0
1
0
0
0
1
0
0
0
0
0
1
1
0
0
0
0
0
0
1
0
0
0
0
0
0
0
0
1
1
0
0
0
0
1
0
0
0
0
1
0
1
0
1
0
0
0
0
0
0
0
1
0
0
0
0
1
1
0
0
0
0
1
1
0
0
0
1
0
0
0
0
0
1
0
0
0
0
0
1
1
0
0
0
0
0
0
0
0
0
0
1
0
0
0
0
1
1
0
0
0
0
0
0
0
0
0
1
0
0
0
0
0
0
0
1
0
0
0
0
0
1
0
0
1
1
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
1
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
NO
NO
NO
YES
NO
NO
YES
NO
NO
NO
YES
NO
YES
NO
NO
NO
NO
NO
YES
YES
NO
NO
NO
YES
YES
NO
YES
NO
NO
YES
NO
YES
YES
NO
0
0
0
1
0
0
1
0
0
0
1
0
1
0
0
0
0
0
1
1
0
0
0
1
1
0
1
0
0
1
0
1
1
0
Asian
Italian
Italian
Mexican
Asian
Mexican
Asian
Asian
Asian
American
Mexican
Italian
Asian
Italian
American
American
Mexican
Italian
American
American
Asian
Asian
American
American
Asian
Asian
American
Asian
Italian
Asian
American
Mexican
American
Other
1
0
0
0
1
0
1
1
1
0
0
0
1
0
0
0
0
0
0
0
1
1
0
0
1
1
0
1
0
1
0
0
0
0
0
1
1
0
0
0
0
0
0
0
0
1
0
1
0
0
0
1
0
0
0
0
0
0
0
0
0
0
1
0
0
0
0
0
0
0
0
1
0
1
0
0
0
0
1
0
0
0
0
0
1
0
0
0
0
0
0
0
0
0
0
0
0
0
0
1
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
1
Column
A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
R
S
Definition
Firm identification number
Average weekly gross restaurant sales
Women or minority-owned business designation
Dummy variable for women or minority-owned businesses
Is franchise or part of national brand
Dummy variable for franchise or part of national brand businesses
Has website
Dummy variable for restuarants with a website
If restaurant has road frontage (visibility)
Dummy variable of restaurant road frontage (visibility)
# of other restaurants within 5 mile radius
Marketing budget expressed as % of gross sales
Area has meals tax added on top of state sales tax
Dummy variable of meal tax added on top of state sales tax
Type of food (Italian, American, Asian, Mexican, Other)
Categorical dummy variable of American food restaurant
Categorical dummy variable of Asian food restaurant
Categorical dummy variable of Italian food restaurant
Categorical dummy variable of Mexican food restaurant
Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.
You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.
Read moreEach paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.
Read moreThanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.
Read moreYour email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.
Read moreBy sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.
Read more
Recent Comments