Assignment-II Data (1)

xlsx

School

Toronto Metropolitan University *

*We aren’t endorsed by this school

Course

129

Subject

Economics

Date

Jan 9, 2024

Type

xlsx

Pages

24

Uploaded by UltraBook12875

Report
Use the stated Source to extract the Data Year Exports Imports Net Imports 1981 156,781 140,560 16,221 1982 154,668 118,272 36,396 1983 163,578 130,319 33,259 1984 194,089 153,061 41,028 1985 202,901 165,816 37,085 1986 212,083 176,915 35,168 1987 218,874 186,473 32,401 1988 238,757 211,619 27,138 1989 240,888 223,832 17,056 1990 251,976 227,928 24,048 1991 256,174 233,828 22,346 1992 275,351 246,020 29,331 1993 305,074 264,453 40,621 1994 344,195 286,426 57,769 1995 374,722 303,102 71,620 1996 397,037 319,457 77,580 1997 431,304 365,456 65,848 1998 472,363 384,861 87,502 1999 523,342 415,943 107,399 2000 570,261 451,399 118,862 2001 554,899 429,373 125,526 2002 561,560 437,454 124,106 2003 552,060 456,010 96,050 2004 582,748 494,865 87,883 2005 596,037 531,188 64,849 2006 601,322 559,426 41,896 2007 607,838 591,781 16,057 2008 580,158 597,182 -17,024 2009 505,026 523,058 -18,032 2010 538,741 595,157 -56,416 2011 564,585 628,440 -63,855 2012 580,192 651,552 -71,360 2013 594,426 665,112 -70,686 2014 631,988 681,850 -49,862 2015 653,469 687,031 -33,562 2016 663,436 687,389 -23,953 2017 673,326 720,254 -46,928 2018 697,392 745,447 -48,055
2019 713,338 744,641 -31,303
1981 1983 1985 1987 1989 1991 1993 1995 1997 1999 2001 2003 2005 2007 2009 2011 2013 2015 2017 2019 0 100,000 200,000 300,000 400,000 500,000 600,000 700,000 800,000 'Exports', 'Imports', 'Net Imports' by 'Year' Exports Imports Year 1981 1983 1985 1987 1989 1991 1993 1995 1997 1999 2001 2003 2005 2007 2009 2011 2013 2015 2017 2019 100,000 -50,000 0 50,000 100,000 150,000 'Exports', 'Imports', 'Net Imports' by 'Year' Net Imports Year
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Use the stated Source to extract the Data Year Average o Average of Inflation % 1991 10.32 5.6 1992 11.19 1.5 1993 11.4 1.9 1994 10.42 0.2 1995 9.51 2.1 1996 9.61 1.6 1997 9.12 1.6 1998 8.28 1 1999 7.59 1.7 2000 6.82 2.7 2001 7.22 2.5 2002 7.67 2.3 2003 7.58 2.8 2004 7.19 1.9 2005 6.76 2.2 2006 6.47 2 2007 6.17 2.1 -0.00332 2008 6.29 2.4 2009 8.45 0.3 2010 8.18 1.8 2011 7.63 2.9 2012 7.4 1.5 2013 7.15 0.9 2014 7.03 1.9 2015 6.94 1.1 2016 7.03 1.4 2017 6.42 1.6 2018 5.84 2.3 2019 5.69 1.9 https://data.oecd.org/ 1985 0 2 4 6 8 10 12 'Unem
/price/inflation-cpi.htm 1990 1995 2000 2005 2010 2015 2020 mployement %', 'Inflation %' by 'Year' Column B Column C Year
a. 0.394472 b. 49.29293 The probability of winning a game of craps (a dice-throwing game played in casinos) is 244/495. a) What is the probability of winning 5 or more times in 10 games? (5 Points) b) What is the expected number of wins in 100 games? (5 Points)
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
a. 0.03369 b. 0.082971 Cars arriving for gasoline at a particular gas station follow a Poisson distribution with a mean of 5 per hour. a) Determine the probability that over the next hour only one car will arrive. (5 Points) b) Compute the probability that in the next 3 hours more than 20 cars will arrive. (5 Points)
Industry Contribution in (Billions of pesos) Food Products,Beverages and Tobacco 2,738 Textiles 415 Wood and Paper Products 425 Chemical, Rubber and Plastics 2879 Basic Metals 1351 Machinery 2688 Transport Equipment 3638 Furniture 433 https://read.oecd-ilibrary.org/industry-and-services/stan-oecd-structural-analysis-statistics-2020_cba41dd8-en# Cont Food Produ Wood and Basic Met Transport
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
#page99 2738; 18.80% 415; 2.85% 425; 2.92% 2879; 19.76% 1351; 9.27% 2688; 18.45% 3638; 24.97% 433; 2.97% tribution in (Billions of pesos) ducts,Beverages and Tobacco Textiles d Paper Products Chemical, Rubber and Plastics tals Machinery Equipment Furniture
Column1 Column2 Column3 Column4 Column5 Column6 15-24 25-29 30-34 35-54 Columbia 17 10.1 10.6 42.5 Brazil 17.9 9.7 11.1 42.4 Egypt 22.3 13.3 11.3 38.8
Column7 Column8 55-64 65+ 12.9 7 13.2 5.7 10 4.3
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
a. 0.381744 b. 0.258805 c. 0.143551 d. 0.296796 In the game of roulette, a steel ball is rolled onto a wheel that contains 18 red, 18 black, and 2 green s If the ball is rolled 25 times, find the probabilities of the following events. a) The ball falls into the green slots two or more times. (2.5 Points) b) The ball does not fall into any green slots. (2.5 Points) c)The ball falls into black slots 15 or more times. (2.5 Points) d) The ball falls into red slots 10 or fewer times. (2.5 Points)
slots.
f(x)=λe^−λx Numbers distribution 0 0.25 2 0.151632664928158 4 0.091969860292861 6 0.055782540037108 8 0.033833820809153 10 0.020521249655975 15 0.005879436464002 20 0.001684486749771 The random variable is exponentially distributed with =.25 . Sketch the graph of the distribu ? ? =0,2,4,6,8,10,15,20. ? 0 2 4 6 8 10 12 14 16 0 0.05 0.1 0.15 0.2 0.25 0.3 distribution distribution Exponential (distribution) Numbers distribution
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
ution of by plotng and connecting the points representing ) for ? ?(?
λ=1/6 x=10 0.188876 The manager of a supermarket tracked the amount of time needed for customers to be served b After checking with his statistics professor, he concluded that the checkout times are exponentia with a mean of 6 minutes. What proportion of customers require more than 10 minutes to chec
by the cashier. ally distributed ck out?
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Column1 Canada Mexico Turkey 2000 1.485 9.456 0.625 2001 1.549 9.342 1.226 2002 1.57 9.656 1.507 2003 1.401 10.789 1.501 2004 1.301 11.286 1.426 2005 1.211 10.898 1.344 2006 1.134 10.899 1.428 2007 1.074 10.928 1.303 2008 1.067 11.13 1.302 2009 1.142 13.513 1.55 2010 1.03 12.636 1.503 2011 0.989 12.423 1.675 2012 0.999 13.169 1.796 2013 1.03 12.772 1.904 2014 1.105 13.292 2.189 2015 1.279 15.848 2.72
2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 0 2 4 6 8 10 12 14 16 18 'Canada', 'Mexico', 'Turkey' by 'Field1' Canada Mexico Turkey Axis Title
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
IMPORTANT DETAIL In order to insert a suggestion that uses a PivotTable or formula, your data was organized in c Age Group Field2 15-24 25-29 30-34 35-54 Columbia 17 10.1 10.6 42.5 Brazil 17.9 9.7 11.1 42.4 Egypt 22.3 13.3 11.3 38.8
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
columns with a single header row. 55-64 65+ 12.9 7 13.2 5.7 10 4.3
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Data Age Group Average - 15-24 Average - 25-29 Egypt 22.3 13.3 Brazil 17.9 9.7 Columbia 17 10.1 Total Result 19.06666666667 11.03333333333
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help