Link to Excel file: https://docs.google.com/spreadsheets/d/1C8LsAuyh88aFBgRBHzdEWS9nn2s1TWxA/edit?usp=sharing&ouid=105516676307893631899&rtpof=true&sd=true

QUESTION 1 Q01. Use "Countries of the World" dataset for this assessment. Construct a frequency distribution of Region. How many countries belong to the region "SUB-SAHARAN AFRICA"? O 51 O 50 O 49 05 QUESTION 2 Q02. Perform ANOVA analysis to test the hypothesis that mean per capita GDP is the same across all 11 regions. The observed and critical values of the test statistic for this analysis are _ and _ respectively. O 29.71, 4.8E-35 O 29.71, 1.88 4.8E-35, 1.88 1.88, 29.71 QUESTION 3 Q03. Based on the ANOVA test, the correct conclusion is Fail to reject the null hypothesis. Not all group means are equal. O Reject the null hypothesis. Not all group means are equal. O Reject the null hypothesis. The group means are all equal. O Fail to reject the null hypothesis. The group means are all equal.QUESTION 10 Q10. Report the R square value and its interpretation from the ANOVA analysis. O 0.04%; This is the proportion of variation in GDP per capita that is explained by Area2 O 4.41%; ; This is the proportion of variation in Area2 that is explained by GDP per capita O 0.04%; ; This is the proportion of variation in Area2 that is explained by GDP per capita O 4.41%; This is the proportion of variation in GDP per capita that is explained by Area2QUESTION 4 Q04. Get the sub-sample of all countries which have "land" at the end of their names [use column labeled "last4" in the data file]. The total number of countries in this group is 0 8 O 10 O7 09 QUESTION 5 Q05. Get the sub-sample of all countries which have "stan" at the end of their names [use column labeled "last4" in the data file]. The total number of countries in this group is _ 0 9 O 8 O 10 O7 QUESTION 6 Q06. Variable "Group" in the data file is based on the following rules: Group = 1 if the last four letters of a country's name are "stan" Group =2 if the last four letters of a country's name are "land" Group 3 = all other countries Perform ANOVA analysis with Infant Mortality as the dependent variable and Group as independent variable. Use values from Group 1 and Group 2 only. Ignore Group 3 from this analysis. The observed and critical values of the test statistic in this model are and _ respectively. O 4.60, 14.05 O 0.002, 4.60 O 14.05, 4.60 O 14.05, 0.002QUESTION 7 Q07. Based on the ANOVA test, the correct conclusion is O Fail to reject the null hypothesis. The group means are all equal. O Reject the null hypothesis. Not all group means are equal. O Fail to reject the null hypothesis. Not all group means are equal. O Reject the null hypothesis. The group means are all equal. QUESTION 8 Q08. Variable "Area2" in the data file is based on the following rules: Area2 = Low, if the country is one of the 70 smallest countries with respect to Area Area2 = High, if the country is one of the 70 largest countries with respect to Area Area2 = Medium, for all other countries Perform ANOVA analysis with GDP per capita as the dependent variable and Area2 as independent variable. The observed and critical values of the test statistic in this model are _ and respectively. O 3.04, 5.01 O 0.007, 3.04 O 5.01, 3.04 5.01, 0.007 QUESTION 9 Q09. Based on the ANOVA test, the correct conclusion is O Reject the null hypothesis. The group means are all equal. Fail to reject the null hypothesis. The group means are all equal. Fail to reject the null hypothesis. Not all group means are equal. O Reject the null hypothesis. Not all group means are equal