Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribedimage text in transcribedimage text in transcribed
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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

The Art Of Proof Basic Training For Deeper Mathematics

Authors: Matthias Beck, Ross Geoghegan

1st Edition

1441970231, 9781441970237

More Books

Students also viewed these Mathematics questions

Question

How competitive is the external environment of your organization?

Answered: 1 week ago

Question

What other organizations compete on this issue?

Answered: 1 week ago

Question

What significant opposition exists?

Answered: 1 week ago