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

- Your assistant has been reading the IASB’s Framework for the Preparation and Presentation of Financial Statements (the Framework) and, as part of the

- 1. Suppose you make 30 annual investments in a fund that pays 6% compounded annually. If your first deposit is $7,500 and each successive deposit is 6%

- 1. Jeff decides to start saving some money from this upcoming month onwards. He decides to save only $500 at first, but each month he will increase the