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: Zin AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students

Q

Use spherical coordinates to find the exact volume of the space inside the ellipsoid x^2/5^2+y^2/6^2+z^2/7^2=1 and...

Basic Math
Q

Parts are inspected on a production line for a defect. It is known that 5% of...

Statistics
Q

Compare and contrast prokaryotic cells and eukaryotic cells. Be able to complete a table: prokaryotes in...

Biology
Q

explain with examples, the purpose and process of the tubular and vascular elements of the nephron.

Medical Sciences
Q

Case Study: Gourmet Jams Inc. Strawberry Delight Gourmet Jams Inc. has been in the local Ontario food...

Operations Management
Q

In certain wild animals with normally black fur there occurs a very strange kind of...

Biology
Q

The store does not have a bathroom and the park does not have an ice...

Basic Math
Q

The table shows the number of new small business incorporations for various years Use regression...

Statistics
Q

I need the Journal Entries for the following Data The 2014 balance...

Accounting
Q

Read the study case and answer " you make the call" questions. For...

Accounting
Q

ngle plantwide factory overhead rate Bach Instruments Inc. makes three musical instruments: flutes, clarinets, and...

Accounting
Q

Because bankers and other creditors want assurance that the money they loan to a corporation...

Accounting