Mathematic assignment on microsoft excel

/in /by

Mathematic assignment on microsoft excel

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, R2value, 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.

Below I encluded a picture of the week 2 title which is required to complete this assignment