Question
Suppose a firm has had the historical sales figures shown. What would be the forecast for next year's sales using regression to estimate a trend?
Suppose a firm has had the historical sales figures shown. What would be the forecast for next year's sales using regression to estimate a trend?
Year | Sales (Y) | X | X*Y | X*X |
---|---|---|---|---|
2008 | 2,000,000.00 | 1 | 2,000,000 | 1 |
2009 | 1,800,000.00 | 2 | 3,600,000 | 4 |
2010 | 2,200,000.00 | 3 | 6,600,000 | 9 |
2011 | 2,400,000.00 | 4 | 9,600,000 | 16 |
2012 | 2,300,000.00 | 5 | 11,500,000 | 25 |
Sum | 10,700,000.00 | 15 | 33,300,000.00 | 55.00 |
Average | 2,140,000.00 | 3 | 6,660,000.0000 | 11.00 |
Step by Step Solution
3.54 Rating (157 Votes )
There are 3 Steps involved in it
Step: 1
viev Let x be the years denoted by 15 Let y be the sales Let the Regression line be y bo bx where b...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 StartedRecommended Textbook for
Finance Applications and Theory
Authors: Marcia Cornett, Troy Adair
3rd edition
1259252221, 007786168X, 9781259252228, 978-0077861681
Students also viewed these Finance questions
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
View Answer in SolutionInn App