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

Calculate Price


Price (USD)
$