regression analysis in Excel

\fThe basic model that Q = f (X1, X2, X3) Do the followings: i. Estimate the demand for soft drinks using a multiple regression program available. ii. Interpret the coefficients regard to the magnitude and strength of relationship between variable Y and independent variables. iii. Identify the significant and most dominant variables in the model i.e. which ones are significant by performing t test using critical value method iv. Omit variable Price from the regression equation and oberve the bias introduced into the parameter estimate for income v. Omit both variable Price and Temparature from regression equation. Should a marketing plan for soft drinks be designed that relocates most canned drink machines into low-income neighbourhoods? Why or why not? v. Make recommendations from the results in (i) in order to increase the sale of soft drink