*************************************************************************************

MTH 220 Week 2 Signature Assignment: Trendline & R-Squared Value

Review the instructional video on how to use regression in Microsoft® Excel®.

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

Create a scatter plot.

Insert a logarithmic trendline. 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.

Open a new Microsoft® Excel® sheet and repeat this process for an exponential trendline (showing the equation and R-square value).

Answer the following questions in 175 words in the same Microsoft® Excel® worksheet as the graph:

Does the trendline fit the data? How can you tell?

What trends do you see in your data?

Do you think your data has a horizontal or vertical asymptote? Why or why not?

Save your Microsoft® Excel® file, including the graphic and your commentary. Make sure you do not delete your files, as you will need them in subsequent weeks. Your assignment will be graded with Week 2 Grading Guide.

Click the Assignment Files tab to submit your assignment.