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

- How are requirements treated differently on a Scrum project than a traditional, sequential development project. Can you share with me an example?

- Please refer to the attachment to answer this question. This question was created from networking-tutorial.pdf. Additional comments: "Also "

- Advance Care Planning and Analysis The discussion assignment provides a forum for discussing relevant topics for this week on the basis of the course