Question
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
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.
( C) Calculate R2 ? (Round your answer to 4 decimal places.)
(d) The percentage of variation in spending that is explained by moviegoer's age is ?
(Round your answer to 2 decimal places.)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started