[SOLVED] Mathematical Modeling Excel Project

I need an explanation for this Excel question to help me study.

Please save file as “Excel 3 – Last Name, First Name”. Make sure to follow the template provided on Sakai.

Be sure to show all ”scratch work” as I discussed in class.

1. Enter the following data and create a scatter plot. The following table shows the annual changes in

consumer price index (CPI) for 1990-2000.

Years Since 1990 0 1 2 3 4 5 6 7 8 9 10

CPI Annual Change (%) 5.4 4.2 3.0 3.0 2.6 2.8 3.0 2.3 1.6 2.2 3.4

(a) Describe the shape of the data.

(b) Find a quartic regression for CPI annual change as a function of years since 1990.

(c) Predict the CPI in 2020. Interpret your answer in a complete sentence.

(d) Predict the time when the CPI will be 5%. Interpret your answer in a complete sentence. (Hint:

There is more than one answer.)

2. Enter the following data and create a scatter plot. The following table shows the Systolic Blood

Pressure (SBP) in terms of age in years.

SBP 132 143 153 162 154 168 137 149 159 128 166

Age (years) 52 59 67 73 64 74 54 61 65 46 72

(a) Describe the shape of the data.

(b) Find the cubic regression of the age in years as a function of systolic blood pressure. Round to

5 decimal places.

(c) Create a new row to show predictions for age in years from the regression model.

(d) Predict the age in years for a patient with systolic blood pressure of 150. Interpret your answer

in a complete sentence.

(e) Predict the systolic blood pressure for a patient of age 25. Interpret your answer in a complete

sentence.

3. The Highway Patrol measure skid marks at automobile accidents to predict speed. The following

table shows length of the skid mark made based on the speed of the car. Enter the following data and

create a scatter plot.

Skid mark (feet) 10 20 40 50 60 70 80

Speed (mph) 17.5 24.6 35.1 39.0 42.7 46.4 49.7

(a) Describe the shape of the data.

(b) Find the power regression of speed as a function of length of skid mark.

(c) Create a new row to show predictions for speed from the regression model.

(d) Predict the speed for a skid mark of 120 feet. Interpret your answer as a complete sentence.

(e) Predict the length of a skid mark for a car traveling 100 mph. Interpret your answer in a

complete sentence