Logo
Home Study Material Contact Search
AI Chat FREE
  1. mathematics
  2. basic math
  3. here are quarterly data for the past two years, fr

Here are quarterly data for the past two years, from these data, prepare a forecast for...

Free

90.2K

Verified Solution

Question

Basic Math

Here are quarterly data for the past two years, from these data,prepare a forecast for the upcoming year using decompostion.foreccast years 9 to 12. FORECAST ERROR?

PeriodActualperiodActual
13005416
25406760
388571191
45808760

Answer & Explanation Solved by verified expert
4.1 Ratings (513 Votes)

By running regression of the form Y = a+bX

Where Y is actual and X is period, we get results of the form,

SUMMARY OUTPUT
Regression Statistics
Multiple R 0.61
R Square 0.37
Adjusted R Square 0.27
Standard Error 241.49
Observations 8
ANOVA
df SS MS F Significance F
Regression 1         2,09,738.67      2,09,738.67                     3.60                      0.11
Residual 6         3,49,895.33          58,315.89
Total 7         5,59,634.00
Coefficients Standard Error t Stat P-value Lower 95% Upper 95%
Intercept 361.00 188.17 1.92 0.10 -99.42 821.42
Period 70.67 37.26 1.90 0.11 -20.51 161.84
Period Actual
1 300
2 540
3 885
4 580
5 416
6 760
7 1191
8 760
9 997
10 1068
11 1138

Forecasts,

Period 9 = 361+70.67*9 = 997.03

Period 10 = 361+70.67*10 = 1067.7

Period 11 = 361+70.67*11 = 1138..37
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students

Calculus
1.2K views

A railroad crew can lay 5 miles of track each day. They need to lay...

Accounting
1.2K views

On January 1, 2018, Edward Corporation had 29,000 shares of $5 par value common stock and...

Basic Math
1.2K views

Which style do these musical characteristics describe Music that used vernacular language rather than Latin...

Basic Math
1.2K views

Divide.7?1862Select the correct choice below and fill in any answer boxes in your choice.A. The...

Basic Math
1.2K views

Write the statement using symbols Let p be you live in the city of Nashville...

Algebra
1.2K views

An open-faced box is to be constructed by cutting squares out of the corners of...

Algebra
1.2K views

Use intercepts to graph the equation.5x + 6y + 30 = 0

Algebra
1.2K views

Multiply 2i 4 5i 2i 4 5i Simplify your answer Type your answer in the...

Algebra
1.2K views

1 oftwa Factoring Quadratic Factor each completely 1 m 18m 81 A m 9 B...

Accounting
1.2K views

Cash receipts and disbursement transactions _________. A. should be approved by the bank before recording...

Accounting
1.2K views

David expects taxable revenues of $110,333 in the current year. His adjustments to revenues are...

Accounting
1.2K views

Equity (20 points) Need help with QUESTIONS 5 - 9 ...