Bonuses updated data below all need on Excel working with excel formula

Year	Bonus($000)
2000	100.5
2001	74.1
2002	60.9
2003	99.9
2004	113.5
2005	149.8
2006	191.4
2007	177.8
2008	100.9
2009	140.6
2010	139.0
2011	111.4
2012	142.9
2013	169.8
2014	160.3
2015	136.8
2016	156.8
2017	184.4
2018	153.7

a. Fit a third-order autoregressive model to the average baseball salary and test for the significance of the third-order autoregressive parameter (use = 0.05).

b. Fit a second-order autoregressive model to the average baseball salary and test for the significance of the second-order autoregressive parameter (use = 0.05).

c. Fit a first-order autoregressive model to the average baseball salary and test for the significance of the first-order autoregressive parameter (use = 0.05).

d. Using the most appropriate model, forecast the average baseball salary for 2020.

e. Plot your actual and predicted bonuses (on the same graph) using your model selected in part d above. This requires that you have the predicted bonuses for each year (starting in 2010) using your selected model in part d.