View the step-by-step solution to:

# Robert has the following accounts on money spent on gambling and winnings:

Robert has the following accounts on money spent on gambling and winnings:
Money Spent Money Won
1000
1200
1800
2000
2500
2800
3500
4000
4200
2500
4000
4500
4600
5000
4800
5600
6000
5800
(a) (3 points) Use Excel to fit the above data into a regression line Write the equation of the line.
(b) (2 points) Determine the correlation coefficient and the coefficient of determination, and interpret their
values.
(c) (2 points) Use the regression equation to forecast Robert's money won when \$5000 is spent.
(d) (2 points) Include a graph consisting of the above data points and the regression line.
3

### Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

### -

Educational Resources
• ### -

Study Documents

Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

Browse Documents