do the Excel

by

Description

Use the Date do the ExcelAnswer the questionsUse the training set to build a model with all variables including dummies indicating the type of foodWhat is the MAPE for this model?Do the signs of the coefficients are the same as the sign of the correlations with popularity index?Can you drop any variable to improve the model?Has the MAPE improve after dropping that variable?Are all coefficients significant on this model?Try to improve the model by dropping variables or combining variablesPlot the fitted versus the residuals for the training and for the testing set. Can you observed strange predicted values or outliers?Try to include the outlier in the testing set or remove it.What is the model? and what does it mean?Restaurant
Gotham Bar & Grill
Mas (Farmhouse)
Union Square Cafe
Four Seasons Restaurant
Saul
Gramercy Tavern
Blue Hill
Craft
Perry St.
Dovetail
Shun Lee Palace
Mr. K’s
Shun Lee West
Chin Chin
Mr. Chow Tribeca
Tang Pavilion
Mr. Chow
Shun Lee Cafe
Pig Heaven
La Caridad 78
Daniel
Le Bernardin
Bouley
Eleven Madison Park
Jean Georges
La Grenouille
Café Boulud
Jack’s Luxury Oyster Bar
Tocqueville
Triomphe
Tamarind
Amma
Yuva
Dawat
Junoon
Salaam Bombay
Mint
Darbar
Tulsi
Darbar Grill
Marea
Del Posto
Ai Fiori
Scalini Fedeli
Il Buco
Il Buco Alimentari e Vineria
Food Decor Service Cost Popularity Index
Cuisine
28
25
27
81
85 American (New)
27
24
27
88
94 American (New)
27
23
26
70
83 American (New)
27
28
27
101
92 American (New)
27
20
25
69
82 American (New)
27
26
27
114
100 American (New)
27
23
27
83
77 American (New)
26
24
25
82
53 American (New)
26
25
24
69
62 American (New)
26
23
25
74
72 American (New)
25
22
23
59
40 Chinese
24
24
23
60
35 Chinese
23
21
21
56
31 Chinese
23
19
23
54
39 Chinese
22
21
21
76
27 Chinese
22
17
21
41
40 Chinese
22
21
21
76
27 Chinese
21
18
19
46
22 Chinese
20
14
19
39
15 Chinese
19
7
14
18
15 Chinese
29
28
28
137
100 French
29
27
28
146
100 French
28
27
27
104
100 French
28
28
28
117
100 French
28
27
28
127
100 French
28
28
28
114
94 French
27
24
26
81
75 French
26
16
23
71
65 French
25
25
26
78
61 French
25
23
25
69
58 French
25
24
23
58
56 Indian
24
18
22
48
58 Indian
23
19
21
41
32 Indian
23
19
21
50
29 Indian
23
26
23
71
38 Indian
22
17
19
37
23 Indian
22
19
19
43
37 Indian
21
16
18
36
27 Indian
21
22
20
55
61 Indian
21
16
18
36
27 Indian
28
26
26
101
99 Italian
27
27
27
102
94 Italian
27
24
25
93
77 Italian
27
25
26
90
78 Italian
26
24
23
64
79 Italian
26
24
23
64
79 Italian
Piccola Venezia
Sistina
Il Tinello
San Pietro
Sushi Yasuda
Kuruma Zushi
Sushi of Gari 46
Zenkichi
Nobu 57
Nobu, Next Door
Nobu
Sushiden
Sushiden
Megu
Super Tacos
Toloache
Maya
Oaxaca
Dos Caminos
Alma
26
26
26
26
28
28
27
26
26
26
26
25
25
24
25
23
23
20
19
19
17
19
21
21
22
17
15
27
23
23
23
18
18
26
17
17
19
10
19
21
24
23
26
23
24
25
21
25
23
23
23
22
22
23
22
20
20
15
18
18
58
80
76
87
86
127
82
61
83
83
83
58
58
84
7
45
53
15
44
37
57 Italian
68 Italian
53 Italian
56 Italian
90 Japanese
54 Japanese
59 Japanese
70 Japanese
57 Japanese
57 Japanese
57 Japanese
33 Japanese
33 Japanese
45 Japanese
100 Mexican
37 Mexican
32 Mexican
20 Mexican
20 Mexican
26 Mexican

Purchase answer to see full
attachment

We offer the bestcustom writing paper services. We have done this question before, we can also do it for you.

Why Choose Us

  • 100% non-plagiarized Papers
  • 24/7 /365 Service Available
  • Affordable Prices
  • Any Paper, Urgency, and Subject
  • Will complete your papers in 6 hours
  • On-time Delivery
  • Money-back and Privacy guarantees
  • Unlimited Amendments upon request
  • Satisfaction guarantee

How it Works

  • Click on the “Place Order” tab at the top menu or “Order Now” icon at the bottom and a new page will appear with an order form to be filled.
  • Fill in your paper’s requirements in the "PAPER DETAILS" section.
  • Fill in your paper’s academic level, deadline, and the required number of pages from the drop-down menus.
  • Click “CREATE ACCOUNT & SIGN IN” to enter your registration details and get an account with us for record-keeping and then, click on “PROCEED TO CHECKOUT” at the bottom of the page.
  • From there, the payment sections will show, follow the guided payment process and your order will be available for our writing team to work on it.