The table shows the total annual sales of U.S. gasoline in millions of dollars from 2010 to 2021. (On the site https://www.census.gov/retail/index.html#mrts, find “Monthly Retail Trade Report,” then select “Time Series/Trend Charts” to find the data for total U.S. sales of gasoline.)

a. Graph the data.b. Based on the graph, describe the time series pattern.c. For this time series, why is forecasting with a trend model appropriate?d. Evaluate a trend forecasting model using simple linear regression. What are the MAD and MAPE?e. What is the predicted annual change of industry sales?f. Using the trend model, forecast the next 3 years of gasoline sales.

Transcribed Image Text:

Year Annual Sales Year Annual Sales 2010 $335,528 2016 2011 380,405 2017 2012 408,833 2018 2013 401,500 2019 2014 2015 390,098 312,808 2020 2021 $280,241 372,429 521,453 512,377 430,116 588,140