Using the UNH Quarterly Sales data (UnitedHealth Group):

a. Create a line chart of sales. Do you see a trend?

b. Do you see any seasonality? If so, what is the frequency and what quarter typically has the highest sales?

c. Create a forecast for UnitedHealth Group’s sales for June 2019 using the SES model.

d. Create a forecast for UnitedHealth Group’s sales for June 2019 using the LES model.

e. Which of the two models fits the data better based on MSE?

Transcribed Image Text:

A1 B 1 Date Sales 2 Sep-11 25,284 3 Dec-11 25,918 4 Mar-12 27,285 Jun-12 27,266 5 Sep-12 27,302 28,771 6 7 Dec-12 8 Mar-13 30,343 9 30,409 Jun-13 10 Sep-13 30,627 11 Dec-13 31,118 12 Mar-14 31,711 13 Jun-14 32,578 14 Sep-14 32,777 15 Dec-14 33,434 16 Mar-15 35,757 Jun-15 36,266 17 18 Sep-15 41,493 19 Dec-15 43,613 20 Mar-16 44,548 21 Jun-16 46,486 22 Sep-16 46,314 23 Dec-16 47,525 24 25 26 Sep-17 50,322 27 Dec-17 52,070 28 Mar-18 55,188 29 Jun-18 56,086 Sep-18 56,556 30 31 Dec-18 58,417 32 Mar-19 60,308 Mar-17 48,723 Jun-17 50,053 ✓ fx C Date D E F G H I J AMZN Quarterly Revenue AMZN Annual Revenue TGT Quarterly Sales K L M UNH Quarterly Revenue