Problem: Using data below answer questions:
a) Construct time series plot. What pattern exists?
b) Use Excel Solver to make quadratic trend equation to forecast team value.
c) Use Excel Solver to make exponential trend equation to forecast team value.
d) Use Excel Solver to make linear trend equation to forecast team value.
Year Period $ Value
1998 1 227
1999 2 305
2000 3 332
2001 4 367
2002 5 419
2003 6 547
2004 7 609
2005 8 715
2006 9 837
2007 10 911
2008 11 1076