DCSI Final Report

pdf

School

University of North Texas *

*We aren’t endorsed by this school

Course

3710

Subject

Statistics

Date

Feb 20, 2024

Type

pdf

Pages

Uploaded by SargentIceFerret34

Final Report - Kirsten Haddox Please view the excel data sheet here: Global Stats for Women Education 1 First Question: Is the percentage of women completing primary education in Switzerland following a normal distribution from 1990-2020? First Hypothesis: “ The percentage of women completing primary education in Switzerland follows a normal distribution from 1990-2020.” Mean μ = 87.323 ; Standard Deviation σ = 16.407 The equation I am using: Based on the scatter plot above, we can see that the data points do not fall in a straight line, therefore, the percentage of women completing primary education in Switzerland does not follow a normal distribution. Second Question: What is the 95% confidence interval for the average percentage of women who have completed primary education globally in 2020? Second Hypothesis: The average percentage of women completing primary education globally over the past decade is within a 95% confidence interval Mean = 90.789; Sample Size = 170; Standard Deviation = 14.2548 1 World Bank Open Data . (n.d.-b). World Bank Open Data. https://data.worldbank.org/indicator/SE.PRM.CMPT.FE.ZS?locations=1W&start=1973&view=chart

The equation I am using: 95% confidence interval = (69.7497, 71.8283) Please see the Excel data sheet titled “Switzerland + Low Income Data” for Question 3. Third Question: Is there a statistically significant difference in the percentage of women completing primary education between Switzerland and low income countries from 1990-2020? Third Hypothesis: There is a statistically significant difference in the percentage of women completing primary education between Switzerland and low income countries from 1990-2020. Type Switzerland Low-Income Mean 87.324 46.765 Standard Deviation 16.407 11.096 Sample Size 30 30 t = 11.4011; two-tailed P-value is less than 0.0001 The degrees of freedom for a two-sample t-test is df = n1+n2-2=30+30-2=58 Based on the scatter plot above, we can see that the data points do not fall in a straight line, therefore, there is a statistically significant difference in the percentage of women completing primary education between Switzerland and low income countries from 1990-2020. Due to the P-value being less than 0.0001, the difference is also considered statistically significant. We reject the null hypothesis and conclude that the alternative hypothesis is correct.

Please see the Excel data sheet titled “Women in Switzerland Education” for Question 4. Question 4: What is the average predicted percentage of women completing primary school in Switzerland? Based on two predictor variables: the average number of extra curricular activities and the average GPA. Question 4 Hypothesis: The average predicted percentage of women completing primary school in Switzerland is 92%. ● Women completing primary school= b 0+ b 1 ×Avg. Number of Extra Curriculars+ b 2 ×Average GPA ● Women completing primary school=70.64+1.58×2.19+4.35×4.01 The average predicted percentage of women completing primary school in Switzerland is 91.57%.

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

Appendix Problem 1: Is the percentage of women completing primary education in Switzerland following a normal distribution from 1990-2020? I plugged the given data into a normal distribution equation as well as a scatter plot. Based on my findings and the data not falling into a straight line, I concluded that it does not fall into a normal distribution. Problem 2: What is the 95% confidence interval for the average percentage of women who have completed primary education globally in 2020? I found the mean, sample size, and standard deviations for all country data points of women completing primary education in 2020. I plugged these variables into a confidence interval equation to get the 95% confidence interval. Problem 3: Is there a statistically significant difference in the percentage of women completing primary education between Switzerland and low income countries from 1990-2020? I found the data for percentage of women in Switzerland and Women in low income countries completing primary education each year from 1990-2020. I found the mean, sample size, and standard deviations and plugged them into a t-test equation as well as created a scatter plot. Based on the scatter plot showing a significant difference between the two datasets as well as the P-value being less than 0.0001, the difference is considered statistically significant between Switzerland and low-income countries.

The degrees of freedom for a two-sample t-test is df = n1+n2-2=30+30-2=58 Question 4: What is the average predicted percentage of women completing primary school in Switzerland? Based on two predictor variables: the average number of extra curricular activities and the average GPA. I plugged the given variables in the data sheet into a multiple regression equation: Women completing primary school= b 0+ b 1 ×Avg. Number of Extra Curriculars+ b 2 ×Average GPA Avg. Number of Extra Curriculars = 2.19 Avg. GPA (out of 6 for Switzerland grading scale) = 4.01 Women completing primary school=70.64+1.58×2.19+4.35×4.01 After plugging in variables and and computing the equation, I found the average predicted percentage of women completing primary school in Switzerland is 91.57%.