creating visuals from data 3

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.

 

Do you need a similar assignment done for you from scratch? We have qualified writers to help you. We assure you an A+ quality paper that is free from plagiarism. Order now for an Amazing Discount!
Use Discount Code "Newclient" for a 15% Discount!

NB: We do not resell papers. Upon ordering, we do an original paper exclusively for you.