15418.1 15188.8 105.7 noil ie 101.9 108.5 15755.5 15125.7 Aug-04 Sep-04 Oct-04 43 16060.0 15934.9 15194.1 15897.8 104.6 16673.0 15368.4 Jn 15262,5 15330.8 44 16875.0 SMat110,6 105.1 15352.9 o109.6...

1) The following data are US exports to Mexico. Complete the missing values. 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)?
15418.1<br>15188.8 105.7 noil ie 101.9<br>108.5<br>15755.5<br>15125.7<br>Aug-04<br>Sep-04<br>Oct-04<br>43<br>16060.0<br>15934.9<br>15194.1<br>15897.8<br>104.6<br>16673.0<br>15368.4<br>Jn 15262,5<br>15330.8<br>44<br>16875.0<br>SMat110,6<br>105.1<br>15352.9<br>o109.6<br>107.0<br>45<br>16975.0<br>15486.7<br>15951.9<br>16119.0<br>46<br>Nov-04<br>16772.0<br>15667.9<br>14846.9<br>96.4<br>16577.7<br>15399.2<br>47<br>Dec-04<br>15983.1<br>15847.0<br>100.9<br>94.0<br>16574.6<br>15467.6<br>14532.3<br>48<br>Jan-05<br>15572.3<br>16037.1<br>97.1<br>97.6<br>16523.6<br>15536.0<br>15163.0<br>49<br>Feb-05<br>16127.0<br>16185.9<br>99.6<br>a) Note that the Adjusted Seasonal Index for March is 112.7. What does this number<br>mean?<br>To estimate the Trend, a regression of the Seasonally Adjusted Series on a trend<br>yielded the following results.<br>SUMMARY<br>OUTPUT<br>Regression Statistics<br>Multiple R<br>R Square<br>Adjusted R<br>Square<br>Standard Error<br>Observations<br>0.803<br>0.645<br>0.638<br>732<br>49<br>ANOVA<br>Significance<br>F<br>3.76219E-<br>df<br>SS<br>MS<br>Regression<br>Residual<br>Total<br>1<br>45823881<br>25186924<br>71010805<br>45823881<br>535892<br>86<br>12<br>47<br>48<br>Standard<br>Error<br>P-<br>Upper<br>95%<br>Coefficients<br>RA 12185.3<br>ANY<br>t Stat<br>value Lower 95%<br>Intercept<br>Trend<br>212.4<br>7.4<br>57.4<br>0.0<br>0.0<br>11758.0<br>12612.6<br>83.3<br>68.4<br>9.2<br>53.5<br>YOU MAY NEED TO USE THESE REGRESSION RESULTS TO HELP<br>COMPLETE THE TABLE ABOVE<br>b) What is your forecast of US Exports to Mexico for March 2005 (which would be<br>the 50th observations)?<br>

