please do it correctly. previous tutor got it wrong. do it on excel if it requires.

The president of a company was interested in determining whether there is a correlation between sales made by different sales teams and hours spent on employee training. These figures are shown. Sales (in thousands) Training Hours 18 7 30 12 25 10 48 14 7 4 The correlation coefficient is a. Compute the correlation coefficient for the data. (Round your answer to 4 decimal places, e.g., 500.2555.) 17.732 What is your interpretation of this value? (Dort round your intermediate computations to answer this question.) There is a strong positive linear association between sales and training hours b. Using the data what would you expect sales to be if training was increased to 18 hours? Use the linear regression model (Round your answer to 2 decimal places, ca. 500.25.) Sales = 44.44 (in thousands)