Season Payroll Runs Wins 2000 16.5 748 69 2001 23.8 771 85 2002 39.9 768 94 2003
ID: 3046941 • Letter: S
Question
Season
Payroll
Runs
Wins
2000
16.5
748
69
2001
23.8
771
85
2002
39.9
768
94
2003
55.3
801
90
2004
53.8
780
92
2005
56.6
688
93
2006
65
801
96
2007
72.2
718
79
2008
61.4
829
88
2009
67
817
87
2010
98.2
851
94
2011
113.2
619
63
2012
100.4
701
66
2013
82
614
66
2014
92.9
705
70
2015
108.3
696
83
2016
105.3
722
59
2017
108.1
815
85
Stats Lab
Let’s look at a few regressions to see if we can figure out why the Twins are lousy.
1) Scatterplots
We need to create some scatterplots and add the regression lines to them.
1) Highlight the two columns of data that you want to plot together
(the one on the left defaults to x and the right is y)
2) Choose “Insert” and “Recommended Charts” and “Scatterplot”
3) Click on any data point on the chart and choose
“add trendline” from the right-click menu
4) Choose Linear
Put the requested Plots below
Questions:
Do these scatterplots look like a good fit for the data? Explain
Which do you think does a better job? Why?
2) Running Regressions
Choose: Data->Data Analysis -> Regression
Runs vs Wins(with constant) Runs vs Wins (Without Constant)
Model: Model:
Rsq: Rsq:
Payroll vs Wins (With Constant) Payroll vs Wins (Without Constant)
Model: Model:
Rsquer: Rsquer:
Questions
Which appears to be the best model for predicting Wins? Explain
What does the Payroll vs Runs tell you? Explain
Season
Payroll
Runs
Wins
2000
16.5
748
69
2001
23.8
771
85
2002
39.9
768
94
2003
55.3
801
90
2004
53.8
780
92
2005
56.6
688
93
2006
65
801
96
2007
72.2
718
79
2008
61.4
829
88
2009
67
817
87
2010
98.2
851
94
2011
113.2
619
63
2012
100.4
701
66
2013
82
614
66
2014
92.9
705
70
2015
108.3
696
83
2016
105.3
722
59
2017
108.1
815
85
Explanation / Answer
Solution :
Scatter plots :
Payroll Vs wins
Runs Vs wins
From above two scatter plot , we can observe that, the second sctter plot (Runs VS wins) is good fit for data , as all points are close to the best fitted line and also it shows increasing pattern,so they are positively correlated.
From the runs VS wins scatter plot ,as runs increases number of wins increases,so here making more runs turns into winnings.
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.