Visuals from data

Using data from the topic selected

Watch Week 4 Lynda.com® Video: Adding Trendlines to Charts.

Create at least two visuals using your data. 

  • Create a scatter plot of the data, and apply a linear model (also known as a regression) in Excel®.
  • Create a scatter plot of the data, and apply an exponential model in Excel®.
  • Include the equation and R2 value on the visuals.
  • 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.

I will email the spreadsheet with topic info after agreement.