Waiting for answer This question has not been answered yet. You can hire a professional tutor to get the answer.
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.
