Thank you so much for helping i will give you a upvote

Question 5: (15pts) The table below shows some past sales data from a clothing company. Each row shows the sales for a year, and the amount spent on advertising in that year. Year Advertising (Million Dollars) Sales (Million Dollars) 23 651 2 30 856 3 34 1063 4 43 1190 5 52 1421 Use linear regression to calculate the relationship between the advertising and sales. Calculate the correlation coefficient between the amounts of advertising and sales. If there is no advertising, what is the expected sales? If the amount of advertising is 63 million dollars in the next year, what is the prediction of the sales