Here is the link of the excel file, easy for tutor to answer the question. And the second image is an EXAMPLE only, pls do it like this. TQ.

https://docs.google.com/spreadsheets/d/10EVkw7Pbf7ieRz3MtN7LZRKE9FeVonmrXqkHe1LDiXU/edit#gid=1821406036

TEHI' Average Rate 1999 1991 1992 1993 1994 1995 1999 199? 1999 1999 2999 2991 2992 2993 2994 2995 2999 299? 2999 2999 2919 2911 2912 ?5999 4.5999 3J999 92999 52599 55999 59999 52999 52599 99999 9.?599 32999 2.2999 12599 2.2999 4.1999 52599 4.?599 95999 9.9299 9.?599 1.1999 9.9999 Analyze the above date and write the followings: 1 2 3 Determine the relationshipi'eest of the W and 99 of the above case. II.I"|..'r'ite a conclusion for each aspect of the result yield from the analysis. Attach the tabulation of analysis result upon submission of the assignment. {5 marks) [12mem {3 marks) MLR_AT&T SUMMARY OUTPUT Regression Statistics Multiple R 0.86836369 R Square 0.7540555 Adjusted R Square 0.74542587 Standard Error 2.47551586 Observations 60 ANOVA of SS MS F Significance F Regression 2 1070.95808 535.479041 87.3798008 4.3537E-18 Residual 57 349.306191 6.12817879 Total 59 1420.26427 Coefficients Standard Eno. 1 Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0% Intercept 11.7110643 1.55801101 7.51667625 4.3796E-10 8.59120111 14.8309276 8.59120111 14.8309276 Microsoft 0.0080573 0.03452971 0.23334406 0.81633022 -0.0610872 0.07720185 -0.0610872 0.07720185 Nordstrom 0.31663564 0.06517239 4.85843202 9.6318E-06 0.18613017 0.4471411 0.18613017 0.4471411 CONCLUSION: R Square The R Square indicates that 75% of the variation in AT&T Sales is explained by returned items by Microsoft and Nodstrom. F-test From the result of significant F in ANOVA, it indicates that (Sig F=4.35E18) which is less than the a = 0.05, therefore we reject the null hypothesis. In this analysis, it concludes that one of the slopes is statistically different from zero. OR It concludes that the changes on returned items by Microsoft and Nodstrom is related to changes of AT&T Sales. Coefficient From the result of coefficient, it shows that the p-value for Nordstrom (9.63E06) is less than a = 0.05, therefore we reject the null hypothesis for the regression coefficient of Nordstrom and conclude that it is statistically significant. Whereas, for the Microsoft it indicates that p-value=0.82 is more than a = 0.05, therefore the null hypothesis is failed to be rejected and conclude that it is not statistically significant