This is a final exam. I need someone who can pay attention to the attachments and requirements. It is an excel project. I am looking for a grade of 100. My professor will not provide feedback so it will require someone knowledgeable in this field of study. Below are the required questions for the assignment.
Review the regression output in Table 2 and provide your critique of the results. What are your concerns about Venus model? (20 pts)
2. Use the data in Table 1 to recreate the regression results in Table 2. (15 pts)
3. Develop a correlation matrix for the data in Table 1. Comment on the values in your matrix and whether there are any concerns in using these variables in Venus multiple regression model. (20 pts)
4. Based on your correlation results, what one (1) variable regression model would give you the best model from among the seven (7) parameters chosen by Venus? Build a 1-variable regression model with this variable, write out your equation, and comment on the results. (30 pts)
5. Perform a step-wise regression to reduce the number of independent variables and produce a final regression model. Write out the forecast equation for your final model. (45 pts)
6. Now that you have a final model, present a pitch as to why your model is better than Venus model and whether Bayou City should use your model to invest in the Houston market. (20 pts)
