Producing analysis as part of soft-drink industry study ...

      Table 2 -   Coca Cola Company Revenue    Year Revenues   (Billion $)   1995 18.0   1996 18.5   1997 18.9   1998 18.8   1999 19.8   2000 20.5   2001 20.1   2002 19.6   2003 21.0   2004 21.9   2005 23.1   2006 24.1   2007 28.9   2008 31.9   2009 31.0   2010 35.1           Producing   analysis as part of soft-drink industry study. Help with the following would   be appreciated:        a) Plot data           b) Linear   trend line (simple regression) and coefficient significance          c)   Quadratic trend line (Y=a+bt+ct^2) and significance of coefficients          d)   Estimated exponential trend line . Values of a+b          e)   Calculate Mean Sum of Squared Errors          f)   Forecast 2011 rates          g) 3 year   moving average          h) Create   smoothing trend using weight of .7