Financial Forecasting TREND Function Student Name Student Number (Predict the expected sales based on actual sales) Class Work 18: The fallowing sales data for Emad Company the years 1996 to 2006, which grow on a regular basis (linear regression) during those years: Required: Use TREND Function to predict the expected sales during the next five years (2007 to 2011) TREND(known y's.known x's,new x's,const) Year 1996 1997 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 Sales S,500 6,500 7,800 9,000 11,500 10,600 10,000 8,600 10,200 10,500 10,900 where: Known y's:is the set of y-values you already know in the relationship y- mx + b Known x's:is an optional set of x-values that you may already know in the relationship y mx + b. New x's are newx-values for which you want TREND to return corresponding y-values Const: is a logical value specifying whether to force the constant b to equal 0