Graph each set of data using the xy chart feature in Excel. Add the chart name,
ID: 3219148 • Letter: G
Question
Graph each set of data using the xy chart feature in Excel. Add the chart name, Axes descriptions, r squared, and the linear equation to your chart.
Highest Grossing movies and the year they were released.
$2,386.80
1997
$2,068.20
2015
$1,670.40
2015
$1,519.60
2012
$1,516.00
2015
$1,405.40
2015
$1,341.50
2011
$1,276.50
2013
$1,255.40
2013
$1,159.40
2015
$1,151.10
2016
$1,123.80
2011
$1,119.90
2003
$1,118.60
2012
$1,104.10
2014
$1,084.90
2012
$1,076.20
2006
$1,063.20
2010
$1,045.70
2011
$1,029.20
1993
$1,027.00
1999
$1,024.50
2010
$1,022.60
2016
$1,021.10
2012
$1,004.60
2008
$974.80
2001
$970.80
2013
$968.50
1994
$963.40
2007
$960.30
2010
$958.40
2013
$956.00
2014
$949.90
2007
$937.90
2016
$936.70
2003
$934.40
2009
$926.00
2002
$919.80
2004
$896.90
2005
$890.90
2007
$886.70
2009
$880.70
2015
$879.00
2002
$877.20
2012
$872.70
2016
$871.50
2001
$865.00
2013
$857.40
2015
$848.80
2005
$836.30
2009
$829.70
2012
$825.50
2010
$821.70
2002
$817.40
1996
$799.00
2007
$796.70
2004
$792.90
1982
$788.70
2013
$786.60
2008
$783.80
2004
$782.40
2016
$775.40
1977
$773.30
2014
$769.70
2009
$758.50
2014
$758.20
2006
$757.90
2012
$755.40
2014
$752.60
2010
$747.90
2014
$746.90
2012
$745.00
2005
$743.60
2013
$742.10
2003
$731.30
2009
$727.60
2016
$723.20
2013
$714.40
2014
$712.20
2011
$710.60
2014
$709.70
2009
$709.70
2007
$709.00
2014
$698.50
2010
$694.70
2011
$694.40
2012
$682.30
2015
$677.90
1994
$675.10
2014
$672.80
1999
$668.00
2013
$665.70
2011
$660.90
2006
$657.80
2014
$654.30
2003
$653.40
2015
$649.40
2002
$644.60
2013
$631.70
2008
Hours studied and test grade
3
75
5
90
2
75
6
80
7
90
1
50
2
65
7
85
1
40
7
100
2
70
6
85
7
85
1
70
5
80
5
85
5
80
3
50
3
60
9
95
5
75
6
80
2
50
5
65
2
40
3
70
8
80
4
75
5
60
6
95
Humidity level and time spent outside
50%
6
40%
7
70%
0.5
20%
4.5
90%
0.25
30%
4
70%
5.5
30%
2
20%
2
30%
2.75
40%
2.75
10%
8.5
90%
1
70%
2.2
80%
1.5
50%
3
70%
1.25
40%
4
30%
3.75
20%
6
20%
5
70%
2.5
70%
2
80%
1
50%
4
$2,386.80
1997
$2,068.20
2015
$1,670.40
2015
$1,519.60
2012
$1,516.00
2015
$1,405.40
2015
$1,341.50
2011
$1,276.50
2013
$1,255.40
2013
$1,159.40
2015
$1,151.10
2016
$1,123.80
2011
$1,119.90
2003
$1,118.60
2012
$1,104.10
2014
$1,084.90
2012
$1,076.20
2006
$1,063.20
2010
$1,045.70
2011
$1,029.20
1993
$1,027.00
1999
$1,024.50
2010
$1,022.60
2016
$1,021.10
2012
$1,004.60
2008
$974.80
2001
$970.80
2013
$968.50
1994
$963.40
2007
$960.30
2010
$958.40
2013
$956.00
2014
$949.90
2007
$937.90
2016
$936.70
2003
$934.40
2009
$926.00
2002
$919.80
2004
$896.90
2005
$890.90
2007
$886.70
2009
$880.70
2015
$879.00
2002
$877.20
2012
$872.70
2016
$871.50
2001
$865.00
2013
$857.40
2015
$848.80
2005
$836.30
2009
$829.70
2012
$825.50
2010
$821.70
2002
$817.40
1996
$799.00
2007
$796.70
2004
$792.90
1982
$788.70
2013
$786.60
2008
$783.80
2004
$782.40
2016
$775.40
1977
$773.30
2014
$769.70
2009
$758.50
2014
$758.20
2006
$757.90
2012
$755.40
2014
$752.60
2010
$747.90
2014
$746.90
2012
$745.00
2005
$743.60
2013
$742.10
2003
$731.30
2009
$727.60
2016
$723.20
2013
$714.40
2014
$712.20
2011
$710.60
2014
$709.70
2009
$709.70
2007
$709.00
2014
$698.50
2010
$694.70
2011
$694.40
2012
$682.30
2015
$677.90
1994
$675.10
2014
$672.80
1999
$668.00
2013
$665.70
2011
$660.90
2006
$657.80
2014
$654.30
2003
$653.40
2015
$649.40
2002
$644.60
2013
$631.70
2008
Explanation / Answer
SUMMARY OUTPUT Regression Statistics Multiple R 0.051095 R Square 0.002611 Adjusted R Square -0.00767 Standard Error 282.5036 Observations 99 ANOVA df SS MS F Significance F Regression 1 20263.33 20263.33 0.2539 0.615485 Residual 97 7741402 79808.27 Total 98 7761665 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0% Intercept -3229.98 8218.695 -0.393 0.695179 -19541.8 13081.85 -19541.8 13081.85 Year 2.061671 4.091551 0.503885 0.615485 -6.05893 10.18227 -6.05893 10.18227 SUMMARY OUTPUT Regression Statistics Multiple R 0.774686 R Square 0.600139 Adjusted R Square 0.585858 Standard Error 10.25678 Observations 30 ANOVA df SS MS F Significance F Regression 1 4421.023 4421.023 42.02432 5.05E-07 Residual 28 2945.643 105.2015 Total 29 7366.667 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0% Intercept 48.88443 4.210772 11.60938 3.24E-12 40.25906 57.5098 40.25906 57.5098 Hrs 5.51479 0.850704 6.482617 5.05E-07 3.772201 7.257379 3.772201 7.257379 SUMMARY OUTPUT Regression Statistics Multiple R 0.648846 R Square 0.421001 Adjusted R Square 0.395827 Standard Error 0.191029 Observations 25 ANOVA df SS MS F Significance F Regression 1 0.610283 0.610283 16.72371 0.00045 Residual 23 0.839317 0.036492 Total 24 1.4496 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0% Intercept 0.744359 0.071749 10.37442 3.8E-10 0.595934 0.892784 0.595934 0.892784 Time -0.07485 0.018304 -4.08946 0.00045 -0.11272 -0.03699 -0.11272 -0.03699
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.