Parts A, C, and D. Can you put them all on one excel graph please. It should be one figure with three lines. **Problem 2. [SW 14.9]**You have a sample of size \( n = 1 \) with data \( y_1 = 2 \) and \( x_1 = 1 \). You are interested in the value of \( \beta \) in the regression \( Y = X\beta + u \). (Note there is no intercept.)(a) Plot the sum of squared residuals \((y_1 - bx_1)^2\) as a function of \( b \). You can choose your own range for \( b \); one reasonable choice is \( b \in [-2, 5] \). *(Use any software you prefer. Excel is one option.)*(b) Show that the least squares estimate of \( \beta \) is \( \hat{\beta}^{OLS} = 2 \).(c) Using \( \lambda_{Ridge} = 1 \), plot the Ridge penalty term \(\lambda_{Ridge}b^2\) as a function of \( b \).(d) Using \( \lambda_{Ridge} = 1 \), plot the Ridge penalized sum of squared residuals \((y_1 - bx_1)^2 + \lambda_{Ridge}b^2\). Please put all three lines in one plot.

Given Information:The SSE is given as: Consider the given information in which it is mentioned that b∈[−2,5]. Thus, we have: b SSE=2-b2 -2 16 -1 9 0 4 1 1 2 0 3 1 4 4 5 9 The step-by-step procedure to plot the sum of square residuals using the excel function is given by: Enter the data into excel. go to the tab Insert> recommended chart > All chart > X-Y scatter > Scatter with smooth lines. Click ok. c. The ridge penalty term is given as λRidgeb2 where, λRidge=1 b Ridge penalty -2 4 -1 1 0 0 1 1 2 4 3 9 4 16 5 25 The step-by-step procedure to plot the sum of square residuals using the excel function is given by: Enter the data into excel. go to the tab Insert> recommended chart > All chart > X-Y scatter > Scatter with smooth lines. Click ok. d. The ridge penalty term is given as y1-bx12+λRidgeb2 where, λRidge=1 b Ridge penalized sum of squared residuals -2 20 -1 10 0 4 1 2 2 4 3 10 4 20 5 34 Now the data we have: b SSE Ridge penalty Ridge penalized sum of squared residuals -2 16 4 20 -1 9 1 10 0 4 0 4 1 1 1 2 2 0 4 4 3 1 9 10 4 4 16 20 5 9 25 34 The step-by-step procedure to plot the sum of square residuals using the excel function is given by: Enter the data into excel. go to the tab Insert> recommended chart > All chart > X-Y scatter > Scatter with smooth lines. Click ok.