Assignment 4 - Crosstabulations Due: November 02, 2021 Be sure to check out the general guide for IS600 Assignments (front page of the Assignments section of the Bb page). Also, for this week examine the guide writing up statistics problems (not all of these will be relevant this first week). Review the assignment file background material and resources on descriptive statistics. Crosstabulations: Development and Refugee Hosting This assignment is about using crosstabulations to evaluate comparative data. It uses the "HDI and Refugees" dataset in the Datasets folder on Bb. Despite public perceptions about forced migrants in the Global North, the vast majority of refugees (over 80% according to UNHCR) are hosted in the Global South, often very close to their country of origin. The dataset for this assignment is a compilation of the Human Development Index (HDI) and UNHCR population numbers for various categories of forced migrants for 2018. Use the crosstabulation analysis to assess the relationship between development as indexed by the HDI and the number of: 1. Refugees in a host country 2. Asylum seekers in a host country 3. Internally Displaced Persons (IDPs) In each case, you will need to set up a dichotomous variable (0, 1) to determine "a lot" and "not a lot" for each of the variables. Be sure to justify where you establish your cut-off value to be. Your goal is to use these statistics to answer the following questions: ? What is your a priori expectation about the relationship between development and refugee hosting? ? Do developing countries carry the burden of refugee and/or asylum-seeker hosting compared to developed countries? ? Can you statistically determine if your a priori expectations are correct? ? What is the relationship between IDPs and development? ? Do you think there are missing variables to better explain the relationship between IDPs and development? What might they be? Be sure to explain the limitations of your approach and analysis. As you work on the assignment, it is important to think about what data is there and what is missing, and what that means for your analysis. As always, a compelling narrative is an important part of your grade. Extra points for creative use of graphics in your analysis to help make your analysis clearer.
File Home Insert Draw Degn Search the Web or - a URL Assignment (continuation) a Protected View a Saved to this PC ' )3 AYODELE Layout References Mailings Review View Help Soda PDF 11 Creator PROTECTED VIEW Be carefulfiles from the Intemet can contain viruses. Unless you need to edit, it's safer to stay in Protected View. Enable Editing Page 1 OH 254 words n ,0 Type here to search What is your a priori expectation about the relationship between development and refugee hosting? The crosstabulation analysis compares the different independent categorical data of development between Refugees in a host country, Asylum seekers in a host country, and Internally Displaced Persons (IDPs). It uses a set of dichotomous coding variables of as 1- 'a lot' and 0 lnot a lot ' for each of the independent variable set. The analysis is to determine the significant difference from the observed frequency and the expected frequencies. 1.our prior expectation before conducting the chi-test was that there is about a relationship between Human development Index and refugee hosting. This group's priori expectation was that the more developed the country, in terms of health, life expectancy, average years of schooling, and income were related to refugee hosting, meaning, they were better equipped to handle the overall absorption of refugees. Therefore, there would likely be more refugees in countries with greater development. For question 1 we used the Mean of 1218012695 ofthe refugees in host country and mean of [1713470899 ofthe HDI held constant to evaluate the whole column of refugees in host country and HDI respectively in the categorical data coding. as our logical test number as the constant variable in our Our Hypothesis testing as stated below and used the media as our H0 There is no difference between HDI and refugees under UNHCR mandate H1 There is a difference between HDI and refugees under UNHCR mandate Combined Observed and expected frequencies Refugee HDI X A O Search the Web or type a URL... ... AutoSave . Off ) HDI and Refugees-Assignment #4 - Protected View Search AYODELE A O X File Home Insert Draw Page Layout Formulas Data Review View Help Soda PDF 11 Creator Share Comments i PROTECTED VIEW Be careful-files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View. Enable Editing X F2 X V fx A B C D E F G 4 HDI Rank Country of Asylum HDI Refugees under UNHCRaEMs mar Asylum-seekers IDPS of concern to UNHCR Venezuelans displaced abroad Stateless 170 Afghanistan 0.496 72228 280 2106893 69 Albania 0.791 132 161 O O 82 Algeria 0.759 94341 8907 36 Andorra 0.857 10 00 149 Angola 0.574 39856 30127 0 10 74 Antigua and Barbuda 0.776 11 48 Argentina 0.83 3442 6105 127152 12 81 Armenia 0.76 17966 106 13 6 Australia 0.938 56934 60634 wooo 14 20 Austria 0.914 128779 37345 15 87 Azerbaijan 0.754 1130 207 620423 16 60 Bahamas 0.805 14 22 17 45 Bahrain 0.838 262 58 18 135 Bangladesh 0.614 906640 39 19 56 Barbados 0.813 0 5 oo oo oo OO 20 50 Belarus 0.817 2225 184 21 17 Belgium 0.919 42158 19550 22 103 Belize 0.72 29 3305 23 163 Benin 0.52 1167 308 24 134 Bhutan 0.617 25 114 Bolivia (Plurinational State of) 0.703 302 36 O Human Development Index (HDI) Dataset #1 Crosstabs for Dataset #1 Dataset #2 Crosstab ... + 4 Ready - - + 100% w ? 9:40 AM Type here to search O EF T X 11/1/2021O Search the Web or type a URL... ... AutoSave . Off ) HDI and Refugees-Assignment #4 - Protected View Search AYODELE A O X File Home Insert Draw Page Layout Formulas Data Review View Help Soda PDF 11 Creator Share Comments i PROTECTED VIEW Be careful-files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View. Enable Editing X J12 X V fx A B C D E F G H K M Mean Median Middle of the Range Coding HDI 0.713470899 0.728 0.0726 1=a lot - W N - Refugees in host country 121801.2695 4531 1,840,844 0=not a lot 5 Country of Asylum HDI Refugees under UNHCRaEMs mandate Refugee Dichot HDI Dichotomy Afghanistan 0.496 72228 O 7 Albania 0.791 132 8 Algeria 0.759 94341 9 Andorra 0.857 oo oo OO 10 Angola 0.574 39856 11 Antigua and Barbuda 0.776 12 Argentina 0.83 3442 13 Armenia 0.76 17966 14 Australia 0.938 56934 15 Austria 0.914 128779 16 Azerbaijan 0.754 1130 17 Bahamas 0.805 14 O O O HOO O HOO 18 Bahrain 0.838 262 19 Bangladesh 0.614 906640 20 Barbados 0.813 21 Belarus 0.817 2225 22 Belgium 0.919 42158 Human Development Index (HDI) Dataset #1 Crosstabs for Dataset #1 Dataset #2 Crosstab ... + : 1 Ready - - + 100% 9:40 AM Type here to search O T w X ? 11/1/2021O Search the Web or type a URL... ... AutoSave . Off ) HDI and Refugees-Assignment #4 - Protected View Search AYODELE A O X File Home Insert Draw Page Layout Formulas Data Review View Help Soda PDF 11 Creator Share Comments PROTECTED VIEW Be careful-files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View. Enable Editing X L21 X V fx B C D E F G H K L M N O P Q R S 0 1 Grand Total 67 17 84 93 12 105 160 29 189 10 00 - 10 11 Refugee Combined Observed and expected frequencies 12 0 1 Refugee HDI 13 71.1111111 12.888889 Observed Expected Observed Expected 14 88.8888889 16.111111 0 67 71.11 17 12.88 15 93 88.8 12 16.11 16 17 Refugee 18 0 1 19 0.23767361 1.3113027 20 0.19013889 1.0490421 21 22 Chai Square 2.78815733 23 Degrees of F 24 P-Value 0.90503663 25 Human Development Index (HDI) Dataset # 1 Crosstabs for Dataset #1 Dataset #2 Crosstab ... + 4 Ready - - + 100% Type here to search O w X ? 9:40 AM call's 11/1/2021O Search the Web or type a URL... ... AutoSave . Off ) HDI and Refugees-Assignment #4 - Protected View Search AYODELE A O X File Home Insert Draw Page Layout Formulas Data Review View Help Soda PDF 11 Creator Share Comments i PROTECTED VIEW Be careful-files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View. Enable Editing X H58 X V fx A B C D E F G H Mean Median Middle of the Range HDI 0.713471 0.0728 0.0726 UA W N - Asylum-seekers 20857.65269 982 359494 Country of Asylum HDI Asylum-seekers HDI Dichotomy Asylum Seeker Dichotomy Afghanistan 0.496 280 o O 7 Albania 0.791 161 8 Algeria 0.759 8907 9 Andorra 0.857 HOPPY 10 Angola 0.574 30127 11 Antigua and Barbuda 0.776 12 Argentina 0.83 6105 13 Armenia 0.76 106 14 Australia 0.938 60634 15 Austria 0.914 37345 OO O O O O O H H O O O H O O 16 Azerbaijan 0.754 207 17 Bahamas 0.805 22 18 Bahrain 0.838 58 19 Bangladesh 0.614 39 20 Barbados 0.813 5 21 Belarus 0.817 184 22 Belgium 0.919 19550 Human Development Index (HDI) Dataset # 1 Crosstabs for Dataset #1 Dataset #2 Crosstab ... + : 4 Ready - - + 100% 9:45 AM Type here to search O T w X v ? 11/1/2021O Search the Web or type a URL... ... AutoSave . Off ) HDI and Refugees-Assignment #4 - Protected View Search AYODELE A O X File Home Insert Draw Page Layout Formulas Data Review View Help Soda PDF 11 Creator Share Comments i PROTECTED VIEW Be careful-files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View. Enable Editing X B13 X v fx =(GETPIVOTDATA("Asylum Seeker Dichotomy",$A$3,"Asylum Seeker Dichotomy",0)/GETPIVOTDATA("Asylum Seeker Dichotomy",$A$3)) *GETPIVOTDATA("Asylum v A B C D E F G 16 17 Statistic Difference 18 Count of Asylum Seeker Dichotomy HDI 19 Asylum Seeker 20 0 0.212673611 0.170138889 21 1 1.173371648 0.938697318 22 23 CHI SQUARE 2.49488147 24 Degrees of Freedom 25 P-Value 0.88578302 26 27 28 FAIL TO REJECT 29 30 31 32 33 34 35 36 37 ... Dataset #1 Crosstabs for Dataset #1 Dataset #2 Crosstabs for Dataset #2 Dataset #3 Cro ... + : 4 Ready - - + 100% Type here to search O w ? 9:45 AM ( ' ) 11/1/2021O Search the Web or type a URL... ... AutoSave . Off ) HDI and Refugees-Assignment #4 - Protected View Search AYODELE A O X File Home Insert Draw Page Layout Formulas Data Review View Help Soda PDF 11 Creator Share Comments i PROTECTED VIEW Be careful-files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View. Enable Editing X E13 X V fx =IF(C13>=$D$3,1,0) A B C D E F G H Mean Median Middle of the Range W N - HDI 0.713471 0.0728 0.0726 IDPS of concern of UNHCR 232198.6048 0 3908237 UT Country of Asylum HDI IDPS of concern to UNHCR HDI Dichotomy IDP Dichotomy Afghanistan 0.496 2106893 7 Albania 0.791 8 Algeria 0.759 O 9 Andorra 0.857 10 Angola 0.574 O 11 Antigua and Barbuda 0.776 12 Argentina 0.83 13 Armenia 0.76 ooo O 14 Australia 0.938 O O O O O O H O O O O O O O O O H 15 Austria 0.914 16 Azerbaijan 0.754 620423 17 Bahamas 0.805 18 Bahrain 0.838 19 Bangladesh 0.614 oo oo OO 20 Barbados 0.813 21 Belarus 0.817 22 Belgium 0.919 ... Dataset #1 Crosstabs for Dataset # 1 Dataset #2 Crosstabs for Dataset #2 Dataset #3 Cro ... + : 4 Ready - - + 100% 9:46 AM Type here to search O T W > ? 11/1/2021O Search the Web or type a URL... ... AutoSave . Off ) HDI and Refugees-Assignment #4 - Protected View Search AYODELE A O X File Home Insert Draw Page Layout Formulas Data Review View Help Soda PDF 11 Creator Share Comments PROTECTED VIEW Be careful-files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View. Enable Editing X G8 X V fx A B D E F G H - 2 Observed 3 Count of IDP Dichotomy HDI Y 4 IDP Y 0 1 Grand Total 5 0 72 101 173 6 1 12 16 7 Grand Total 84 105 189 00 9 10 Expected 11 Count of IDP Dichotomy HDI 12 IDP 0 1 13 0 76.88888889 96.11111111 14 1 7.111111111 8.888888889 15 16 17 18 19 20 Statistics (Difference) 21 Count of IDP Dichotomy HDI 22 IDP 0 ... Dataset #2 Crosstabs for Dataset #2 Dataset # 3 Crosstabs for Dataset #3 HDI Macro UNI ... + Ready - - + 100% Type here to search O T W ? 9:46 AM ( ' ) 11/1/2021O Search the Web or type a URL... ... AutoSave . Off ) HDI and Refugees-Assignment #4 - Protected View Search AYODELE A O X File Home Insert Draw Page Layout Formulas Data Review View Help Soda PDF 11 Creator Share Comments i PROTECTED VIEW Be careful-files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View. Enable Editing X A25 X V fx A B C D E F G H J K L M N 1 Human Development Very high human development 0.892 High human development 0.75 Medium human development 0.634 Low human development 0.507 6 Developing Countries 0.686 7 Regions 8 Arab States 0.703 East Asia and the Pacific 0.741 10 Europe and Central Asia 0.779 11 Latin America and the Caribbean 0.759 12 South Asia 0.642 13 Sub-Saharan Africa 0.541 14 Least Developed Countries 0.528 15 Small Island Developing States 0.723 16 Organization for Economic Co-operation and Development 0.895 17 World 0.731 18 19 20 21 22 > ... Crosstabs for Dataset #2| Dataset #3 Crosstabs for Dataset #3 HDI Macro UNHCR - no HDI + : 1 Ready - - + 100% Type here to search O T w X ? 9:46 AM ( " ) 11/1/2021O Search the Web or type a URL... ... AutoSave . Off ) HDI and Refugees-Assignment #4 - Protected View Search AYODELE A O X File Home Insert Draw Page Layout Formulas Data Review View Help Soda PDF 11 Creator Share Comments i PROTECTED VIEW Be careful-files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View. Enable Editing X F18 X v fx A B D E F H K L M N O P Q R S 1 Country o Country o' Refugees Asylum-se IDPs of co Venezuela Stateless Others of concern 2 Aruba ABW 408 15602 O OC W Cayman Is CYM 34 27 O o O 4 Curacao CUW 99 341 25686 5 Eswatini SWZ 874 739 ooo oo Monaco MCO 25 0 ooo o O 7 Nauru INRU 964 417 Sint Maari SXM 0 O ooo 9 Somalia SOM 16738 16361 2648001 38 10 Turks and TCA 5 0 0 O 11 12 13 14 15 16 17 18 19 Dropbox X 20 Screenshot Added 21 22 A screenshot was added to your Dropbox. > ... Crosstabs for Dataset #2 Dataset #3 Crosstabs for Dataset #3 HDI Macro UNHCR - no HDI + : 1 Ready TOU% 9:46 AM Type here to search O w ? 11/1/2021O Search the Web or type a URL... ... AutoSave . Off ) HDI and Refugees-Assignment #4 - Protected View Search AYODELE A O X File Home Insert Draw Page Layout Formulas Data Review View Help Soda PDF 11 Creator Share Comments i PROTECTED VIEW Be careful-files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View. Enable Editing X F18 X v fx A B D E F H K L M N O P Q R S 1 Country o Country o' Refugees Asylum-se IDPs of co Venezuela Stateless Others of concern 2 Aruba ABW 408 15602 O OC W Cayman Is CYM 34 27 O o O 4 Curacao CUW 99 341 25686 5 Eswatini SWZ 874 739 ooo oo ooo o O Monaco MCO 25 0 7 Nauru INRU 964 417 Sint Maari SXM 0 O ooo 9 Somalia SOM 16738 16361 2648001 38 10 Turks and TCA 5 0 0 O 11 12 13 14 15 16 17 18 19 20 21 22 > ... Crosstabs for Dataset #2 Dataset #3 Crosstabs for Dataset #3 HDI Macro UNHCR - no HDI + : 1 + 100% Ready - - 9:47 AM Type here to search O w ? ( " ) F 11/1/2021