Question #2: T-Tests for Dependent/Independent Samples In the Brightspace Site for the Class - go to the content area for Assignments, and the folder for Assignment 2. Open again the file called "Data_Assignment2_1" (i.e. the same file as above) in Excel, and complete the following questions. There are 21 Points Total available. 2a) [6 Points]: Using the full dataset, sort and limit the dataset to year 2020 and 2000. Using the female labor force participation rate variable, test the hypothesis that average female labor force participation differs for year 2020 versus year 2000. (i) [4 Points]: Write out your null hypothesis and two-tailed research hypothesis (mathematically) for this test, evaluate the test, and report your results, including your p-value and the Confidence Level at which you draw any conclusions. (ii) [2 Points]: Report the precise level of Type I Error that you would incur, should you reject the null hypothesis in the test above. 2b) [10 Points]: Continue to sort and limit the data set to only year 2020. Now, test the hypothesis that the population growth differs by high-income countries and low-income countries. The relevant variables in this case are "Annual Population Growth (%)" and "Income Group" (coded "1" = Low Income Countries, "2" = Lower Middle-Income Countries, "3" = Upper Middle-Income Countries and "4" = High Income Countries){iii} [3 Points]: Write out your null and research hypothesis for a two-tailed test {mathematically}, and report your results, p-value, and the Confidence Level at which you draw any conclusions. {iv} [3 Point]: Write our your null and research hypothesis for a one-tailed test [mathematically and being sure to investigate your descriptive statistics before deciding on the direction ofyour research hypothesis}. Reference the relevant results from part {i} you should not need to recalculate the test results -- and report your new p-value and the Condence Level at which you draw any conclusions for the one-tailed test. {v} [4 Points]: Does your conclusion change when you compare high income countries with upper middle-income countries? Explain your answer. 2:] [5 Points]: Using the full dataset, test the hypothesis that the unemployment rate differs by upper income countries and middle-income countries. He sure to write both your null and research hypothesis mathematically and evaluate this for a two-tailed test reporting your results, p-value, and the condence level at which you draw and conclusions. Note that the relevant variables are \"Annual Population Growth (95)\" and \"Income Group\" coded (\"1\" = Low-Income Countries, \"2\" = Lower lvliddle- lncome Countries, "3\" = Upper Middle-Income Countries and \"4\" = High-Income Countries}