Marketing Research

QUESTION 23 5 points (use the provided Excel file for this question) Locate the "Yelp Rating Data" tab. Run a regression using each restaurant's Yelp Rating as the dependent variable (Y) and all other variables as the independent variables (X) CHINE You will need to create durmy-code columns for Local (yes) and Free Delivery (yes)) Based on the regression yod ran above, which of the fotowing are significant predictors of Yelp ratings for these restaurants Free Delivery Hours Open Menu Items Local Codebook Dependent va Yelp Rating the yelp rating 15 stars for the restaurant Independent Free Delivery does the restaurant offer free delivery yes, no Hours Open the total number of hours the restaurant is open every day Menu Items the total number of items on the restaurant's menu Local is the restaurant local local, national) Yelp Rating Free Delivery Hours Open Menu Items 2.15 NO 20 66 2.17 YES 17 65 2.26 NO 22 2.28 NO 12 33 2.31 NO 23 58 2.38 YES 22 32 2.49 NO 22 2.5 NO 12 50 2.64 YES 20 46 3.05 YES 21 37 3.14 YES 16 24 3.24 YES 24 24 3.4 NO 20 32 3.53 NO 15 3.61 NO 24 3.63 NO 10 21 3.74 NO 23 28 3.85 NO 10 20 3.92 YES 10 20 3.94 NO 15 20 4,01 YES 17 25 4.06 YES 22 25 4.41 YES 10 18 4.51 NO 13 17 3G888888888 Local NATIONAL LOCAL LOCAL NATIONAL NATIONAL NATIONAL NATIONAL LOCAL NATIONAL NATIONAL NATIONAL LOCAL NATIONAL NATIONAL NATIONAL NATIONAL NATIONAL LOCAL LOCAL NATIONAL NATIONAL LOCAL NATIONAL LOCAL 4.53 NO 18 17 LOCAL 4.57 NO 11 22 LOCAL 4.59 NO 13 21 4.67 YES LOCAL NATIONAL 17 21 4.69 YES 16 21 LOCAL YES 21 16 4.69 4.79 NATIONAL LOCAL NO 19 20 4.96 NO 17 19 LOCAL W! QUESTION 23 (use the provided Excel file for this question) Locate the "Yelp Rating Data" tab. Run a regression using each restaurant's Yelp Rating as the dependent variable (V) and all other variables as the independent variables (X) (HINT: You will need to create dummy-code columns for Local (1=yes) and Free Delivery (1=yes)) Based on the regression you ran above how much of the variance in Yelp ratings is explained by this model (ie this set of predictors)? 100% a whole bunch of the percents 775 88% F H L M N 0 P o 20 G Codebook Dependent ViYelp itating the yelp rating (1-5 star for the restaurant Independent Free Delivery does the restaurant offer free delivery (yes, no Hours Open the total number of hours the restaurant is open every day Menu item the total number of items on the restaurant's menu Local is the restaurant local local, national) 3.05 3.63 B C D 1 Yelp Rating Free Delivery Hours Open Menu Items 2 2.15 NO 20 60 3 2.17 YES 17 65 4 2.26 NO 22 60 5 2.26 NO 12 13 6 2.31 NO 23 58 7 2.38 YES 22 32 8 2.49 NO 22 31 9 2.5 NO 12 50 10 2.64 YES 46 11 YES 21 37 12 3.14 YES 16 24 13 3.24 YES 24 24 3.4 NO 32 75 3.53 NO 15 30 16 24 29 17 3.61 10 18 3.74 NO 23 28 79 3.85 10 20 20 3.92 10 20 3.94 NO 15 20 22 4.01 YES 17 25 23 YES 22 25 4 4.41 YES 10 18 35 NO 13 17 26 4.53 NO 17 27 4.57 NO 11 22 20 4.59 NO 13 21 29 4.67 VES 17 21 30 4.69 YES 16 21 91 4.09 YES 21 16 32 4,79 NO 19 20 33 4,96 NO 17 19 84 35 36 32 E Local NATIONAL LOCAL LOCAL NATIONAL NATIONAL NATIONAL NATIONAL LOCAL NATIONAL NATIONAL NATIONAL LOCAL NATIONAL NATIONAL NATIONAL NATIONAL NATIONAL LOCAL LOCAL NATIONAL NATIONAL LOCAL NATIONAL LOCAL LOCAL LOCAL LOCAL NATIONAL LOCAL NATIONAL LOCAL LOCAL 4.06 451 SENSORSRS home value date Grade Regression Output Yep Rating Duta ANOVA