Please help with the question
QUESTION 2 [29] The table below shows x- number of times absent from lectures and y - DP mark in the course where lectures are presented for each of 14 students. 6 3 X 5 3 7 12 0 5 6 4 10 26 62 69 65 69 71 63 65 44 68 63 50 55 30 The output obtained from fitting a least squares regression line in R is shown below. coefficients: Estimate Std. Error t value Pr(>|tl) (Intercept) 68. 015 6. 592 10. 319 2. 55e-07 * * * X -2. 114 1. 084 -1. 951 0. 0748 . Signif. codes: 0 '* * *' 0. 001 '* * ' 0. 01 *' 0. 05 . ' 0.1 Residual standard error: 13.17 on 12 degrees of freedom Multiple R-squared: 0. 2408, Adjusted R-squared: 0.1775 F-statistic: 3. 806 on 1 and 12 DE, p-value: 0. 07481Multiple R-squared: 0. 2408, Adjusted R-squared: 0.1775 F-statistic: 3. 806 on 1 and 12 DE, p-value: 0. 07481 2.1 Show the excel calculations (see notes for an example) whereby the total sum of squares is partitioned into regression and error sums of squares. (8) 2.2 Show the Analysis of Variance (ANOVA) table obtained from the calculations in part (a) and use this table to perform a test for a relationship between x and y . Show your calculations, write down the hypotheses you are testing and state your conclusions. (5) 2.3 Calculate a 95% confidence interval for Bo (2) 2.4 Below is the R output obtained from the Breusch-Pagan and Durbin-Watson tests performed on the residuals of the regression model fitted to the data in question. studentized Breusch-Pagan test BP = 7.7842, df= 1, p-value = 0.00527 Durbin-Watson test lag Autocorrelation D-W Statistic p-value 1 0.424529 1.124016 0.088 2.4.1 For each of these tests, state the hypotheses being tested and the conclusions reached giving reasons. (6) 2.4.2 The graph below shows a plot of the fitted values of the model versus the residual values. What additional information can be obtained from this plot? (2)