Correlation & Regression Analysis
Not what you're looking for?
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..
Purchase this Solution
Solution Summary
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.
Purchase this Solution
Free BrainMass Quizzes
Probability Quiz
Some questions on probability
Graphs and Functions
This quiz helps you easily identify a function and test your understanding of ranges, domains , function inverses and transformations.
Geometry - Real Life Application Problems
Understanding of how geometry applies to in real-world contexts
Exponential Expressions
In this quiz, you will have a chance to practice basic terminology of exponential expressions and how to evaluate them.
Know Your Linear Equations
Each question is a choice-summary multiple choice question that will present you with a linear equation and then make 4 statements about that equation. You must determine which of the 4 statements are true (if any) in regards to the equation.