Explore BrainMass
Share

# Correlation & Regression Analysis

This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

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..