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 17, 2018, 12:56 pm ad1c9bdddf
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.
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)
Not sure on which formulas to use. ThanksView Full Posting Details