Create a scatter plot of the data and apply a linear model


Assignment

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

Solution Preview :

Prepared by a verified Expert
Algebra: Create a scatter plot of the data and apply a linear model
Reference No:- TGS02240765

Now Priced at $50 (50% Discount)

Recommended (93%)

Rated (4.5/5)