1. Large Data Set 12 lists the golf scores on one round of golf for 75 golfers first using their own original clubs, then using clubs of a new, experimental design (after two months of familiarization...

Please paste or image your Excel output into Word or PDF. You must include your Excel output (pasted into Word or PDFed) after conducting the regression analysis. Please do not provide the complete data in Word or PDF, just give me the output from the data analysis toolpak regression output.


1. Large Data Set 12 lists the golf scores on one round of golf for 75 golfers first using their own original clubs, then using clubs of a new, experimental design (after two months of familiarization with the new clubs). Plot the scatter diagram with golf score using the original clubs as the independent variable (x) and golf score using the new clubs as the dependent variable (y). Comment on the appearance and strength of any linear trend. http://www.flatworldknowledge.com/sites/all/files/data12.xls 2. Large Data Set 12 lists the golf scores on one round of golf for 75 golfers first using their own original clubs, then using clubs of a new, experimental design (after two months of familiarization with the new clubs). Compute the linear correlation coefficient r. Compare its value to your comments on the appearance and strength of any linear trend in the scatter diagram that you constructed in the second large data set problem for Section 10.1 "Linear Relationships Between Variables". http://www.flatworldknowledge.com/sites/all/files/data12.xls 3. Large Data Set 12 lists the golf scores on one round of golf for 75 golfers first using their own original clubs, then using clubs of a new, experimental design (after two months of familiarization with the new clubs). http://www.flatworldknowledge.com/sites/all/files/data12.xlS a) Compute the least squares regression line with scores using the original clubs as the independent variable (x) and scores using the new clubs as the dependent variable (y). b) Interpret the meaning of the slope β^1 of regression line in the context of problem. c) Compute SSE, the measure of the goodness of fit of the regression line to the sample data. d) Estimate the score with the new clubs of a golfer whose score with the old clubs is 73. 4. Large Data Set 12 lists the golf scores on one round of golf for 75 golfers first using their own original clubs, then using clubs of a new, experimental design (after two months of familiarization with the new clubs). http://www.flatworldknowledge.com/sites/all/files/data12.xls a) Compute the 95% confidence interval for the slope β1 of the population regression line with scores using the original clubs as the independent variable (x) and scores using the new clubs as the dependent variable (y). b) Test, at the 10% level of significance, the hypothesis that the slope of the population regression line is different from 1, against the null hypothesis that it is exactly 1. 5. Large Data Set 12 lists the golf scores on one round of golf for 75 golfers first using their own original clubs, then using clubs of a new, experimental design (after two months of familiarization with the new clubs). Compute the coefficient of determination and interpret its value in the context of golf scores with the two kinds of golf clubs. http://www.flatworldknowledge.com/sites/all/files/data12.xls 6. Large Data Set 12 lists the golf scores on one round of golf for 75 golfers first using their own original clubs, then using clubs of a new, experimental design (after two months of familiarization with the new clubs). http://www.flatworldknowledge.com/sites/all/files/data12.xls a) Thurio averages 72 strokes per round with his own clubs. Give a point estimate for his score on one round if he switches to the new clubs. b) Explain whether an interval estimate for this problem is a confidence interval or a prediction interval. c) Based on your answer to (b), construct an interval estimate for Thurio’s score on one round if he switches to the new clubs, at 90% confidence.