Question: Time left 3:55:1 QUESTION 4 (30 points): You are thinking about opening a clothes store. Before you make your final decision, you would like to


Time left 3:55:1 QUESTION 4 (30 points): You are thinking about opening a clothes store. Before you make your final decision, you would like to examine which factors appear to be related with the profits of clothes stores. You collect data from a sample of stores regarding their annual "profit" (in thousands of euros), the number of parking places for the store, the number of years that the owner has the store, the number of hours of operation and the number of employees. The results from the SPSS analysis appear below. Answer questions 1) to 5) that follow. Model Summary Adjusted R Std. Error of the Model R R Square Square Estimate 812 660 556 9.73997 ANOVA Model Sum of Squares df Mean Square F Sig Regression 2395.229 4 598.807 6.312 .005 Residual 1233.271 13 94.867 Total 3628.500 17 Coefficients Unstandardized Standardized Coefficients Coefficients Model B Std Error. Beta Sig (Constant) 43.132 9.345 4.616 000 Parking 5.348 .087 686 4.007 .001 Years 1.284 1.265 168 1.015 .329 Operation hours -.184 .351 -.090 .524 .609 Employees -2.964 1.061 -.452 -2.792 .0151) (4 points) Perform an overall F test and write your conclusions. Use a 1% level of significance. 2) (8 points) According to your results in part 1) continue by testing which factors significantly affect the profits of a store. Use a 10% level of significance. 3) (8 points) Write your final estimated model and interpret the coefficients. 4) (5 points) Does the model have a good fit to the data? Explain. 5) (5 points) Estimate the profits of a stores that has 3 parking places, the owner has it for 5 years, it is open for 8 hours every day and there are 2 employees
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
