This assignment will assess your ability to apply the concepts of chapter 10 to conduct simple and multiple regression analyses to create a prediction model for home prices.Preview the document based on 4 independent variables. You will calculate various descriptive statistics, create summary tables, create various charts and develop 5 regression prediction models. Finally, you will create a written report summarizing your findings. You will need to use the Data Analysis ToolPak Add-in as you did in Case Study 1.
Refer to the video on how to run regression analysis in Excel (Links to an external site.). The video demonstrates multiple regression. To perform a simple regression, just the column for one independent variable instead of multiple columns.
Details of the assignment are contained in the document MBA 6350 Case Study 2.docxPreview the document.