5. The dataset shows US Gross Domestic Product (in billions of dollars) and Domestic Revenue Passenger Miles (in billions) for the years 2000 through 2015.Below this table is the MS Excel Summary Output regressing RPMs against RGDP.Using MS Excel or another similar application, build a scatter plot and insert the regression line and equation.Copy and paste the chart below.Next, interpret the regression output and explain the regression statistics.Be certain that the regression coefficients match those in the scatter plot equation.Finally, use the regression equation to predict RPMs for 2020 and 2021 assuming GDP falls by 5% in 2020 and then grows by 4% in 2021 each year from 2015. Instructions for building the scatter plot are at the end of the problem set.

Year RGDP RPM

2005 14771 779

2006 15267 797

2007 15493 829

2008 15671 812

2009 15155 769

2010 15415 798

2011 15712 814

2012 16129 823

2013 16382 840

2014 16616 862

2015 17277 902

2016 17556 933

2017 17925 964

2018 18438 1011

2019 18927 1055