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

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

### Recently Asked Questions

- You are considering moving your money to new bank offering a one-year CD that pays an 7% APR with monthly compounding. Your current bank's manager offers

- Please refer to the attachment to answer this question. This question was created from Chem 1A03 Quiz 6.

- pls help me with those psychology question： 1. Jane goes to an art gallery and is looking at a beautiful, colourful painting. Oh no! The power goes