Essay

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 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.

https://youtu.be/0lpfmFnlDHI

Please 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.docx.