Extracted text: 15418.1 15188.8 105.7 noil ie 101.9 108.5 15755.5 15125.7 Aug-04 Sep-04 Oct-04 43 16060.0 15934.9 15194.1 15897.8 104.6 16673.0 15368.4 Jn 15262,5 15330.8 44 16875.0 SMat110,6 105.1 15352.9 o109.6 107.0 45 16975.0 15486.7 15951.9 16119.0 46 Nov-04 16772.0 15667.9 14846.9 96.4 16577.7 15399.2 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 a) 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. SUMMARY OUTPUT Regression Statistics Multiple R R Square Adjusted R Square Standard Error Observations 0.803 0.645 0.638 732 49 ANOVA Significance F 3.76219E- df SS MS Regression Residual Total 1 45823881 25186924 71010805 45823881 535892 86 12 47 48 Standard Error P- Upper 95% Coefficients RA 12185.3 ANY t Stat value Lower 95% Intercept Trend 212.4 7.4 57.4 0.0 0.0 11758.0 12612.6 83.3 68.4 9.2 53.5 YOU MAY NEED TO USE THESE REGRESSION RESULTS TO HELP COMPLETE THE TABLE ABOVE b) What is your forecast of US Exports to Mexico for March 2005 (which would be the 50th observations)?
128378<br>1) The following data are US exports to Mexico. Complete the missing values.<br>Seasonally<br>Adjusted<br>Ratio of<br>Adjusted<br>Trend<br>Original<br>12-month<br>Original to<br>Seasonal<br>Seasonal<br>Projection<br>Forecast<br>Month<br>Series<br>МА<br>МА<br>Index<br>Index<br>Series<br>DATE<br>VALUE<br>1<br>Feb-01<br>13356.8<br>97.6<br>13685.3<br>12253.7<br>11959.6<br>S or ol rabn len 112.7<br>2<br>Mar-01<br>15523.7<br>13768.7<br>12322.1<br>13892.7<br>3<br>Apr-01<br>14403.0<br>13368.6<br>12390.5<br>13349.2<br>4<br>Мay-01<br>15108.0<br>110.8<br>12458.8<br>13800.3<br>5<br>Jun-01<br>15051.0<br>109.3<br>13772.3<br>12527.2<br>13690.3<br>6.<br>Jul-01<br>11700.0<br>89.2<br>13110.5<br>11240.5<br>7<br>Aug-01<br>13764.0 anbA discoze ali to 101.9<br>13503.0<br>12664.0<br>12908.8<br>Sep-01<br>12423.0<br>104.6 11873.1<br>12732.4<br>9.<br>Oct-01<br>13895.0<br>110.6<br>12567.2<br>12800.8<br>14153.2<br>10<br>Nov-01<br>13214.0<br>105.1<br>12567.9<br>12869.1<br>13530.7<br>11<br>Dec-01<br>11319.0<br>96.4<br>11740.1<br>12937.5<br>12473.5<br>12<br>Jan-02<br>12061.5<br>13484,9<br>89.4<br>94.0<br>94.0<br>13005.9<br>12837.8<br>12219.4<br>13<br>Feb-02<br>12368.2<br>92.3<br>97.6<br>97.6<br>12672.4<br>13074.3<br>12760.4<br>14<br>Mar-02<br>13954.0<br>13271.7<br>105.1<br>112.7<br>112.7<br>12376.4<br>13142.7<br>14817.9<br>15<br>Apr-02<br>14113.0<br>13247.6<br>107.7<br>107.7<br>13099.4<br>19000<br>13211.0<br>14233.3<br>16<br>Мaу-02<br>14586.0<br>13204.1<br>110.5<br>110.8<br>13168.1<br>13279.4<br>14709.3<br>17<br>Jun-02<br>14214.0<br>13134.3<br>108.2<br>109.3<br>109.3<br>13006.4<br>13347.8<br>14587.1<br>18<br>Jul-02<br>11607.0<br>13126.6<br>88.4<br>89.2<br>89.2<br>13006.3<br>13416.2<br>11972.8<br>19<br>Aug-02<br>13913.0<br>13139.0<br>105.9<br>1O 13484.6<br>101.9<br>101.9<br>13649.2<br>13745.2<br>20<br>Sep-02<br>13334.0<br>13214.9<br>100.9<br>104.6<br>104.6<br>12743.8<br>13552.9<br>14180.7<br>21<br>Oct-02<br>14702.0<br>13282.1<br>110.7<br>110.6<br>110.6<br>13297.1<br>13621.3<br>15060.4<br>22<br>Nov-02<br>13908.0<br>13340.0<br>104.3<br>105.1<br>105.1<br>13228.0<br>13689.7<br>14393.5<br>23<br>Dec-02<br>12161.0<br>13410.1<br>90.7<br>96.4<br>96.4<br>12613.4<br>13758.1<br>13264.6<br>24<br>Jan-03<br>12889.7<br>13479.2<br>95.6<br>22<br>94.0<br>13719.3<br>13826.5<br>12990.4<br>25<br>Feb-03<br>13292.6<br>13556.2<br>98.1<br>97.6<br>13619.5<br>13894.8<br>13561.3<br>26<br>Mar-03<br>15359.6<br>13673.3<br>112.3<br>12.3<br>112.7<br>13623.1<br>13963.2<br>15743.1<br>27<br>Apr-03<br>14646.4<br>13717.8<br>106.8<br>107.7<br>13594.5<br>scoaras<br>108400O<br>14031.6<br>15117.3<br>28<br>Мay-03<br>15208.0<br>13769.6<br>110.4<br>15709.0<br>110.8<br>13729.7<br>14100.0<br>29<br>Jun-03<br>15003.2<br>15618.2<br>13835.4<br>109.3<br>13728.6<br>14168.4<br>15483.8<br>30<br>Jul-03<br>12029.5<br>13870.6<br>86.7<br>89.2<br>13479.7<br>14236.7<br>hegou 31<br>e 32<br>12705.1<br>12989.7<br>Sep-03N 14518.1<br>94.2 sbnsie<br>Aug-03<br>13793.6<br>101.9<br>12743.4<br>14305.1<br>14581.6<br>13892.3<br>104.5<br>104.6<br>13875.4<br>14373.5<br>15039.2<br>33<br>Oct-03<br>15554.6<br>13963.4<br>111.4<br>110.6 S 14068.3<br>34<br>Nov-03<br>14598,2<br>14441.9<br>15967.7<br>14020.9<br>104.1<br>105.1<br>13884.4<br>35<br>Dec-03<br>13834.0<br>14160.3<br>14510.3<br>15256.2<br>97.7<br>96.4<br>14348.6<br>14578.6<br>36<br>Jan-04<br>13290.8<br>14193.7<br>93.6<br>14055.7<br>94.0<br>14146.2<br>14647.0<br>37<br>Feb-04<br>14341.7<br>14281.2<br>100.4<br>13761.3<br>38<br>Mar-04<br>97.6<br>14694.4<br>14715,4<br>14362.2<br>THOAE<br>112.7<br>107.7<br>17458.0<br>14456.0<br>120.8<br>39<br>Apr-04<br>16014.0<br>14570.0<br>15484.3<br>14783.8<br>16668.2<br>109.9<br>40<br>Мay-04<br>16334.0<br>14663.8<br>14863.9<br>14852.2<br>16001.4<br>111.4<br>41<br>Jun-04<br>16438.0<br>110.8<br>14746.2<br>14920.5<br>16527.1<br>14783,4<br>111.2<br>42<br>Jul-04<br>109.3<br>15041,5<br>14988.9<br>16380.6<br>13824.0<br>14932.9<br>92.6<br>89.2<br>15490.6<br>15057.3<br>13437.4<br>

