Create at least two visuals using your data from the data you chose in Week 2.

1 Create one scatter plot of the data, and apply a linear model (also known as a regression) in Excel®. Include the equation, R2 value, and prediction value on the visual.

2 Create one scatter plot of the data, and apply an exponential model in Excel®. Include the equation, R2 value, and prediction value on the visual.

3 Determine whether the linear or the exponential model is a better representation of your data to base your prediction on. Explain why the model you chose is a better representation of your data.

Here are the guidelines for answering the questions so that I get full credit:

If you are not sure what should be described to demonstrate a sound ability for this assignment, keep reading the material below. The items that are needed to be explained in words are:

What do you see in the graphs? Growth? Decay? Or data is stagnant (no visible growth or decay). Provide detail explanation. The explanations can be typed in the Excel under each graph.

Determine whether the linear or the exponential model is a better representation of your data to make your prediction. Explain why the model you chose is a better representation of your data. The explanation can be typed in the Excel sheet.

Predicted value for 2018.Use the equation for the best model in your analysis to calculate the predicted value. You have to plug in 2018 for “x” in the equation and calculate the value of “y”. This would be the predicted value. The explanation can be typed in the Excel sheet.