Our academic experts are ready and waiting to assist with any writing project you may have. From simple essay plans, through to full dissertations, you can guarantee we have a service perfectly matched to your needs.
GET A 40% DISCOUNT ON YOU FIRST ORDER
The table below shows the scores of 25 Mathematics students in two mid-term tests and the final exam.
Test 1Test 2Final Exam756976957593917890988498755771543951716375484858896888816082716071725671958192816976726374957696806474837792907989807180847489887088807188787175988096
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
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.