[ORDER SOLUTION] Regression Equation

Walden Attachment – Looking at the Excel output, and the Regression Equation they wrote out, interpret the slope of their Regression Equation.  Use the Regression Equation to make a prediction and show the work for your predicted value based on your expression.   For Example, if the attachment used Year to predict Price, plug in a Year value into the regression equation and use it to predict the Price of a vehicle.  Does this predicted Price value make sense with their data? Jackson Attachment – It is important to remember that typically a two-factor regression model cannot accurately describe the entire situation. Look at the dependent variable on attachment. Name at least 2 independent factors you would use to run a Multiple Linear Regression (MLR) and explain why you feel they are related.  Then use those factors to run a Multiple Linear Regression (MLR) on the attached data and see if the variables you chose are related to the dependent variable they chose.  What is your MLR equation?  Is your MLR significant?  Are any of the Independent factors significant?  What is the R2 value?  Explain and interpret this value and how it relates to the MLR.  Make sure you include your MLR Excel output as an attachment in your response post.