The "SBUX" worksheet in the data pack represents revenue (measured in billions of dollars) generated by Starbucks from Q1-2015 to Q4-2020. Note: the first quarter for Starbucks' fiscal year is from early October to late December.

a.Plot the time series using a line graph. (2 marks)

[insert your line graph here]

b.Construct the quarterly seasonal indexes. (6 marks)

[insert your table of organized calculations here]

c.Interpret the quarterly seasonal indexes. (2 marks)

[insert your interpretation for each seasonal index here]

d.Seasonally adjust the time series and estimate a linear trend equation. Use the seasonally adjusted time series as the dependent variable. (5 marks)

[insert a screenshot of the Excel regression output here]

[insert the formula for the regression equation here]

e.Forecast Starbucks' revenue for each quarter in 2021. (5 marks)

[insert your table of organized calculations here]

\f