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:

1. Does the trendline fit the data? How can you tell?
2. What trends do you see in your data?
3. 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.