SUMMARY OUTPUT Regression Statistics Multiple R 0.9647318279 R Square 0.9307074998 Adjusted R Square 0.917715156 Standard Error 8.5638366802...

Please Assist, I need this by 11/20 at 11:59 pm EST.

The Excel data file contains the following variables:

Column 1: Response variable y=3-yr % Chg

Column 2: x1=52 week %Chg;

Column 3: x2=52 week Low;

Column 4: x3=52 week High;

[Continue making columns through x9 using the information below.]

x4= YTD %Chg; x5=Daily %Chg; x6=Daily Chg; x7=Daily Close;

x8=Daily Low; x9=Daily High

1. Write down the estimated regression model between the y-variable and the above x-variables(keep 4 decimals) from the given multiple regression output.
2. Use 5% as the significance level to evaluate which x-variables are significant and insignificant. (Which x-variable is the most significant and which x-variable is the least significant?)
3. Set up a new regression model by using ONLY the significant x-variables in item 2. and the variable and estimate the model parameters. (Write down the estimated regression model.)