11) The following data are US exports to Mexico. Complete the missing values. YOU WILL NEED TO USE THE REGRESSION RESULTS BELOW TO HELP COMPLETE THE TABLE ABOVE. a) Fill in the table. b) Note that the Adjusted Seasonal Index for March is 112.7. What does this number mean? To estimate the Trend, a regression of the Seasonally Adjusted Series on a trend yielded the following results. c) What is your forecast of US Exports to Mexico for March 2005 (which would be the 50th observation)?
11) The following data are US exports to Mexico. Complete the missing values. YOU WILL NEED TO USE THE REGRESSION RESULTS BELOW TO HELP COMPLETE THE TABLE ABOVE. a) Fill in the table. b) Note that the Adjusted Seasonal Index for March is 112.7. What does this number mean? To estimate the Trend, a regression of the Seasonally Adjusted Series on a trend yielded the following results. c) What is your forecast of US Exports to Mexico for March 2005 (which would be the 50th observation)?
MATLAB: An Introduction with Applications
6th Edition
ISBN:9781119256830
Author:Amos Gilat
Publisher:Amos Gilat
Chapter1: Starting With Matlab
Section: Chapter Questions
Problem 1P
Related questions
Question
11) The following data are US exports to Mexico. Complete the missing values.
YOU WILL NEED TO USE THE REGRESSION RESULTS BELOW TO HELP COMPLETE THE TABLE ABOVE.
a) Fill in the table.
b) Note that the Adjusted Seasonal Index for March is 112.7. What does this number mean?
To estimate the Trend, a regression of the Seasonally Adjusted Series on a trend yielded the following results.
c) What is your forecast of US Exports to Mexico for March 2005 (which would be the 50th observation)?
Transcribed Image Text:11) The following data are US exports to Mexico. Complete the missing values.
YOU WILL NEED TO USE THE REGRESSION RESULTS BELOW 1O HELP COMPLETE
THE TABLE ABOVE
Ratio of
Seasonally
Adjusted
Adjusted
Trend
Original
12-month
Original to
Seasonal
Seasonal
Projection
Forecast
MA o
MA
Month
Series
Index
Index
Series
TUTTUO YAMMUR
DATE
VALUE
Feb-01
13356.8
97.6
13685.3
12253.7
11959.6
Mar-01
15523,7
112.7
13768.7
12322.1
13892.7
3
Apr-01
14403.0
13349.2 M
13368.6
12390.5
May-01
15108.0
110.8
12458.8
13800.3
A
Jun-01
Jul-01
15051.0
109.3
13772.3
12527.2
13690.3
6
11700.0
89.2
13110.5
11240.5
Aug-01
13764.0
101.9
13503.0
12664.0
12908.8
Sep-01
12423.0
104.6
11873.1
12732.4
9.
Oct-01
13895.0
12800.8
14153,2 OMA
110.6
12567.2
10
Nov-01
13214.0
105.1
12567.9
12869.1
13530.7
0.0TEI
12473.5
12219.4 s
IssoT
11
Dec-01
11319.0
96.4
11740.1
12937.5
12
Jan-02
12061.5
13484.9
89.4
94.0
94.0
12837.8
13005.9
13
Feb-02
12368.2
92.3
97.6
97.6
12672.4
13074.3
12760.4
14
Mar-02
13954.0
13271.7
105.1
112.7
112.7
12376.4
13142.7
14817.9
2R15
Apr-02
OW14113.0
13247.6
13211.0
14233.3
107.7
107.7
13099.4
eres 16
2e0.E 17
220.018
E00.019
14709.3 tal
14587.1o
11972.8 ri
13745.2 noos
Мay-02
14586.0
13204.1
110.5
110.8
13168.1
13279.4
Jun-02 14214.0
13134.3
108.2
- 109.3
109.3
13006.4 13347.8
Jul-028.011607.0
13126.6
88.4
89.2
89.2
13006.3 U 13416.2
Aug-02.0 13913.0
Sep-02
13139.0
105.9.0
101.9
13649.2 .0- 13484.6
101.9
20
13334.0
13214.9
100.9
104.6
104.6
12743.8
13552.9
14180.7
21
Oct-02
14702.0
13282.1
110.7
110.6
110.6
13297.1
13621.3
15060.4
104.3
TA2 105.1AUG05.1T 228.0
13689.7
14393.5
22
Nov-02
13908.0
13340.0
13228.0
23
Dec-02
12161.0
13410.1
90.7
96.4
96.4
12613.4
13758.1
13264.6
Jan-03
13479.2
95.6
94.0
13719.3
13826.5
12990.4
24
12889.7
13619.5
13894.8
13561.3
.6 13556.2ge 98.1nillooulun adt 7 uoe o
13623.1
25
Feb-03
13292.6
Mar-03
15359.6
13673.3
112.3
112.7
13963.2
15743.1
26
14646.4
13717.8
106.8
107.7
13594.5
14031.6
15117.3
27
Apr-03
15208.0
13769.6
110.4
110.8
13729.7
14100.0
15618.2
28
Мay-03
15003.2
13835.4
108.4
109.3
13728.6
14168.4
15483.8
29
Jun-03
12029.5
13870.6
86.7
89.2
13479.7
14236.7
12705.1
30
Jul-03
12989.7
13793.6
94.2
101.9
12743.4
14305.1
14581.6
31
Aug-03
104.5
104.6
13875.4
14373.5
15039.2
32
Sep-03
14518.1
13892.3
15554.6
13963.4
111.4
110.6
14068.3
14441.9
15967.7
33
Oct-03
105.1
13884.4
14510.3
15256.2
34
Nov-03
14598.2
14020.9
104.1
14160.3
97.7
96.4
14348.6
14578.6
14055.7
35
Dec-03
13834.0
94.0
14146.2
14647.0
13761.3
36
Jan-04
13290.8
14193.7
93.6
100.4
97.6
14694.4
14715.4
14362.2
37
Feb-04
14341.7
14281.2
112.7
15484.3
14783.8
16668.2
38
Mar-04
17458.0
14456.0
120.8
107.7
14863.9
14852.2
16001.4
16014.0
14570.0
109.9
Apr-04
May-04
39
110.8
14746.2
14920.5
16527.1
40
16334.0
14663.8
111.4
109.3
15041.5
14988.9
16380.6
41
Jun-04
16438.0
14783.4
111.2
89.2
15490.6
15057.3
13437.4
42
Jul-04
13824.0
14932.9
92.6
101.9
15755.5
15125.7
15418.1
15188.8
105.7
Aug-04
Sep-04
Oct-04
43
16060.0
104.6
15934.9
15194.1
15897.8
44
16673.0
15368.4
108.5
110.6
15352.9
15262.5
16875.0
16975.0
15486.7
109.6
45
105.1
15951.9
15330.8
16119.0
46
Nov-04
16772.0
15667.9
107.0
96.4
16577.7
15399.2
14846.9
47
Dec-04
15983.1
15847.0
100.9
94.0
16574.6
15467.6
14532.3
48
Jan-05
15572.3
16037.1
97.1
97.6
16523.6
15536.0
15163.0
49
Feb-05
16127.0
16185.9
99.6
Transcribed Image Text:ol obooob a om oil.otchoql 20 0 ol ovotun l
a) Note that the Adjusted Seasonal Index for March is 112.7. What does this number mean?
TUTTUO YE
ia no t
828.0
E.0
RelgiuM
To estimate the Trend, a regression of the Seasonally Adjusted Series on a trend yielded the following
results.
eest
SUMMARY
OUTPUT
101 bubnate
enoltevado
AVOWA
Regression Statistics
Multiple R
R Square 20-TS8 e
Adjusted R Square
Standard Error
Observations
0.803
0.645
0.638
2M
nolaaget
laubiesF
to T
sezasar
arseaerT
732
TA
49
bisbna
םרסר
ANOVA e 1owo.
eulov-9
selev00.0
20 df se
enoialteo0
00e0 Significanceatn
ISTS
ere.o
A MS
45823881
535892
SI8.0
ereo
Regression
Residual
3.76219E-12
45823881
25186924
Total S doalM oi ooixsM 48oxa 271010805 woy ai lerw alu noizogon sat ro boas (EI
86
47
Standard
Error
P-
value
Upper
95%
t Stat
Lower 95%
Coefficients
12185.3
Intercept
Trend
nielexa 212.4
68.4
57.4 uoy o0.0nol 11758.0dhid 12612.6
53.5
7.4
9.2
0.0
83.3
b) What is your forecast of US Exports to Mexico for March 2005 (which would be the 50
observations)?
3160
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 3 steps with 2 images
Recommended textbooks for you
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
Probability and Statistics for Engineering and th…
Statistics
ISBN:
9781305251809
Author:
Jay L. Devore
Publisher:
Cengage Learning
Statistics for The Behavioral Sciences (MindTap C…
Statistics
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
Probability and Statistics for Engineering and th…
Statistics
ISBN:
9781305251809
Author:
Jay L. Devore
Publisher:
Cengage Learning
Statistics for The Behavioral Sciences (MindTap C…
Statistics
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning
Elementary Statistics: Picturing the World (7th E…
Statistics
ISBN:
9780134683416
Author:
Ron Larson, Betsy Farber
Publisher:
PEARSON
The Basic Practice of Statistics
Statistics
ISBN:
9781319042578
Author:
David S. Moore, William I. Notz, Michael A. Fligner
Publisher:
W. H. Freeman
Introduction to the Practice of Statistics
Statistics
ISBN:
9781319013387
Author:
David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:
W. H. Freeman