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