Please answer the bolded questions using Excel and show all formulas

Income	Temp	Price	Demand			The data in columns A, B, C and D represent imaginary data from all 50 states regarding soda consumption. "Demand"
11.7	66	2.19	200			represents cans of pop consumed per capita per year, "Price" represents average price of a 6-pack of pop (in $),
15.3	62	1.99	150			"Temp" represents average yearly temperature (in Fahrenheit), and "Income" represents per capita income per year (in thousands)
9.9	63	1.93	237			Use the data to answer the following 6 questions:
22.5	56	2.59	135
17.1	52	2.29	121
24.3	50	2.49	118			1) (1 point) What is the regression equation for Demand in terms of Income, Temp, and Price variables?
25.2	52	1.99	217			Write in the final equation in the highlighted cell below. However, to obtain this equation you'll need to run
16.2	72	2.99	242			regression with Excel. When it asks where you'd like to place your regression output, select a new sheetso that the regression
12.6	64	1.89	295			output appears on a new sheet within this Excel file.
14.4	46	2.35	85
21.6	52	2.17	114			Note that you are NOT to utilize the Principle of Parsimony in this quiz, i.e. run the regression only ONCE using ALL X-variables
18	52	2.18	184			and answer this question (and the ones that follow) questions based on the resulting output.
14.4	50	2.11	104			Be sure to include residuals and residual plots, and use a 95% confidence level when running your regression.
15.3	56	2	143
11.7	69	2.15	230			When writing the equation for this question, you may round your intercept and slope coefficients to nearest hundredth.
13.5	73	3	111
14.4	22	1.5	217				Equation given by running multiple linear regression:
18.9	47	1.8	114
19.8	40	1.89	108
18.9	55	1.76	248
16.2	56	1.8	203			2) (1 point) Using the regression equation, forecast demand in a situation where Income = 10, Temp = 60 and Price = 2.
9	65	1.4	77			(Use exact values from regression output in your calculations. Answer cell should show formula/cell reference/work.)
17.1	70	2.19	200
17	71	2.25	210
14.4	63	2.09	185
21.6	59	1.89	135			3) (1 point) Based only on the regression output (and the description of variables at the top of this worksheet), what would be the forecasted
13.5	60	1.83	222			effect on Demand if Price were to increase by 50 cents, all other variables remaining equal?
22.5	53	2.49	120			In other words, without regard to the other variables, how would Demand be forecasted to change if price were to increase by 50 cents?
11.2	49	2.19	106			Below, first highlight whether or not this price increase would increase or decrease demand,
14.8	47	2.39	103			and then in the green cell put a number that corresponds to the amount of this increase or decrease of demand.
9.4	49	1.89	202			As an example, if demand would increase by 5, select 'increase' and put a 5 in the answer cell. If demand would decrease by 5, select 'decrease' and put a 5 in the answer cell,
22	69	2.89	227			so the answer cell will always be positive. Answer cell should show some type of formula/cell reference/work/justification.
16.6	61	1.79	280
23.8	43	2.25	70
24.7	49	2.07	99				Demand would increase
15.7	49	2.08	169
12.1	47	2.01	89
13.9	53	1.9	128
21.1	66	2.05	215
17.5	70	2.9	96			4) (1 point) Key question #1: List all X variable(s) that are significant for the regression analysis.
13.9	19	1.4	202			(i.e. based on the regression output), which variable(s) have slope coefficients that we are confident in declaring to be non-zero?)
14.8	44	1.7	99
11.2	37	1.79	93
13	52	1.66	233
13.9	53	1.7	188
18.4	62	1.3	62
19.3	67	2.09	185			5) (1 point) Key question #3: Do the residuals appear to be independent of the Income variable? Choose the correct answer yes or no and provide a brief justification.
18.4	68	2.15	195			(Note: This question is only asking about the Income variable.)
15.7	50	2.25	160
8.5	52	2.29	200				YES	NO
										Justification:
						6) (1 point) Key question #5: Using the rule of thumb outlined in the module videos, is the standard error of the residuals (S_XY) relatively small?
						Choose the correct answer yes or no and provide a brief justification.
							YES	NO
										Justification: