Instructions The table below shows the scores of 25 Mathematics students in two mid-term tests
Need help with this assignment?Get an original answer from a qualified tutor — from $10/page.
Get it written →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 3–4 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.
Get a plagiarism-free answer to this question
Send us your instructions and we’ll match you with the best writer in your subject.
- 100% human-written, zero AI
- Turnitin report included
- Confidential — we never share your data
- Free revisions & refunds