2. 3. overlay. Use R. (You may need to research this, such as googling "histogram with normal curve in R.") Provide a measure of the proportion of variation in the response that is accounted for by the explanatory variable. Interpret this measure . Use R. Using the data for Blackeared Wheatears, calculate by "hand" (using Excel) the following elements. (An example of much of this was in the PowerPoints and in the videos below.) a. b. C. Bonus ! :rqarroapo' RNA :0 :0 The tstatistics and pvalues for the hypothesis tests ( '80 and for 61 ). 99% confidence intervals for the mean on when X = {3,4,5,6,7,8,9} grams. You do NOT need to make a Bonferroni (or any other type of) multiple interval correction, as the primary purpose of these intervals is to be able to plot confidence interval bands. 99% prediction intervals for the predicted Y when X = {3,4,5,6,7,8,9} grams. You do NOT need to make a Bonferroni (or any other type of) multiple interval correction, as the primary purpose of these intervals is to be able to plot prediction interval bands. Provide a plot for the confidence intervals and prediction intervals using Excel. Fully label your graph. (Use the regression equation and parts (c) and (d) above to create the plot.) Calibration intervals: i. Using the SE equations given in class and in the book (Version 3 page 194), find the following analytically . (Use Excel for calculations.) a. 99% calibration interval for the mean t-cell response of 0.3. b. 99% calibration interval for a single t-cell response of 0.3. j. Using the Excel graphs, find the following. You may want to add data points to parts (c) and (d) so that the confidence and prediction limits extend well beyond the data range (although their interpretation is questionable outside the range). a. 99% calibration interval for the mean tcell response of 0.3. b. 99% calibration interval for a single tcell response of 0.3. Repeat 1 (a) using SAS. Repeat 1 (b) using SAS. Repeat 1 (c) using SAS. Repeat 1 (g) using SAS. Repeat 1 (h) using SAS. Repeat 1 (j) using SAS . Repeat 1 (k) using SAS. Repeat 1 (I) using SAS