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.
Details of the assignment are contained in the document MBA 6350 Case Study 2.docx.

Leave a Comment

Your email address will not be published. Required fields are marked *