Exam 1

33
January 26, 2015 at 10:28 am  •  Posted in s15-busad360 by  •  33 Comments

Part 1 – Take Home Instructions

Download data: exam1_part1

The last digit of your PID determines which column of data you will use for the exam. If your PID ends in 3 your assigned column is “Dataset 3”. If your PID ends in 4 your assigned column is “Dataset 4”. And so on.

Your assigned column has either a 1 or a 0 in each row. You will include each Country listed with a 1 in your assigned column. You can ignore the countries with a 0.

Each country is part one of 3 Mega Regions: (1) the Americas, (2) Europe, Middle East & Africa (EMEA) and (3) Asia Pacific. Use Excel’s “Filter” feature to separate your countries by region.

Gather the GDP Per Capita (x) and Total Fertility Rate (y) data for each assigned country. I have included data from my 10 countries. You may share country data with your classmates by posting a comment or link below. Help each other avoid lots of data entry.

You will analyze data from each of the three regions separately. So, you must complete the following steps 3 times, once for each region.

  1. Create a Scatter plot
  2. Calculate the Pearson Correlation Coefficient (r)
  3. Calculate the slope of the regression line (b1)
  4. Calculate the y-intercept of the regression line (b0)
  5. Produce the resulting regression equation: y = b1*x + b0
  6. Calculate r-squared (r^2)
  7. Produce predicted Total Fertility Rates for 4 hypothetical countries with GDP Per Capita of $10k, $20k, $30k and $40k.

Show all work! Don’t skip steps or I will assume you don’t know what you’re doing!

Bring the Part 1 Take Home work to class on Feb 2nd or 3rd and submit printed copies of your work. Printed copies should be well organized, neat and easy to read! Do you want to be paid like a professional after graduation? Begin producing professional work now!

You may use Excel to complete the Take Home work. You may also complete the work by hand if you prefer. Either way make it legible or your exam score will suffer.

Part 2 will be the in-class exam on Feb 2nd or 3rd.

  • Be prepared to complete similar work by hand.
  • Be prepared to answer questions about your Take Home results.
  • Be prepared for me to ask you to think about and interpret your results.
  • The in-class exam is open book, open notes, open calculator. But not open neighbor.

 

