Answered step by step
Verified Expert Solution
Question
1 Approved Answer
I need help with how to type the formula into excel for this homework. I cant find the right functions for regression. I know long
I need help with how to type the formula into excel for this homework. I cant find the right functions for regression. I know long hand how to do it but struggle with these excel simulations which only allow for a few tries. I tend to get them wrong with one step missing.
Regression Sales Forecast- Excel HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW obCalibri B 1 u . |2 A Alignment Number Conditional Format as Cell CellsEditing Formatting Table Styles oard D Font Styles AB Suppose a firm has had the following historic sales figures. Year 2009 2010 2011 2012 2013 Sales 1,410,000 S 1,670,000 S 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? Year 2009 2010 2011 2012 2013 Sales $ 1,410,000 $ 1,670,000 $ 1,580,000 $2,170,000 $ 1,810,000 0 12 13 14 15 pe here to search Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started