In: Statistics and Probability
Answer the following questions using the data given below. Moviegoer Spending on Snacks (n = 10) Age (X) ($) Spent (Y) 30 6.85 50 10.50 34 5.50 12 10.35 37 10.20 33 10.75 36 7.60 26 10.10 18 12.35 46 8.35 Use Excel to make a scatter plot of the data. 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. Picture Click here for the Excel Data File (a) Choose the right option. An increase in age leads to an average increase in spending. An increase in age leads to an average decrease in spending. (b) Choose the correct statement. The intercept is meaningful because one could spend money on snacks even if very young. The intercept is not meaningful in this case because age wouldn’t be zero. (c) Calculate R2. (Round your answer to 4 decimal places.) R2 (d) The percentage of variation in spending that is explained by a moviegoer’s age is %. (Round your answer to 2 decimal places.) (e) Age of the consumer has a great impact on the amount spent. Yes No