Question: PLEASE SEND BACK TO ME IN EXCEL !!!! Graph each set of data using the XY chart feature in Excel. Add the chart name, Axes
PLEASE SEND BACK TO ME IN EXCEL !!!!
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. Interpret the chart.
Highest Grossing movies and the year they were released.
| $2,186.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,215.40 | 2013 |
| $1,159.40 | 2015 |
| $1,151.10 | 2016 |
| $1,123.80 | 2011 |
| $1,119.90 | 2003 |
| $1,108.60 | 2012 |
| $1,104.10 | 2014 |
| $1,084.90 | 2012 |
| $1,066.20 | 2006 |
| $1,063.20 | 2010 |
| $1,045.70 | 2011 |
| $1,029.20 | 1993 |
| $1,027.00 | 1999 |
| $1,025.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 |
| $939.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 |
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
