Price Food Decor Service East

33 19 15 18 0

37 19 17 19 1

33 18 17 18 1

41 19 17 19 0

44 20 19 20 0

31 17 15 16 0

37 17 18 15 1

44 16 16 16 1

52 20 23 20 0

24 18 13 18 1

32 18 15 17 0

38 20 17 19 0

31 18 16 17 0

49 22 21 21 1

38 21 17 20 0

51 21 20 18 1

37 20 17 19 0

56 22 17 21 1

50 22 19 22 1

46 23 19 23 1

38 18 17 18 0

38 18 16 19 1

51 24 21 21 1

53 24 20 21 1

44 22 17 21 1

29 19 15 17 0

30 19 13 20 1

33 19 17 18 0

31 20 19 19 1

49 21 18 20 0

45 22 20 22 1

43 20 16 18 1

40 19 19 18 0

53 22 24 21 0

55 22 21 20 1

49 20 19 19 1

47 18 18 17 0

31 19 16 17 1

49 22 19 20 1

46 20 18 20 1

42 21 16 20 0

51 23 22 23 1

37 19 15 19 1

37 22 18 20 1

40 20 20 20 1

25 18 15 15 1

50 23 18 20 1

43 23 20 21 1

Restaurant Data. Read the data description carefully!

For this question and the next, you will use this customer survey data of Italian restaurants in Manhattan.The data are in the form of the average of customer reviews.

The variables are defined as follows:

Price = price (in $) of dinner (including one drink and a tip)

Food = customer rating of the food (out of 30)

Decor= customer rating of the decor (out of 30)

Service= customer rating of the service (out of 30)

East = 1 if the restaurant is east of Fifth Ave, 0 if not. If it is not East of fifth Ave, it will be to the West.

You are given the regression outputs from the Restaurant data.The dependent variable is the Price.

The independent variables are:Food, Dcor, Service and East. Using the output, answer questions (a) through (e).

'

REGRESSION OUTPUT

Regression Statistics

Multiple R 0.801

R Square 0.641

Adjusted R Square 0.632

Standard Error 5.739

Observations 154

ANOVA

df SS MS F Significance F

Regression 4 8769.49 2192.37 66.56 0.000

Residual 149 4907.56 32.94

Total 153 13677.05

Coefficients Standard Error t Stat P-value Lower 95% Upper 95%

Intercept -23.839 4.800 -4.967 0.000 -33.324 -14.355

Food 1.431 0.387 3.700 0.000 0.667 2.196

Decor 1.904 0.226 8.422 0.000 1.457 2.351

Service 0.123 0.414 0.296 0.768 -0.696 0.941

East 1.860 1.001 1.858 0.065 -0.118 3.838

(a) What was the input X range that was entered to

(b) What percentage of variations in the Price is not explained by this regression model? (Round up to 2 decimal places)

(c) Are all the independent variables statistically

(d) If two restaurants have the same ratings for Food and Dcor, but one is located in the East and the other is located in the West,

(e) Find the price at a restaurant with ratings as