Question

Score: 0.14 of 1 pt 4 of 4 (4 complete) HW Score: 78.57%, 3.14 of 4 % 9.4.5-T B Question Help Use technology to find (a) the multiple regression equation for the data shown in the accompanying table, (b) the standard error estimate and interpret the result, and (c) the coefficient of determination and interpret the result. The accompanying table shows the total square footages (in billions) of retailing space at shopping centers, the numbers in thousands) of shopping centers, and the sales (in billions of dollars) for shopping centers for eight years. Click the icon to view the data table on shopping center sales. (a) What is the regression equation? (Round to two decimal pl Shopping center sales Х Sales, y Total square footage, X Shopping centers, Xz 123.3 211.2 385.7 475.3 641.8 716.3 768.8 806.1 851.1 893.6 933.7 1.4 2.2 3.0 3.4 4.2 4.6 4.7 4.8 4.9 5.0 5.1 13.5 17.5 22.5 25.932.6 37.9 39.1 39.4 40.1 41.2 42.1 Print Done

Answer 1

SUMMARY OUTPUT
Regression Statistics
Multiple R	0.994242
R Square	0.988518
Adjusted R Square	0.985647
Standard Error	33.52049
Observations	11
ANOVA
	df	SS	MS	F	Significance F
Regression	2	773853.8	386926.9	344.3564	1.74E-08
Residual	8	8988.987	1123.623
Total	10	782842.7
	Coefficients	Standard Error	t Stat	P-value	Lower 95%	Upper 95%
Intercept	-243.944	34.65695	-7.03881	0.000108	-323.863	-164.025
X1	54.31034	69.84374	0.777598	0.459182	-106.75	215.3703
X2	20.29176	8.494615	2.38878	0.043939	0.703147	39.88038

Y = -243.94 + 54.31*X1 +20.29*X2

..........

R Square	0.9885
Standard Error	33.520

.............

Please let me know in case of any doubt.

Thanks in advance!

Please upvote!