Data below all need in Excel work ,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

There has been much publicity about bonuses paid to workers on Wall Street. Just how large are these bonuses? The file Bonuses-Updated contains the bonuses paid (in $000) from 2010 to 2018. Hint: Use Coded Year as your independent variable (X), where X is relative to 2000. So, 2000 = 0, 2001 = 1, ... , 2010 = 10, 2018 = 18, etc

a. Plot the data.

b. Compute a linear trend forecasting equation and plot the results.

c. Compute a quadratic trend forecasting equation and plot the results.

d. Compute an exponential trend forecasting equation using base 10 logs and plot the results.

e. Using the forecasting equations in b through d, what are your annual forecasts of the bonuses for 2019 and 2020? You should have a total of six forecasts here.

f. Which of the models above do you think you should use? Why?

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