Waiting for answer This question has not been answered yet. You can hire a professional tutor to get the answer.

# for miss professor only

The purpose of the Signature Assignment is to have you work with real-life data to answer a real-life question using the tools, technology, and skills of MTH/219. In Week 3, you will determine the type of polynomial your data is best represented. You will use that polynomial to make a prediction about your data.

**Review** the instructional video on how to use regression in Microsoft® Excel® (if you have forgotten from Week 2).

**Input** your data into Microsoft® Excel® (data and years).

**Create** a scatterplot.

**Insert** a polynomial trendline with degree of 4. Make sure to show the equation and the R-square value. Also make sure you label each axis and give a title to your graph. Then repeat this process for a 5th degree polynomial.

**Answer** the following questions in the same Microsoft® Excel® worksheet. Each question should be 175 to 260 words.

- Which of the polynomials fit the data better? How can you tell?
- Compare and contrast the polynomial regression with the linear regression from Week 2. What is the best model for your data so far?
- What happens to your polynomial models over time? In other words, what do you expect to happen to the value if you measure it 50 years from now?

**Save** your Microsoft® Excel® file, including the graphic and your commentary.