Forecasting Store Revenue. Annual retail store revenue for Apple from 2007 to 2017 are shown below (source: 9!". arketer-wm). Year Period Retail Store Revenue ($ billions) 2007 1 $4.115 2008 2 $6.310 2009 3 $6.57? 2010 4 $9.080 2011 5 $14.12? 2012 6 $18828 2013 7 $20228 2014 8 3521.462 2015 9 $28.109 2016 10 $21198 2017 11 $30503 *\"Data has been transferred in the data le Excel File AgpleRetailxlsx i, (also posted under week 11 module). By Thursday, Nov. 10 (11:55pm PST), answer the following 3 questions A-C and attach a word doc or excel le to show your work. a. Construct a lime series plot. What type of pattern exists in the data? b. Using Excel, develop a linear trend equation tor this time series. c. Use the trend equation developed in part (b) to forecast retail store revenue for 2015