Reference no: EM132290559
Requirements
Use the data in the excel sheet
1 Compute correlation coefficients, the correlation matrix
2 Test the significance of correlation coefficients
3 Fit regression line and interpret intercept and coefficients
4 Check the significance of regression coefficients
5 Find residuals and estimated values of Y
6 Find the coefficient of determination
7 What is the coefficient of non-determination
8 Check the overall significance of the model
9 Find the standard error of the estimate
10 Write the reduced form of regression line after removing insignificant variables
Attachment:- Assignment.zip