Question

1. (10 pts.) Consider investing $100 at various interest rates compounded annually. (a) Complete the following table for the amount A in the account after 10 years. The values of A should be computed via an Excel formula. \begin{tabular}{c|c} $r$ & $A$ \\ \hline 0.01 & \\ 0.015 & \\ 0.02 & \\ 0.025 & \\ 0.03 & \\ 0.035 & \\ 0.04 & \\ 0.045 & \\ 0.05 & \\ 0.055 & \\ 0.06 & \\ \end{tabular} (b) Create a scatter plot of the above data. (c) Include in the plot the Least Squares Regression Line and the value of $R^2$. (d) Use the regression line (creating a formula in Excel) to estimate the value of A when $r$ is 3%. (e) Evaluate (in Excel) the difference between the estimate and the original (exact) value.

          1. (10 pts.) Consider investing $100 at various interest rates compounded annually.
(a) Complete the following table for the amount A in the account after 10 years. The
values of A should be computed via an Excel formula.
\begin{tabular}{c|c}
$r$ & $A$ \\ \hline
0.01 & \\
0.015 & \\
0.02 & \\
0.025 & \\
0.03 & \\
0.035 & \\
0.04 & \\
0.045 & \\
0.05 & \\
0.055 & \\
0.06 & \\
\end{tabular}
(b) Create a scatter plot of the above data.
(c) Include in the plot the Least Squares Regression Line and the value of $R^2$.
(d) Use the regression line (creating a formula in Excel) to estimate the value of A when
$r$ is 3%.
(e) Evaluate (in Excel) the difference between the estimate and the original (exact) value.

1. (10 pts.) Consider investing 100 at various interest rates compounded annually.
(a) Complete the following table for the amount A in the account after 10 years. The
values of A should be computed via an Excel formula.
r A

0.01

0.015

0.02

0.025

0.03

0.035

0.04

0.045

0.05

0.055

0.06

(b) Create a scatter plot of the above data.
(c) Include in the plot the Least Squares Regression Line and the value ofR^2.
(d) Use the regression line (creating a formula in Excel) to estimate the value of A whenris 3%.
(e) Evaluate (in Excel) the difference between the estimate and the original (exact) value.

Added by Chelsea T.

Question

Please give Ace some feedback