Statistics questions

Your group wants to see how the rating of the restaurant experience relates the quality characteristics of the restaurant experience as measured by the variables cost, food, décor, service and location. There are 100 observations and each observation corresponds to a restaurant. Download data set: 

RestaurantsData.xlsx

• Dependent (Response) Variable: Rating
• Candidate Independent (Predicting) Variables: Cost, Food, Décor, Service, Location

As a group, do following and submit one summary document and one excel file. The objective of this activity is to provide the practice opportunity for the project, so that you can help each other to do better job on your own Data Analysis Project. 

Part I  

1. Create a scatter plot of your response variable and each of the predicting variables. Describe any patterns you observe in each
2. Pick one of the four predicting variables as your predicting variable and fit a simple linear regression model. Present regression equation and interpret the slope coefficient.
3. What is the coefficient of determination (R2R2) of your regression model? Explain the meaning of the coefficient of determination.
4. Comment on the strength of your regression model based on the value of.
5. Is there a linear relationship between your response variable and predicting variable? Specify your hypothesis and run a statistical hypothesis test for the significance of the slope coefficient. Draw your conclusion of your hypothesis test.

Part II

1. Add the second predicting variable to your regression model and run the regression. Check the signs of the estimated coefficients of your model. Are the signs consistent with your expectations?
2. Interpret the estimated coefficients of your model.
3. Is the multiple regression model significant? In other words, is there a linear relationship between your response variables and the predicting variables?  Run a hypothesis test to justify your answer.  Assume αα=0.05.
4. Run the multiple regression using all five independent variables. Briefly discuss which module is better with two independent variable or all five independent variables.

This is due July 21 2018 by 4:00 pm eastern standard time. It’s my assignment not a group despite what is says. 

Data

21 20 City

53

21 20 City

23 23

City

62

23 18 21 City

18 19 City

62 47 22 19 21 City

22 21 18 City

27

City

20

22 City

23 22 22 City

53 20 19 20 City

19 18 City

67 63 24 22 21 City

68 27 17

City

54

19 16 19 City

23 19 18 City

59

19 22 18 City

63 57 23 20 20 City

29 21 16 18 City

56

22

21 City

63

22 20 21 City

23 21 26 City

58 42 20 19 19 City

53 23 22 21 City

62 30 20 23 19 City
61 64 21 21 19 City

24 26 23 City

62 57 22 19 21 City
68

22 24 22 City

60 51 20 20 20 City
56

23

18 City

61

22 19 20 City

59

20 18 21 City

65 69 24 19 22 City
55

21 15 19 City

64 55 22 20 22 City

38 17 16 17 City

61 54 25 16 20 City
65 57 24 19 22 City
59

20 21 18 City

62 62 23 19 20 City
55 44 21 13 21 City
62 44 23 20 19 City
55

20 17 18 City

58 53 20 19 19 City
69 45 24 21 24 City
63 55 21 22 20 City

26 22 26 City

69 92 25 20 24 City
61

22 19 20

68

23 22 23 Suburban

57 48 18 21 18 Suburban
68

25 19 24 Suburban

65 58 25 17 23 Suburban
58 51 19 22 17 Suburban
67 48 25 20 22 Suburban
58

20 18 20 Suburban

68 48 24 19 25 Suburban
56

18 20 18 Suburban

61 43 20 19 22 Suburban
57 42 21 17 19 Suburban
70

23 24 23 Suburban

62 49 20 24 18 Suburban
66 38 22 23 21 Suburban

48 26 23 23 Suburban

63 48 23 17 23 Suburban
66 56 25 17 24 Suburban
61 41 21 19 21 Suburban
63 41 23 18 22 Suburban
64 47 23 19 22 Suburban
49 30 19 13 17 Suburban
58 32 19 17 22 Suburban
63 54 23 18 22 Suburban
49 32 22

17 Suburban

64 44 23 20 21 Suburban
68 48 23 24 21 Suburban
57 45 19 19 19 Suburban
62 43 22 19 21 Suburban
56 36 20 17 19 Suburban
68 48 22 25 21 Suburban
65 50 26 18 21 Suburban
61 48 22 18 21 Suburban
77 61 24

25 Suburban

54 35 19 16 19 Suburban
58 30 22 16 20 Suburban
56

20 17 19 Suburban

53 23 24 24 Suburban

55 36 20 16 19 Suburban
73 46 26 21 26 Suburban

56 27 24 27 Suburban

54 44 17 19 18 Suburban
59 29 25 16 18 Suburban
60 32 18 20 22 Suburban
60 46 18 21 21 Suburban
61 47 20 20 21 Suburban
56 48 21 15 20 Suburban
60 35 21 18 21 Suburban
57 31 19 19 19 Suburban
52 28 19 15 18 Suburban

Summated Rating	Cost	Food	Decor	Service	Location
			49					27																																									20	11																												18																																																		City
									62						53																																								21
				64																														23
							68					65																																					22
			47
								56			46																																														19
									61			51
	77	81																			24									26
							58								57									16
		67								63
				59
					54				30																17
			69											25
		29
				60					44
									48
						55
34			13
		42
	70	76
		66
	73	88
82
		38				15
		41
			32
		45
	50
	31
		43
74		92
		35																																																		Suburban
33
	52
40
		36
39
72
10
	28
37
71
78