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.

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.

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.

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

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

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

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

Create a scatter plot.

Create a scatter plot.

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

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?

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

What trends do you see in your data?

What trends do you see in your data?

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

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

Click the Assignment Files tab to submit your assignment.

Click the Assignment Files tab to submit your assignment.