Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

From table 12-10-0011-01, obtain total merchandise imports and exports (balance of payments basis) between Canada and the major geographical regions in the world reported in

image text in transcribedimage text in transcribedimage text in transcribed

image text in transcribedimage text in transcribedimage text in transcribed
From table 12-10-0011-01, obtain total merchandise imports and exports (balance of payments basis) between Canada and the major geographical regions in the world reported in the table from January 1998 to December 2020. Download the data as CSV (download as displayed). Aggregate the monthly data to annual data (i.e. sum over rows from January 1998 to December 1998 to obtain the yearly observation for 1998). Do the same for all years for Export and Import. You will obtain data for Exports and Imports for 23 years (from 1998 to 2020 inclusive).Canada Balance of payments Seasonally adjusted 2010 2011 Principal trading 1998 1999 200 2001 2002 2003 2004 2005 2006 2007 2008 2009 Trade Import Dollars 356,271.10 342,328.50 362,890.00 387,454.50 404,510. 10 415,790.70 443,592.00 373,984.20 413,670.00 456,044.90 All countries 303,091.80 326,666.80 361,926.20 349,587.60 254,856.10 240,044.50 249,835.90 259,085.50 265, 121.70 269,998.60 281,434.40 236, 136.40 259,934.80 281,337.00 United States 233,516.70 249, 199.70 266, 165.00 253,912.50 35,979.50 35, 124.80 36,417.40 38,436.40 42,029.20 42,382.60 46,620.90 38,842.00 40,423.40 45,859.40 European Union 25, 122.70 28,313.50 33,372.50 35,099.00 5622.4 7550.4 9578.2 13224.3 17,208.80 20,939.40 23,824.30 26, 177.40 23,573.90 26,391.10 28,710.80 China 2712.6 3350.8 4745.5 12265.7 11,937.40 10156.7 158.6 9446.5 9019 9521.6 9955.5 11218.7 8499.4 9556.3 10558.4 United Kingdom 6068.9 7645.7 3597.2 4412.9 6695.3 6941.7 6921 6586.8 6757.6 7781.4 8834.1 9539.9 10385.8 10154.2 13,927.60 15,263.80 Mexico Export All countries 326,294.90 367,870.20 428,004.80 419, 102.80 412, 124.10 397,273.00 427,238.20 448,418.30 451,971.50 461,385.20 487,261.60 367,210.80 403,966.70 456,612.50 329,266.40 United States 268,554.50 308,058.10 357,797.20 350,710.30 345,590.70 327,603.40 349, 153.80 366,956.60 360,055.70 354,509.60 368,901.70 270, 102.70 295, 113.10 22,381.20 23,990.90 26,933.60 27,806.50 31,931.50 38,327.70 39,070.80 31,670.00 37,209.90 42,632.70 European Union 19,279.70 20,335.50 24,028.40 23,547.40 18, 133.10 China 2730.7 3102 4647.6 5375.2 5198.9 6026.9 7990.7 8157.5 8740.7 10556.4 11287.9 11782.8 14147.3 5302.4 5980 7252.5 6891.7 6133.7 7652.9 9314.1 9305.4 11,204.90 14,091.30 13,973.40 12,884.10 16,971.60 19,380.40 United Kingdom 7446.4 7976.5 6459.7 6683 7268.5 Mexico 2773.8 3934.1 5029.1 5762.3 5519.8 5150.4 5722.1 5545.7 6611.22012 2013 2014 2015 2016 2017 2018 2019 2020 474,800.30 487,370.10 524,660.70 548,681.90 547,349.20 575,024.30 607,343.40 613,527.40 561,352.30 296,028.40 313,321.10 351,081.00 363,515.10 359,768.50 371,727.40 390,846.20 391,954.90 349,323.40 44,638.10 45,391.70 49,475.80 53, 162.70 52,442.20 56,857.60 63,609.50 66,219.30 60,370.20 30,952.10 31,943.90 35,569.60 38,963.20 37,661.10 42,732.30 46,357.80 46,862.40 49,551.00 8394.9 7619.6 8255.5 8639.4 7737.5 8088.6 8215.6 8384.4 9402.1 15,911.50 16,380.80 17,135.60 18,373.70 18,915.50 21,235.10 20,855.60 20,456.30 16,930.30 461,511.20 479,224.70 529,333.60 524,046.10 522,300.90 550,524.70 587,512.10 598, 166.70 523,838.40 336,598.10 357,359.80 401,270.60 396,497.20 392,835.80 411,064.10 434,449.50 446,304.90 375,861.40 41,402.80 36,022.10 40,498.90 39,263.10 41,962.40 43,819.40 46,646.00 49,784.40 50,092.00 20,368.00 22,030.90 20,466.50 21,418.50 22,346.40 24,991.80 29,075.80 24,489.00 26,302.60 19,879.80 14,838.80 15880 16,513.20 17,970.30 18,752.20 17,182.50 20,508.30 21,413.80 6919.2 6636.6 6743.4 7829.6 8896.1 9181.8 9494.6 8354 6979

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Bank Management

Authors: Timothy W Koch, Mark S Cracolice

7th Edition

1111804265, 9781111804268

More Books

Students also viewed these Economics questions

Question

Identify and describe four types of interfund activities. LO4

Answered: 1 week ago

Question

Is there something else less expensive that would be just as good?

Answered: 1 week ago