Given the following data set:

$\backslash$table$[[$Period $($X$).,1,2,3,4,5,6,7,8,9,10,11,12,13,14],[$New Accounts $($Y$),208,215,210,230,237,232,248,250,253,267,280,275,292,308]]$

a$.$ Obtain the linear trend equation $($first$,$ plot the data and the regression line on the same graph, or alternatively use Data Analysis tool to obtain the $"$a$"$ and the $"$b$"$ values of the equation$)$ for the following data on new checking accounts for Fair Savings Bank and use it to predict expected new checking accounts for periods $15$ through $20.$ Enter the data on Excel using Period $(x)$ as Column $1$ and New Accounts $(Y)$ in the second column.

b$.$ Determine the correlation coefficient and interpret it$.$

c$.$ What percentage of variation in new accounts is explained by the independent variable $($time$)?$