Develop a spreadsheet for computing the demand for any values of the input variables in the linear demand and nonlinear demand prediction models in Examples $1\mathrm{.}7$ and $1\mathrm{.}8$ in the chapter.

The Excel file Science and Engineering Jobs shows the number of jobs in thousands in the year $2000$ and projections made for $2010$ from a government study. Use the Excel file to compute the projected increase $.$ from the $2000$ baseline and the percentage increase for each occupational category.

A new graduate has taken a job with an annual salary of $$60,000.$ She expects her salary to go up by $2\mathrm{.}5\%$ each year for the first five years. Her starting salary is stored in cell A$4$ of an Excel worksheet, and the salary increase rate is stored in cell B$4.$ Construct a table with years $1$ through $5$ in cells $A6$:$A10$ and her salary in cells $B6$:$B10.$ Write the formula for her salary in year $2($in cell $B7)$ that can be copied and pasted correctly in cells B$8$ through B$10.$