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 Won100012001800200025002800350040004200250040004500460050004800560060005800(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 theirvalues.(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

Prof. Angela


Calculate Price

Price (USD)