Answer questions about your updated spreadsheet.

$$\begin{array}{|r|l|c|c|} \hline & {\text { A }} & \text { B } & \text { C } \\ \hline 1 & {\text { Rent or Buy Template }} \\ \hline 2 & {} \\ \hline 3 & \text { Description } & \text { Amount } & \\ \hline 4 & & & \\ \hline 5 & \text { Rent per year } & 0.00 & \\ \hline 6 & \text { Rent per week } & 75.00 & \\ \hline 7 & \text { Rent per day } & 25.00 & \\ \hline 8 & \text { Rent per hour } & 6.00 & \\ \hline 9 & \text { Cost of item } & 349.99 & \\ \hline 10 & {} \\ \hline 11 & \text { Rent per year equals or exceeds cost in: } & 0.00 & \text { Years } \\ \hline 12 & \text { Rent per week equals or exceeds cost in: } & 4.67 & \text { Weeks } \\ \hline 13 & \text { Rent per day equals or exceeds cost in: } & 14.00 & \text { Days } \\ \hline 14 & \text { Rent per hour equals or exceeds cost in: } & 58.33 & \text { Hours } \\ \hline \end{array}$$

What does " $=\operatorname{IF}(\mathrm{B} 6>0$ " mean in the formula found in cell B12?

Fill in the blank with the word or words that best completes the statement.

When ___, people should take care to protect their computers from unauthorized access.

(a) decide whether the problem relates to an ordinary annuity or an annuity due and then (b) solve the problem.

A $\$ 2.4$ million state lottery pays $\$ 10,000$ at the beginning of each month for $20$ years. How much money must the state actually have on hand to set up the payments for this prize if money is worth $6.3 \%$ compounded monthly?

Multiply 4.017 by 1,000 .

$$\begin{array}{|c|c|c|} \hline & \begin{array}{c} \text { Average Salary } \\ \text { Increase } \end{array} & \begin{array}{c} \text { Consumer } \\ \text { Price Index } \end{array} \\ \hline 1993 & 4.6 \% & 3.0 \% \\ \hline 1994 & 4.2 \% & 2.5 \% \\ \hline 1995 & 4.2 \% & 2.8 \% \\ \hline 1996 & 4.1 \% & 2.9 \% \\ \hline 1997 & 4.1 \% & 2.3 \% \\ \hline 1998 & 4.1 \% & 1.6 \% \\ \hline 1999 & 3.4 \% & 2.2 \% \\ \hline 2000 & 4.1 \% & 3.4 \% \\ \hline 2001 & 3.8 \% & 2.8 \% \\ \hline 2002 & 3.3 \% & 1.6 \% \\ \hline 2003 & 2.9 \% & 2.3 \% \\ \hline \end{array}$$

What year had the greatest difference between the percent of the average salary increase and percent of the Consumer Price Index?

Find the present value of an annuity due that pays $\$ 25,000$ every $6$ months for the next $2 \frac{1}{2}$ years if money is worth $6.2 \%$ compounded semiannually.

(a) decide whether the problem relates to an ordinary annuity or an annuity due and then (b) solve the problem.

A local library receives a bequest of $\$ 100,000$ from a prominent local family. How much will this provide at the beginning of each $3$-month period for the next $2 \frac{1}{2}$ years if money is worth $7.4 \%$ compounded quarterly?

Find the mean, median, mode, and range.

Data set: 2,184; 8,105; 19,238; 9,053

Find the mean, median, mode, and range.

Data set: 16, 25, 19, 29, 18, 25

(a) decide whether the problem relates to an ordinary annuity or an annuity due and then (b) solve the problem.

A college class's $25$th reunion gift is $\$ 8.6$ million. How many semiannual payments of $\$ 250,000$ will this provide at the beginning of each $6$-month period if money is worth $4.4 \%$ compounded semiannually?

(a) decide whether the problem relates to an ordinary annuity or an annuity due and then (b) solve the problem.

Is it more economical to buy an automobile for $\$ 29,000$ cash or to pay $\$ 8000$ down and $\$ 3000$ at the end of each quarter for $2$ years, if money is worth $8 \%$ compounded quarterly?

(a) decide whether the problem relates to an ordinary annuity or an annuity due and then (b) solve the problem.

Dr. Jane Kodiak plans to sell her practice to an HMO. The HMO will pay her $\$ 1.5$ million now or will make a $\$ 500,000$ partial payment now and additional payments of $\$ 140,000$ at the end of each year for the next $10$ years. If money is worth $6.5 \%$ compounded annually, is it better to take $\$ 1.5$ million now or $\$ 500,000$ now and $\$ 140,000$ at the end of each year for the next $10$ years? Justify your choice.

Multiply 45.076 by 100.

$$\begin{array}{|c|c|c|} \hline & \begin{array}{c} \text { Average Salary } \\ \text { Increase } \end{array} & \begin{array}{c} \text { Consumer } \\ \text { Price Index } \end{array} \\ \hline 1993 & 4.6 \% & 3.0 \% \\ \hline 1994 & 4.2 \% & 2.5 \% \\ \hline 1995 & 4.2 \% & 2.8 \% \\ \hline 1996 & 4.1 \% & 2.9 \% \\ \hline 1997 & 4.1 \% & 2.3 \% \\ \hline 1998 & 4.1 \% & 1.6 \% \\ \hline 1999 & 3.4 \% & 2.2 \% \\ \hline 2000 & 4.1 \% & 3.4 \% \\ \hline 2001 & 3.8 \% & 2.8 \% \\ \hline 2002 & 3.3 \% & 1.6 \% \\ \hline 2003 & 2.9 \% & 2.3 \% \\ \hline \end{array}$$

Does the trend for the Consumer Price Index percents during those years also remain about the same?