Homework Help is Here – Start Your Trial Now!
Math
Statistics
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
MATLAB: An Introduction with Applications
6th Edition
ISBN:9781119256830
Author:Amos Gilat
Publisher:Amos Gilat
Chapter1: Starting With Matlab
Section: Chapter Questions
Problem 1P
See similar textbooks
icon
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)?
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: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
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
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
steps

Step by step

Solved in 3 steps with 2 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Similar questions
Recommended textbooks for you
MATLAB: An Introduction with Applications
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
Probability and Statistics for Engineering and th…
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 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…
Elementary Statistics: Picturing the World (7th E…
Statistics
ISBN:
9780134683416
Author:
Ron Larson, Betsy Farber
Publisher:
PEARSON
The Basic Practice of Statistics
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
Introduction to the Practice of Statistics
Statistics
ISBN:
9781319013387
Author:
David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:
W. H. Freeman
SEE MORE TEXTBOOKS