Super Bowl Ad Revenue The table shows Super Bowl TV ad revenues \(R\) (in
millions of dollars) for several years from 1987 to 2006. (Source: TNS Media
Intelligence)$$
\begin{array}{|c|c|}
\hline \text { Year } & \text { Revenue } \\
\hline 1987 & 31.5 \\
\hline 1992 & 48.2 \\
\hline 1997 & 72.2 \\
\hline 2002 & 134.2 \\
\hline 2006 & 162.5 \\
\hline
\end{array}
$$(a) Use a spreadsheet software program to create a scatter plot of the data.
Let \(t\) represent the year, with \(t=7\) corresponding to 1987 .
(b) Use the regression feature of a spreadsheet software program to find an
exponential model for the data. Use the Inverse Property \(b=e^{\ln b}\) to
rewrite the model as an exponential model in base \(e\).
(c) Use a spreadsheet software program to graph the exponential model in base
\(e\).
(d) Use the exponential model in base \(e\) to predict the Super Bowl ad
revenues in 2009 and in 2010 .