1. [55] The annual revenue data for Amazon spanning 2005 to 2020 is provided in: Assignment4.xlsx, tab: Q1-annual. Use these data and Minitab to perform the following analyses and to answer the questions.
   1. [3] Make a duplicate copy of the worksheet in Minitab. Delete the final entry for 2020, in the duplicate worksheet. Develop a time-series plot (STAT > Time series > Time series plot or GRAPH > TIME SERIES PLOT).

Edit the x-axis by: double-clicking the graph, in the Edit Graph window, right-click the x-axis and then: (1) under the TIME tab Time Scale > Calendar > Year and for Start Value enter 2005, click OK. Close the edit window. Include your graph here:

b- [2] Using your results from part-a and Minitab, develop a forecasting model. Go to STAT > Time Series > Trend Analysis. Pick the appropriate form of the trend and include the graph output here (one graph only!):

c- [2] Insert a column and use CALC to create a column of values that are a transformation of the Revenue values. (Use your results from the previous parts to ascertain the most appropriate transformation.) Repeat part b using the transformed values. Insert your graph here:

d - [7] Using the estimated forecast equations from parts a and b (these are provided at the top of each graph) and showing hand calculations (that is, state the equation(s) you use and how you obtain the result from that), forecast the next period (i.e. the year 2020 which we had omitted from this data set). Ensure that all results are in Millions USD (as was the original data) and compare these two results with the actual revenues for 2020. Summarize your findings and comment.

e[4] Using the annual data and Minitab, run a regression model using Period as the predictor variable and Revenue as the response. Store the residuals, request a 4-in-one plot of the standardized residuals, and request a Durbin-Watson statistic. Insert your 4-in-one plot, Durbin-Watson statistic output and your test of autocorrelation here (make sure to include a statement of the hypotheses, decision rule, and conclusion):

Period	Year	Revenue (Millions USD)
1	2005	$8,490
2	2006	$10,711
3	2007	$14,835
4	2008	$19,166
5	2009	$24,509
6	2010	$34,204
7	2011	$48,077
8	2012	$61,093
9	2013	$74,452
10	2014	$88,988
11	2015	$1,07,006
12	2016	$1,35,987
13	2017	$1,77,866
14	2018	$2,32,887
15	2019	$2,80,522
16	2020	$3,86,064