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

MTH 220 Entire Course Link
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.

Powered by