1. The following table shows the annual revenues (in millions of dollars) of a pharmaceutical company over the period 1990-2011. 1990 1991 1992 1993 1994 1995 1996 1997 1998 1999 2000 Year Revenue Year 830 2001 791 842 891 953 1036 1050 1070 1127 1272 1386 2002 2003 Revenue 1304 1379 1417 1525 1613 1870 1593 1595 2004 2005 2006 2007 2008 2009 2010 2011 1441 2132 2330 2500 2000 1500 1000 500 Revenue 0 0 5 10 15 20 25 Revenue Excel scatterplot shown above indicates that the annual revenues have an increasing trend. Therefore, linear, exponential, quadratic and cubic models were used to fit the trend, and the following relevant information became available after applying linear regression. Variable Linear Trend Exponential Trend Intercept 642.792 6.632 Quadratic Trend 797.317 Cubic Trend 648.766 Time 60.496 0.045 21.866 91.726 Time NA NA 1.680 Time3 NA NA NA -5.748 0.215 MSE 16663.24 12823.14 MAD 93.74 76.03 13029.90 75.94 11207.08 Se 135.383 0.069 122.830 72.72 117.036 R2 0.8984 0.9502 Adjusted R 0.8933 0.9477 0.9205 0.9122 0.9317 0.9203 a. Use the seasonal dummy variable to make forecast for quarterly revenue in 2022. b. Using the linear trend equation, what is the predicted yearly increase (decrease) of the revenue? C. What is the revenue forecast for 2012 found by the linear trend equation? [t = 23] d. What is an exponential trend equation? e. What is a revenue forecast for 2012 found by the exponential trend equation? f. When three polynomial trend equations are compared, which of them provides the best fit? g. What is a revenue forecast for 2012 found by the polynomial trend equation with the best fit?