Attached Excel spreadsheeted contains data on the number of new constructions for residential homes, per month, in thousands, from May 2016 to April 2022 in a province in Canada.

a)make a time series graph of the data. Discuss any apparent trend and seasonal patterns. (2 points)

b)Use the multiplicative decomposition forecasting model on these data. Use this model to forecast new constructions for each month of the next year. (20 points)

c)make a graph of the forecasted data versus actual data. (2 point)

d)Compute the MAD of your model. (2 point)

e)Compute and chart the tracking signal. (4 point)

Month	New constructions (thousands)	t
May-2016	29	1
Jun-2016	32	2
Jul-2016	41	3
Aug-2016	44	4
Sep-2016	49	5
Oct-2016	47	6
Nov-2016	46	7
Dec-2016	47	8
Jan-2017	43	9
Feb-2017	45	10
Mar-2017	34	11
Apr-2017	31	12
May-2017	35	13
Jun-2017	43	14
Jul-2017	46	15
Aug-2017	46	16
Sep-2017	43	17
Oct-2017	41	18
Nov-2017	44	19
Dec-2017	47	20
Jan-2018	41	21
Feb-2018	40	22
Mar-2018	32	23
Apr-2018	32	24
May-2018	34	25
Jun-2018	40	26
Jul-2018	43	27
Aug-2018	42	28
Sep-2018	43	29
Oct-2018	44	30
Nov-2018	39	31
Dec-2018	40	32
Jan-2019	33	33
Feb-2019	32	34
Mar-2019	31	35
Apr-2019	28	36
May-2019	34	37
Jun-2019	29	38
Jul-2019	36	39
Aug-2019	42	40
Sep-2019	43	41
Oct-2019	44	42
Nov-2019	44	43
Dec-2019	48	44
Jan-2020	45	45
Feb-2020	44	46
Mar-2020	40	47
Apr-2020	37	48
May-2020	45	49
Jun-2020	49	50
Jul-2020	62	51
Aug-2020	62	52
Sep-2020	58	53
Oct-2020	59	54
Nov-2020	64	55
Dec-2020	62	56
Jan-2021	50	57
Feb-2021	52	58
Mar-2021	50	59
Apr-2021	44	60
May-2021	51	61
Jun-2021	56	62
Jul-2021	60	63
Aug-2021	65	64
Sep-2021	64	65
Oct-2021	63	66
Nov-2021	63	67
Dec-2021	72	68
Jan-2022	61	69
Feb-2022	65	70
Mar-2022	51	71
Apr-2022	47	72