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


