Audio Visual Presentation
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.