Instructions
The table below shows the scores of 25 Mathematics students in two mid-term tests and the final exam.
Test 1Test 2Final Exam756976957593917890988498755771543951716375484858896888816082716071725671958192816976726374957696806474837792907989807180847489887088807188787175988096
Tasks:
- Perform multiple linear regression analysis using Microsoft Excel, assuming final exam score as the dependent variable and test 1 and test 2 scores as independent variables.
- Correctly state the regression equation.
- Evaluate the significance of the regression fit for the data.
- Determine if the regression coefficients are significant.
- Check if independent variables are collinear.
- Comment on the residual plots.
- Use the regression equation to predict final exam score for
- test 1 score = 82, and
- test 2 score = 69
Submission Details:
- Submit a 34 page Microsoft Word document, using APA style.
- The relevant Excel output should be copied to this document.
- Name your document BUS7205_W1_Project_LastName_FirstInitial.doc.
