Question: For this lab assignment you will be using Excel to run a multiple regression. Multiple regression is used to compare two or more predictor independent
For this lab assignment you will be using Excel to run a multiple regression.
Multiple regression is used to compare two or more predictor independent variables (x) and one outcome dependent variable (y).
For this assignment you are to do a multiple regression (multiple independent variables and one dependent variable)
You can select any data that you wish for this lab assignment, and whatever you use must be put into Excel. You will create a regression model to see if you can accurately predict an outcome variable. I suggest using the closing share price of a publically traded stock, but the data you select is entirely up to you. Feel free to have fun with this assignment!
Your submission should be in an Excel document, and should include the data, the regression output, charts of the predicted data and the actual data, as well as an explanation that with your analysis which should include a detailed explanation of the model (including the R correlation coefficient, R-squared, and finally what your view of the model is (is it useful or not).
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