Extracted text: 128378 1) The following data are US exports to Mexico. Complete the missing values. Seasonally Adjusted Ratio of Adjusted Trend Original 12-month Original to Seasonal Seasonal Projection Forecast Month Series МА МА Index Index Series DATE VALUE 1 Feb-01 13356.8 97.6 13685.3 12253.7 11959.6 S or ol rabn len 112.7 2 Mar-01 15523.7 13768.7 12322.1 13892.7 3 Apr-01 14403.0 13368.6 12390.5 13349.2 4 Мay-01 15108.0 110.8 12458.8 13800.3 5 Jun-01 15051.0 109.3 13772.3 12527.2 13690.3 6. Jul-01 11700.0 89.2 13110.5 11240.5 7 Aug-01 13764.0 anbA discoze ali to 101.9 13503.0 12664.0 12908.8 Sep-01 12423.0 104.6 11873.1 12732.4 9. Oct-01 13895.0 110.6 12567.2 12800.8 14153.2 10 Nov-01 13214.0 105.1 12567.9 12869.1 13530.7 11 Dec-01 11319.0 96.4 11740.1 12937.5 12473.5 12 Jan-02 12061.5 13484,9 89.4 94.0 94.0 13005.9 12837.8 12219.4 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 15 Apr-02 14113.0 13247.6 107.7 107.7 13099.4 19000 13211.0 14233.3 16 Мaу-02 14586.0 13204.1 110.5 110.8 13168.1 13279.4 14709.3 17 Jun-02 14214.0 13134.3 108.2 109.3 109.3 13006.4 13347.8 14587.1 18 Jul-02 11607.0 13126.6 88.4 89.2 89.2 13006.3 13416.2 11972.8 19 Aug-02 13913.0 13139.0 105.9 1O 13484.6 101.9 101.9 13649.2 13745.2 20 Sep-02 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 22 Nov-02 13908.0 13340.0 104.3 105.1 105.1 13228.0 13689.7 14393.5 23 Dec-02 12161.0 13410.1 90.7 96.4 96.4 12613.4 13758.1 13264.6 24 Jan-03 12889.7 13479.2 95.6 22 94.0 13719.3 13826.5 12990.4 25 Feb-03 13292.6 13556.2 98.1 97.6 13619.5 13894.8 13561.3 26 Mar-03 15359.6 13673.3 112.3 12.3 112.7 13623.1 13963.2 15743.1 27 Apr-03 14646.4 13717.8 106.8 107.7 13594.5 scoaras 108400O 14031.6 15117.3 28 Мay-03 15208.0 13769.6 110.4 15709.0 110.8 13729.7 14100.0 29 Jun-03 15003.2 15618.2 13835.4 109.3 13728.6 14168.4 15483.8 30 Jul-03 12029.5 13870.6 86.7 89.2 13479.7 14236.7 hegou 31 e 32 12705.1 12989.7 Sep-03N 14518.1 94.2 sbnsie Aug-03 13793.6 101.9 12743.4 14305.1 14581.6 13892.3 104.5 104.6 13875.4 14373.5 15039.2 33 Oct-03 15554.6 13963.4 111.4 110.6 S 14068.3 34 Nov-03 14598,2 14441.9 15967.7 14020.9 104.1 105.1 13884.4 35 Dec-03 13834.0 14160.3 14510.3 15256.2 97.7 96.4 14348.6 14578.6 36 Jan-04 13290.8 14193.7 93.6 14055.7 94.0 14146.2 14647.0 37 Feb-04 14341.7 14281.2 100.4 13761.3 38 Mar-04 97.6 14694.4 14715,4 14362.2 THOAE 112.7 107.7 17458.0 14456.0 120.8 39 Apr-04 16014.0 14570.0 15484.3 14783.8 16668.2 109.9 40 Мay-04 16334.0 14663.8 14863.9 14852.2 16001.4 111.4 41 Jun-04 16438.0 110.8 14746.2 14920.5 16527.1 14783,4 111.2 42 Jul-04 109.3 15041,5 14988.9 16380.6 13824.0 14932.9 92.6 89.2 15490.6 15057.3 13437.4
Jun 04, 2022
SOLUTION.PDF
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here
Have files?