33 Comments

  1. Dylan Lile / January 26, 2015 at 1:09 pm / Reply

    Here is my Blog with 10 countries

    http://wp.me/p5BR2K-4

  2. Morgan Hassan / January 26, 2015 at 2:04 pm / Reply

    Japan $37,000 1.4
    North Korea $1,800 1.98
    China $9,100 1.55
    Philippines $4,700 3.06
    Taiwan $39,600 1.11
    India $4,000 2.51
    Nepal $1,500 2.3
    Pakistan $3,100 2.86
    Russia $18,000 1.61
    Uzbekistan $3,800 1.8

    • Justin / January 26, 2015 at 2:07 pm / Reply

      Thanks Morgan!

  3. Jordan Anderson / January 26, 2015 at 3:29 pm / Reply

    Country GDP (Thousand) Fertility Rate
    Argentina 18.6 2.25
    Belize 8.8 3.02
    Bolivia 5.5 2.8
    Brazil 12.1 1.79
    Canada 43.1 1.59
    Chile 19.1 1.84
    Columbia 11.1 2.07
    Costa Rica12.9 1.91
    Cuba 10.2 1.46
    Ecuador 10.6 2.29
    Guatemala5.3 2.99
    Haiti 1.3 2.79
    Honduras 2.8 2.86
    Mexico 15.6 2.29
    Nicaragua 4.5 1.99
    Panama 16.5 2.38
    Paraguay 6.8 1.96
    Peru 1.11 2.22
    Uruguay 16.6 1.84
    US 52.8 2.01
    Venezuela13.6 2.35

    • Justin / January 26, 2015 at 3:31 pm / Reply

      Thanks, Jordan!

  4. Stephanie Smith / January 26, 2015 at 3:32 pm / Reply

    X-gdp
    Y-fertility
    Australia 43000, 1.77
    Botswana 16400, 2.38
    Chad 2500, 4.68
    Curaçao 15000, 2.09
    Faroe Islands 30500, 2.38
    Guam 28700, 2.38
    Indonesia 5200, 2.18
    Kiribati 6400, 2.56
    Macedonia 10800, 1.59
    Montserrat 8500, 1.29

    • Justin / January 26, 2015 at 3:34 pm / Reply

      Thanks Stephanie!

  5. Cody Martinez / January 26, 2015 at 4:40 pm / Reply

    Here is my 10 countries
    USA – 52.8, 2.01
    Denmark – 37.8, 1.73
    Germany – 39.5, 1.43
    South Africa – 11.5, 2.23
    Peru – 11.1, 2.23
    Ukraine – 7.4, 1.3
    Canada – 43.1, 1.59
    United Kingdom – 37.3, 1.59
    Australia – 43, 1.73
    Japan – 37.1, 1.4

    • Justin / January 26, 2015 at 4:48 pm / Reply

      Thanks Cody!

  6. Alyssa DeVita / January 26, 2015 at 11:43 pm / Reply

    x y
    Venezuela 13.6 2.35
    Afghanistan 1.1 5.43
    Qatar 102.1 1.92
    Sri Lanka 6.5 2.13
    Denmark 37.8 1.73
    Australia 43 1.77
    Greece 23.6 1.41
    Singapore 62.4 0.8
    Somalia 0.6 6.08
    Zimbabwe 0.6 3.56

    • Justin / January 27, 2015 at 10:28 am / Reply

      Thanks Alyssa!

  7. Philip Reynolds / January 27, 2015 at 12:32 am / Reply

    austria 1.43 42600
    australia 1.77 43000
    brazil 1.79 12100
    canada 1.59 43100
    iraq 3.41 7100
    ireland 2 41300
    germany 1.43 39500
    New zealand 2.05 30400
    Jamaica 2.05 9000
    liechtenstein 1.69 89400

    • Justin / January 27, 2015 at 10:29 am / Reply

      Thanks Phillip!

  8. Isaac Ruybal / January 27, 2015 at 10:27 am / Reply

    Fertality PPP Countries
    1.86 55400 Norway
    1.77 43000 Australia
    1.54 54800 Switzerland
    1.78 43300 Netherlands
    2.01 52800 Unites States
    1.43 39500 Germany
    2.05 30400 New Zealand
    1.59 43100 Canada
    0.8 62400 Singapore
    1.73 37800 Denmark

    • Justin / January 27, 2015 at 10:29 am / Reply

      Thanks Isaac!

  9. Alyssa DeVita / January 27, 2015 at 3:56 pm / Reply

    GDP and Fertility Rate
    Costa Rica 12.9 1.91
    Croatia 17.8 1.45
    Cuba 10.2 1.46
    Czech Republic 26.3 1.43
    Denmark 37.8 1.73
    Ecuador 10.6 2.29
    Egypt 6.6 2.87
    Estonia 22.4 1.46
    Ethiopia 1.3 5.23
    Finland 35.9 1.73
    France 35.7 2.08
    Germany 39.5 1.43
    Greece 23.6 1.41
    Guatemala 5.3 2.99
    Haiti 1.3 2.79
    Honduras 2.8 2.86
    Iceland 40.7 1.88
    India 4 2.51
    Indonesia 5.2 2.18
    Iran 12.8 1.85
    Iraq 7.1 3.41
    Israel 36.2 2.62
    Italy 29.6 1.42
    Jamaica 9 2.05
    Japan 37 1.4
    Jordan 6.1 3.16
    Kazakhstan 14.1 2.34
    Kenya 1.8 3.54
    Kyrgystan 2.5 2.68
    Laos 3.1 2.9
    Latvia 19.1 1.35
    Lithuania 22.6 1.29
    Madagascar 1 4.28
    Malaysia 17.5 2.58
    Mexico 15.6 2.29
    Mongolia 5.9 2.22
    Morocco 5.5 2.15
    Namibia 8.2 2.25
    Nepal 1.5 2.3
    Netherlands 43.3 1.78
    New Zealand 30.4 2.05
    Nicaragua 4.5 1.99
    North Korea 1.8 1.98
    Norway 55.4 1.86
    Pakistan 3.1 2.86
    Panama 16.5 2.38
    Paraguay 6.8 1.96
    Peru 11.1 2.22
    Phillipines 4.7 3.06
    Poland 21.1 1.33
    Portugal 22.9 1.52
    Qatar 102.1 1.92
    Russia 18 1.61
    Saudi Arabia 31.3 2.17
    Singapore 62.4 0.8
    South Africa 11.5 2.23
    South Korea 33.2 1.25
    Spain 30.1 1.48
    Sri Lanka 6.5 2.13
    Sweden 40.9 1.88
    Switzerland 54.8 1.54
    Syria 5.1 2.68
    Tajikistan 2.3 2.76
    Tanzania 1.7 4.95
    Thailand 9.9 1.5
    Turkey 15.3 2.08
    Turkmenistan 9.7 2.1
    Uganda 1.5 5.97
    UK 37.3 1.59
    Ukraine 7.4 1.3
    Uruguay 16.6 1.84
    US 52.8 2.01
    Uzbekistan 3.8 1.8
    Venezuela 13.6 2.35
    Vietnam 4 1.85
    Yemen 2.5 4.09

    Hopefully these help the rest of you out.

    • Justin / January 27, 2015 at 3:58 pm / Reply

      Thanks Alyssa!!

  10. Pingback: Review for Exam 1 | Geographical Perspectives

  11. Doug Watterson / January 27, 2015 at 8:55 pm / Reply

    Data Set 4
    Country GDP Per Capita Total Fertility Rate
    Argentina 18.6 2.25
    Australia 4.3 1.77
    Austria 1.43 42.6
    Bangladesh 2.1 2.45
    Belgium 37.8 1.65
    Belize 8.8 3.02
    Bhutan 7 2.02
    Bolivia 5.5 2.8
    Brazil 12.1 1.79
    Burma 1.7 2.18
    Cambodia 2.6 2.66
    Canada 43.1 1.59
    Chad 2.5 4.68
    Chile 19.1 1.84
    China 9.1 1.55
    Columbia 11.1 2.07
    Congo 4.8 4.73
    Costa Rica 12.9 1.91
    Croatia 17.8 1.45
    Cuba 10.2 1.46
    Czech Republic 26.3 1.43
    Denmark 37.8 1.73
    Ecuador 10.6 2.29
    Egypt 6.6 2.87
    Estonia 22.4 1.46
    Ethiopia 1.3 5.23
    Finland 35.9 1.73
    France 35.7 2.08
    Greece 23.6 1.41
    Guatemala 5.3 2.99
    Haiti 1.3 2.79
    Honduras 2.8 2.86
    Iceland 40.7 1.88
    India 4 2.51
    Iran 12.8 1.85
    Iraq 7.1 3.41
    Israel 36.2 2.62
    Jamaica 9 2.05
    Japan 37 1.4
    Jordan 6.1 3.16
    Kenya 1.8 3.54
    Kyrgystan 2.5 2.69
    Laos 3.1 2.9
    Latvia 19.1 1.35
    Libya 11.3 2.07
    Lithuania 22.6 1.29
    Madagascar 1 4.28
    Malaysia 17.5 2.58
    Mexico 15.6 2.29
    Mongolia 5.9 2.22
    Morocco 5.5 2.15
    Namibia 8.2 2.25
    Nepal 1.5 2.3
    Netherlands 43.3 1.78
    New Zealand 30.4 2.05
    Nicaragua 4.5 1.99
    Niger 0.8 6.89
    North Korea 1.8 1.98
    Norway 55.4 1.86
    Pakistan 3.1 2.86
    Panama 16.5 2.38
    Peru 11.1 2.22
    Phillipines 4.7 3.06
    Poland 21.1 1.33
    Qatar 102.1 1.92
    Russia 18 1.61
    Rwanda 1.5 4.62
    Saudi Arabia 31.3 2.17
    Sierra Leone 1.4 4.83
    Singapore 62.4 0.8
    South Africa 11.5 2.23
    South Korea 33.2 1.25
    Spain 30.1 1.48
    Sri Lanka 6.5 2.13
    Sweden 40.9 1.88
    Switzerland 54.8 1.54
    Syria 5.1 2.68
    Tajikistan 2.3 2.76
    Tanzania 1.7 4.95
    Thailand 9.9 1.5
    Turkey 15.3 2.08
    Turkmenistan 9.7 2.1
    Uganda 1.5 5.97
    Ukraine 7.4 1.3
    Uruguay 16.6 1.84
    Uzbekistan 3.8 1.8
    Venezuela 13.6 2.35
    Vietnam 4 1.85
    Yemen 2.5 4.09
    Boom

    • Justin / January 27, 2015 at 10:59 pm / Reply

      Bada Bing, Bada Boom! Way to go, Doug!

  12. Teri Goode / January 27, 2015 at 10:05 pm / Reply

    Here are my 10 Countries:
    Afghanistan $1,100.00 5.43
    Belgium $37,800.00 1.65
    Canada $43,100.00 1.59
    France $35,700.00 2.08
    Germany $39,500.00 1.43
    Iraq $7,100.00 3.41
    Mexico $15,600.00 2.29
    Netherlands $43,300.00 1.78
    United Kingdom $37,300.00 1.9
    United States $52,800.00 2.01

    • Justin / January 27, 2015 at 10:59 pm / Reply

      Thanks Teri!

  13. Paige Proffitt / January 27, 2015 at 10:43 pm / Reply

    Argentina 18,600 2.25
    Belize 8,800 3.02
    Bolivia 5,500 2.8
    Brazil 12,100 1.79
    Canada 43,100 1.59
    Chile 19,100 1.84
    Columbia 11,100 2.07
    Costa Rica 12,900 1.91
    Cuba 10,200 1.46
    Ecuador 10,600 2.29
    Guatemala 5,300 2.99
    Haiti 1,300 2.79
    Honduras 2,800 2.86
    Jamaica 9,000 2.05
    Mexico 15,600 2.29
    Nicaragua 4,500 1.99
    Panama 16,500 2.38
    Paraguay 6,800 1.96
    Peru 1,110 2.22
    Uruguay 16,600 1.84
    US 52,800 2.01
    Venezuela 13,600 2.35

    • Justin / January 27, 2015 at 11:00 pm / Reply

      Thanks, Paige!

  14. Teri Goode / January 27, 2015 at 10:55 pm / Reply

    For everyone in BUSAD 360, here is a link to all 3 of the regions being completely filed out for the countries with a number 1.https://terigoode.wordpress.com/2015/01/28/all-of-data-set-2/

    • Justin / January 27, 2015 at 11:00 pm / Reply

      Thank you Teri!!

  15. Jeff Fitzsimmons / January 28, 2015 at 1:23 pm / Reply

    Dataset 6

    Americas
    Argentina 18.6 2.25
    Belize 8.8 3.02
    Bolivia 5.5 2.8
    Brazil 12.1 1.79
    Canada 43.1 1.59
    Chile 19.1 1.84
    Columbia 11.1 2.07
    Costa Rica 12.9 1.91
    Cuba 10.2 1.46
    Ecuador 10.6 2.29
    Guatemala 5.3 2.99
    Haiti 1.3 2.79
    Honduras 4.8 2.86
    Jamaica 9 2.05
    Mexico 15.6 2.29
    Nicaragua 4.5 1.99
    Panama 16.5 2.38
    Paraguay 6.8 1.96
    Peru 11.1 2.22
    Uruguay 16.6 1.84
    US 52.8 2.01
    Venezuela 13.6 2.35

    Asia Pacific
    Afghanistan 1.1 5.43
    Australia 43 1.77
    Bangladesh 2.1 2.45
    Bhutan 7 2.02
    Burma 1.7 2.18
    Cambodia 2.6 2.66
    China 9.8 1.55
    India 4 2.51
    Indonesia 5.2 2.18
    Japan 37.1 1.4
    Kazakhstan 14.1 2.34
    Kyrgystan 2.5 2.68
    Laos 3.1 2.9
    Malaysia 17.5 2.58
    Mongolia 5.9 2.22
    Nepal 1.5 2.3
    North Korea 1.8 1.98
    Pakistan 3.1 2.86
    Phillipines 4.7 3.06
    Russia 18.1 1.61
    Singapore 62.4 0.8
    South Korea 33.2 1.25
    Sri Lanka 6.5 2.13
    Thailand 9.9 1.5
    Turkmenistan 9.7 2.1
    Ukraine 7.4 1.3
    Uzbekistan 3.8 1.8
    Vietnam 4 1.85

    EMEA
    Algeria 7.5 2.78
    Austria 42.6 1.43
    Belgium 37.8 1.65
    Chad 2.5 4.68
    Croatia 17.8 1.45
    Czech Republic 26.3 1.43
    Denmark 37.8 1.73
    Egypt 6.6 2.87
    Estonia 22.4 1.46
    Ethiopia 1.3 5.23
    Finland 35.9 1.73
    France 35.7 2.08
    Germany 39.5 1.43
    Greece 23.6 1.41
    Iceland 40.7 1.88
    Iran 12.8 1.85
    Iraq 7.1 3.41
    Israel 36.2 2.62
    Italy 29.6 1.42
    Kenya 1.8 3.54
    Latvia 19.1 1.35
    Libya 11.3 2.07
    Lithuania 22.6 1.29
    Madagascar 1 4.28
    Morocco 5.5 2.15
    Namibia 8.2 2.25
    Netherlands 43.3 1.78
    Niger 0.8 6.89
    Nigeria 2.8 5.25
    Portugal 22.9 1.52
    Qatar 102.1 1.92
    Saudi Arabia 31.3 2.17
    Sierra Leone 1.4 4.83
    South Africa 11.5 2.23
    Spain 30.1 1.48
    Sweden 40.9 1.88
    Switzerland 54.8 1.54
    Syria 5.1 2.68
    Tanzania 1.7 4.95
    Turkey 15.3 2.08
    Uganda 1.5 5.97
    UK 37.3 1.9
    Yemen 2.5 4.09

    • Justin / January 28, 2015 at 1:53 pm / Reply

      Thanks a lot, Jeff!

  16. Jordan Borrego / January 29, 2015 at 3:10 pm / Reply

    HERE IS THE COMPLETELY FILLED OUT EXCEL SPREADSHEET OF TAKE HOME EXAM PT 1 REGARDLESS OF WHAT CATEGORY YOU ARE SELECTED TO DO. Enjoy.
    https://jordanborrego.files.wordpress.com/2015/01/exam-pt-1-all-data.xlsx

    • Justin / January 29, 2015 at 3:55 pm / Reply

      King Jordan!

    • Josh Croy / January 31, 2015 at 12:21 pm / Reply

      You’re the MAN!

  17. Pingback: Lesson 11 | Geographical Perspectives

Leave a Reply