Question
Suppose a firm had the following historical sales figures. 2009-1450000 2010-1670000 2011-1580000 2012-2100000 2013-1890000 What would be the forecast for the next year's sales using
Suppose a firm had the following historical sales figures.
2009-1450000
2010-1670000
2011-1580000
2012-2100000
2013-1890000
What would be the forecast for the next year's sales using regression to estimate a trend?
Next year sales= $ ?
Can you write out how you figured it out and how I would type it into Excel and what functions to use? Ty
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
Financial Markets And Institutions
Authors: Frederic S. Mishkin, Stanley G. Eakins
9th Edition
0134519264, 9780134519265
