1. Describe the overall explanatory power of this regression model, as well as the relative importance of each continuous variable. (attached)
2. Based on the importance of the binary or dummy variable that indicates superstore competition, do superstores pose a serious threat to Columbia's profitability?
3. What factors might Columbia consider in developing an effective competitive strategy to combat the superstore influence?
See attached file for full problem description.© BrainMass Inc. brainmass.com October 16, 2018, 7:42 pm ad1c9bdddf
The solution gives the step by step procedure for the regression analysis of profit margins for Columbia data.
Regression Analysis: Columbia Drug Stores
In five-to-seven pages of double-spaced writing in a Word document, answer the following questions:
1. Based on the text above, build a multiple linear regression population model to analyze the impact of the preceding determinants on Columbia's profitability. What is the multiple linear regression population equation? What are the assumptions underlying the model?
2. Using Excel and the accompanying dataset, estimate the population model. Copy and paste your Excel output into your Word document.
3. Based on the Excel output, what is the estimated regression equation?
4. Interpret all coefficient estimates. Identify the significance level for all of these estimates. Are any of the independent variables likely to actually influence Columbia's profitability? Are your estimates consistent or inconsistent with the a priori conjuncturesfound in the article? (E.g., advertising intensity is thought, a priori, to increase profit margin. Does your coefficient on advertising intensity and its associated p-value suggest
that it is directly correlated with profit margin?)
5. What portion of the variability in profit margin is explained by variability in the independent variables? Is the estimated regression equation a good fit for explaining profit margin?
6. Based on the estimate of the coefficient on Superstore Dummy and its associated p-value, do you believe that superstores pose a threat to Columbia's profitability? Expand on the theoretical foundation for this conclusion, i.e., why would the existence of competitor superstores affect Columbia's profitability?