Explore BrainMass

Scatter Plots and Correlation Coefficients

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

Question 1: Problem 2.13 from the text. Use Excel to construct your scatter plot. Write your answers to the questions in a word document. Include the scatter plot you created in your word document.

Question 2: Problem 2.37 from the text. Use Excel to construct a scatter plot. Compute the correlation coefficient by using columns in excel. You may use excel to do the hand computations. In other words you may use excel to sum up the column compute the squares of each column, etc. Answer any question in a word document.

Question 3: Problem 2.61 from the text. Use Excel to perform all of the computations and upload your work.

© BrainMass Inc. brainmass.com October 25, 2018, 10:03 am ad1c9bdddf


Solution Summary

This solution is comprised of a detailed explanation for correlation coefficient and scatter plots. The data analysis tool is used for the correlation analysis in Excel, correlation coefficient is also calculated manually by showing all the formulas and calculations. Full interpretation is given for correlation and scatter plots.

See Also This Related BrainMass Solution

Scatter plot, correlation coefficient, and a hypothesis test

(a) Make a scatter plot of the data. What does it suggest about the correlation between X and Y? (b) Use Megastat or Excel to calculate the correlation coefficient. (c) Use Excel to find t.05 for a two-tailed test. (d) Calculate the t test statistic (e) Calculate critical value of ra. (f) Can you reject p=0?

Orders(X) Shipping (Y)
1068 4489
1026 5611
767 3290
885 4113
1156 4883
1146 5425
892 4414
938 5506
769 3346
677 3673
1174 6542
1009 5088

Not sure on which formulas to use. Thanks

View Full Posting Details