Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Excluded Variables Partial Collinearity Statistics Model Beta In Sig. Correlation Tolerance Promotion .2190 1.943 058 281 1.000 Number of customers .022 .191 .850 029 1.000
Excluded Variables Partial Collinearity Statistics Model Beta In Sig. Correlation Tolerance Promotion .2190 1.943 058 281 1.000 Number of customers .022 .191 .850 029 1.000 Monthly income .380 3.386 002 .455 871 2 Number of customers .327 3.356 .002 .456 .939 Monthly income .001c .007 .994 001 .996 3 Monthly income . 084d .860 .385 132 933 a. Dependent Variable: Annual sales b. Predictors: (Constant), Store size c. Predictors: (Constant), Store size, Promotion d. Predictors: (Constant), Store size, Promotion, Number of customersModel Summary Adjusted R Std. Error of the Model R R Square Square Estimate 626a 392 378 3.3552 .719b .518 .496 3.0222 CON .786 618 591 2.7214 a. Predictors: (Constant), Store size b. Predictors: (Constant), Store size, Promotion c. Predictors: (Constant), Store size, Promotion, Number of customers ANOVAa Sum of Model Squares df Mean Square F Sig. Regression 326.565 326.565 29.010 003b Residual 506.568 45 11.257 Total 833.132 46 2 Regression 431.260 2 215.630 23.609 .003c Residual 401.872 44 9.133 Total 833.132 46 3 Regression 514.683 3 171.561 23.166 002d Residual 318.449 43 7.406 Total 833.132 46 a. Dependent Variable: Annual sales b. Predictors: (Constant), Store size C. Predictors: (Constant), Store size, Promotion d. Predictors: (Constant), Store size, Promotion, Number of customers Coefficients Unstandardized Standardized Coefficients Coefficients Model B Std. Error Beta Sig. Constant) 47.178 2.247 20.996 000 Store size 1.287 .239 626 5.386 000 2 (Constant) 53.391 2.732 19.543 000 Store size 1.567 231 762 6.796 000 Promotion 1.433 .128 380 3.386 002 3 (Constant) 52.964 3.118 15.064 000 Store size 2.521 208 293 2.815 007 Promotion 1.531 .119 .466 4.472 .002 Number of customers 1.069 002 327 3.356 003 a. Dependent Variable: Annual salesAnnual sales of a fashion store is potentially influenced by 4 factors, including store size, promotion, number of customers, and monthly income. To study the quantitative relationship between these four factors and the annual sales, data were collected and analyzed using SPSS, as shown in the Appendix. (20%) Please answer the following questions: (a) Explain how well of the final regression model. (5%) (b) Establish a multiple linear regression equation for the final model. (5%) (c) Explain whether the final model has a significant linear relationship. (5%) (d) Explain whether each factor has a significant linear relationship. (5%)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started