xyD Assignment Week 6 S CLE: BUSN602 100, X McGraw-Hill Education C O Not secure

Question

xyD Assignment Week 6 S CLE: BUSN602 100, X McGraw-Hill Education C O Not secure ezto.mheducation.com/hm.tpx connect APUS BUSN602: BUSN602 1002 Sum 18 FINANCE gnment Week 6 Question 8 (of 10) value 0.00 points Suppose a firm has had the following historic sales figures. Year: 2009 2 2010 2011 2012 2013 Sales $1,450,000 $1,670,000 $1,580,000 $2,100,000 $1,890,000 What would be the forecast for next year's sales using regression to estimate a trend? Next year's sales Hints References eBook & Resources Hint#1 Hint #2 Hint#3 Type here to search

Explanation / Answer

Year Sales Forecast 2009 1450000 N/A 2010 1670000 N/A 2011 1580000 N/A 2012 2100000 N/A 2013 1890000 N/A 2014 2131000 Used CTRl+Shift+Enter Year Sales X Y XY X^2 1 1450000 1450000 1 2 1670000 3340000 4 3 1580000 4740000 9 4 2100000 8400000 16 5 1890000 9450000 25 Total 15 8690000 27380000 55 Here X mean =Sigma X/n =15/5 = 3 Here Y mean = Sigma Y/n 8690000/5 = 1738000 b= Sigma XY-n x Xmean x Ymean divided by Sigma X Square-nx Sqaure of X mean 131000 calculation the value of a a=mean of Y-b x mean of X 1345000 Y= a+bx Forecasting for the 6th year =1345000+131000*6 2131000

Related Questions

Navigate

• Browse (All)
• Browse X
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.