Can you creat Visuals from Data? Math/215

woclcwide92

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.

Hints for Making an Effective Chart:

  • Decide why you are making a chart from this data.
  • Rename the chart title to something appropriate for the data.
  • Put in a descriptive x-axis label.
  • Put in a descriptive y-axis label.
  • Resize the chart as needed so it is easily viewable.

Submit your visuals in either an Excel® file or a Word document

    • 9 years ago
    • 20
    Answer(1)

    Purchase the answer to view it

    • assignment.xlsx