(a) Use Excel to make a scatter plot of the data. (b) Select the
data points, right-click, select Add Trendline, select the Options tab, and choose Display equation on chart
and Display R-squared value on chart. (c) Interpret the fitted slope. (d) Is the intercept meaningful? Explain.
(e) Interpret the R2.
Moviegoer Spending ($) on Snacks Movies
Age (X) Spent (Y)
Please see the attachment for solution. Thank you.
c) The fitted regression equation is y = -0.053x + 6.9609.
The fitted slope (coefficient of x) indicates the average change in the y value for a unit increase in the x value. Here the fitted slope is -0.053. Since the slope is ...
The solution contains the fitting of a trendline using regression analysis and its interpretation.