Regression and correlation. Pick any two columns that have a correlation coefficient greater than 0.6 or less than -0.6. Pick the one with the highest absolute value. (attached xls)
a. Draw the scatter diagram of Y against X, and explain any noted significance.
b. Compute correlation coefficient (Ã?Â? or r), and what do you find? Explain results.
c. Obtain a and b of the regression equation defined as Y = a + b X, and the Coefficient of Determination (r2) from the Excel regression output. What is the relationship between r2 and Ã?Â??
d. Compute the above statistics in 4) step by step using SXiYi, SXi, SYi, SXi2, SYi2 from Excel, and compare them with the results in C).
e. Draw the fitted regression line on the scatter diagram, obtain the residuals and plot them on the scatter diagram too. Explain your findings.
f. Report on any observations on the data, regression estimates or the regression residuals;
g. Calculate the additional y values for at least five other x values that do not appear in the data. Include that information in the above and comment on whether you believe the calculate y value seems realistic and consistent with the other information you have calculated in each of the parts above..© BrainMass Inc. brainmass.com October 10, 2019, 3:51 am ad1c9bdddf
The solution provides step by step method for the calculation of correlation matrix and regression analysis. Formula for the calculation and Interpretations of the results are also included.