Problem 4. Let the input a be the total seasonal depth of applied water in inches, and let the output y be the average yield of alfalfa in tons per acre. The data given by the table below was compiled by the UC Experimental Station. I 12 18 24 30 36 y 5.27 5.68 6.25. 7.21 8.20 42 8.71 Compute the formula for the empirical regression line corresponding to this data. This is a problem in Chapter 14 of the text.

Question 3 A. The information below shows the age and the number of sick days taken for 6 employees at a biscuit factory. Age(x) 18 26 39 48 53 58 Number of sick days(Y) 16 12 9 5 6 2 Table 3. Using the information above: i. Determine the product-moment coefficient (r) ii. Calculate the coefficient of determination and interpret your answer iii. Determine the equation of the regression line iv. Use the equation of the regression line to estimate the number of sick days that would be taken by an employee who is 47.

Parts A, C, and D. Can you put them all on one excel graph please. It should be one figure with three lines.

Question #8 Use the given data to find the equation of the regression line. Examine the scatterplot and identify a characteristic of the data that is ignored by the regression line.   x 12 6 10 13 11 5 8 14 9 7 15   y 14.29 6.91 13.15 14.37 13.88 4.53 10.69 14.11 12.08 8.97 13.53     y= ________ + ________ x (Round to two decimal places as​ needed.)   Create a scatterplot of the data. Choose the correct graph below. ( Grapghs are attached)    Identify a characteristic of the data that is ignored by the regression line.   A. There is no trend in the data. B. There is an influential point that strongly affects the graph of the regression line. C. The data has a pattern that is not a straight line. D. There is no characteristic of the data that is ignored by the regression line.