FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign In 1+1 Arial 12 % A Paste BIU- Alignment Number Cells Editing Conditional Format as Cell Formatting Table Styles Styles Clipboard Font D19 X D E F G H I Suppose a firm has had the following historic sales figures. Year: 2009 2010 2011 2012 2013 Sales $ 1,410,000 $1,670,000 $1,580,000 $2,170,000 $1,810,000 What would be the forecast for next year's sales using regression to estimate a trend? 5 6 7 8 9 Year 2009 2010 2011 2012 2013 10 $ $ $ $ Sales 1,410,000 1,670,000 1,580,000 2,170,000 1,810,000 11 12 13 14 15 16 17 Complete the following analysis. Do not hard code values in your calculations, and do not round intermediate calculations. 18 19 Next vear's sales Sheet1 +