Afghan Data Set Part 2 ( data set is attached below)

The data for the remaining questions come from story by James A.

Piazza (2012) that was the source of the data (attached below)

However, now we are going to consider the following set of variables:

mortality : under 5 mortality (per 1000).

we are going to treat this variable as the response.

opium : average opium cultivation (hectares).

pop : population in thousands.

area : area of province (1000 km).

mountains : percentage of province that is mountainous.

literacy : literacy rate.

water : percentage of population with access to safe drinking water.

calories : percentage of population below median caloric intake level.

roads : percent of roads categorized as \all season."

pashtun Pashtun ethnic majority.

1 = yes 0 = no

troops average number of foreign troops (per year).

1. Fit an initial model that relates the response (mortality) to all of the remaining variables.

Use an Normal regression model (although the response is a rate because it involves large

counts the Normal model should work quite well).

2. Find the variance inflation factors and comment on whether or not multicollinearity is an

issue for this data

--------------------------------------------------------

afghan2 data set as the below

===============================================================

opium pop area mountains literacy water calories roads mortality pashtun troops

Badakhshan 5733 739.4 44.1 75.7 25 13 40 25 210 0 1225

Bagdis 779 499.4 20.6 43.7 9 15 40 33 300 0 1000

Baghlan 784 741.7 21.1 38.2 20 19 33 42 300 0 1225

Balkh 2058 1123.9 17.3 42 37 31 33 38 230 0 1225

Bamiyan 89 343.9 14.2 77.5 24 8 25 21 270 0 4256.2

Daykundi 2655 477.5 18.1 89.7 16 3 52 7 300 0 5193.7

Farah 3731 493 48.5 39.2 15 37 17 49 200 1 1000

Faryab 816 833.7 20.3 33.7 18 23 27 43 250 0 1225

Ghazni 25 1080.8 22.9 41 29 35 25 38 240 1 4256.2

Ghor 1322 635.3 36.5 68.9 15 14 23 12 260 0 1000

Helmand 40572 1441.8 58.6 15.8 4 28 49 62 190 1 5193.7

Heart 593 1762.2 54.8 25.4 29 31 33 56 180 0 1000

Jowzjan 727 427 11.8 22.4 27 24 19 45 250 0 1225

Kabul 119 331.4 4.5 34.6 57 65 24 68 155 1 1225

Kandahar 6538 913 54 2.6 13 64 33 77 200 1 3593.7

Kapisa 193 358.3 1.8 37 32 27 9 58 240 0 4256.2

Khost 65 638.8 4.2 47.4 23 34 28 59 240 1 4256.2

Kunar 713 413 4.9 78.7 27 24 9 39 190 1 4256.2

Kunduz 78 820 8 3.7 22 25 26 68 270 1 1225

Laghman 524 382.3 3.8 42.2 12 39 42 61 270 1 4256.2

Logar 15 322.7 3.9 21.3 17 45 27 78 190 1 4256.2

Nangahrar 15159 1324.5 7.7 35.7 27 43 25 54 180 1 4256.2

Nimruz 1253 118 41 0 15 38 66 61 210 0 5193.7

Nurestan 536 131 9.2 96.6 14 2 40 10 270 0 4256.2

Oruzgan 5733 320.6 12.7 47.2 7 8 38 61 300 1 5193.7

Paktia 89 415 6.4 47.4 15 34 28 59 240 1 4256.2

Paktika 0 809.8 19.5 31.9 2 28 42 33 220 1 4256.2

Panjshir 0 128.6 3.6 77.8 27 16 11 33 220 0 4256.2

Parwan 96 491.9 6 56.8 30 32 9 61 250 0 4256.2

Samangan 559 378 11.3 58.8 13 7 12 28 250 0 1225

Sar-ePol 595 442.3 16.4 14.2 11 45 46 12 260 0 1225

Takhar 542 830.3 12.2 33.3 12 29 26 43 250 0 1225

Wardak 75 529.3 9.9 63.4 21 22 41 27 180 1 4256.2

Zabul 1062 244.9 17.3 22.7 1 38 38 39 260 1 5193.7

=====================================================

Thank you for your help in advance