academicexperts

Overview
Developing quantitative recommendations and financial forecasts using linear regression models to inform decision-making is a critical part of effective business planning. In this   assignment you consider the Casey Hardware Stores Scenario to develop financial             forecasting models. You will use linear regression to inform a recommendation to             management regarding store expansion.
Instructions
Use the following scenario and templates to complete the assignment:
Casey Hardware Scenario [PDF] 
Week 7 Assignment Word Template [DOCX] 
Week 7 Assignment Excel Template [XLSX] 
Create a scatter plot for Part A that accurately depicts the data contained in Table 1, and         support 2 valid conclusions regarding the relationship between profits and sales.
Use Excel to perform the Part A linear regression with no errors
Interpret results of the Part A linear regression by accurately identifying and interpreting all      specified parameters.
Create scatter plots for Part B that accurately depict the data in Table 2, and support two valid conclusions regarding the relationship between profits and sales.
Use Excel to perform the Part B linear regression with no errors.
Interpret results of the Part B linear regression by accurately identifying and interpreting all      specified parameters.
Perform all necessary calculations in Table 4 to accurately determine the profitability of each specified location based upon the multiple regression analysis results from Part B to recommend the location for the next store opening.