Question

1. Apple’s Worldwide Revenues from 2004 to 2019 is as follows:

Year	Worldwide Revenue in Billions
2004	8.2
2005	13.9
2006	19.3
2007	24.6
2008	37.5
2009	42.9
2010	65.2
2011	108.2
2012	156.5
2013	170.9
2014	182.8
2015	233.72
2016	215.64
2017	229.23
2018	265.6
2019	260.17

1. Enter the data above into the tab labeled Apple. Graph the data in Excel and use your graph to determine what kind of time series pattern exist. Put your answer in your spreadsheet.
2. Make the following forecasts for 2020. For all of them, use Mean Squared Error to determine which of the forecasts is the best. Make sure your answers are clearly labeled.
   1. Naïve forecast from one prior time period
   2. Calculate a 4-period moving average
   3. Calculate a 3-period moving average with the following weights for time t: time period t-1=0.8, t-2 = 0.15, t-3=.05
3. In the tab called Apple Smoothing, use the data from 3. to forecast 2020 using an alpha equal to 0.7, 0.8, and 0.9. Using MSE, which one offers the best estimate for 2020?
4. In the tab called Apple Regression, use the information from 3. and run a regression to determine your forecast for 2020
   1. Put your regression output in F1 of the same workbook.
   2. Calculate what your forecast is for 2020 in F21.
   3. How does well does this regression equation predict revenue? Write your answer in F22. In addition, explain what your numerical answer means in words.

PLEASE PROVIDE STEP BY STEP AND FORMULAS FOR EXCEL, THANK YOU

Answer 1

  Please give upvote.

Thank you.