Review of the linear trend model. Use the "loans" data attached to determine whether the linear trend model can be used to assess monthly loan requests. In your answer, please do the following:
a. Create a scatter diagram with monthly loan requests on the vertical axis and time on the horizontal axis. Does a linear trend model seem appropriate?
b. Regress the dependent variable, monthly loan requests, on the independent variable, time. Share your regression output.
c. Interpret your regression out. Emphasize whether the intercept coefficient, the slope coefficient, and the model is statistically significant. How do you know? Finally, what is the coefficient of determination? How can it be solved for manually used the output provided? How about the mean squared error?