Kindly Interpret the data and write in a paragraph:

Paragraph (address the claim about the proportion):

oSummary of sample statistics (x, n, and p)

oConfidence interval, along with interpretation of the confidence interval

oDescription of hypothesis test (alpha, test statistic, p-value, conclusion, interpretation)

_____________________________________________________

The first claim was that online bachelor's students are working adults and the average online student is 32 years old.

The second claim was that the majority of bachelor's online students are female, and only 35% are male.

_____________________________________________________

The excel sheet shows a given sample of 25 (my class), and the calculations were to test those two claims above from this article: https://www.usnews.com/higher-education/online-education/articles/2017-04-04/us-news-data-the-average-online-bachelors-student

Now, a short report should be written with an interpretation (no bullet points) of the data I got in excel.

A B C D E F G H K L M N 0 P Q R S T U For the following questions, use only the "age" column: Age Gende Points Age Frequency Distribution: Class Width 21 M Data for ogive 22 F Class Limits Relative Cumulative Class Limits 22 F Low High Midpoint Freq. Frequency Relative Freq 21-27 52 23 F Limits 21 27 24 13 0.52 0.52 28-34 80 23 F Freq. 28 34 31 0.28 0.80 35-41 80 24 M Mid. 35 41 38 0 0.00 0.80 24-48 96 24 F RF 42 48 45 4 0.16 0.96 49-55 100 24 M CE 40 65 1 0.04 1.00 IN M 25 Mean 30.8 26 NNN Median 27 26 M Sample Standard deviation: 9.2240627 9.22 27 F Q1 24 29 F 03 33 31 M 32 F 32 M Dgive: Ogive: Polygon: 33 F Polygon 33 M Ogive Frequency polygon F 43 F 120 14 45 M Total: 25 100 12 46 F 47 F 10 54 F 60 6 40 20 2 35--41 24-48 49-55 38 21-27 31 28-34 24 45 52 Week 3 Week 5 Week 6 + Microsoft AutoUpdateA C D E F G H K L M P Q 1 Age Gender Points 95% Confidence Interval for Average Age of Online College Students: 21 M 22 F Sample Mean: 30.8 22 F Sample St. Dev: 9.224063 23 F 1 Sample Size: 25 23 F 24 M 2 Distribution: T-Distribution 24 F Round 24 M 2 Critical Value: 2.064 2.06 10 25 M 11 25 F 2 Margin of Error: 3.8077 3.81 Calculation: 2.064 x 9.224063/V25 12 26 F Lower Bound 26.9923 26.99 Calculation: 30.8-3.8077 13 26 M Upper Bound: 34.6077 34.61 Calculation: 50.8 +3.8077 14 27 F 15 29 F 16 31 M 2 Interpret Weare 95% confident the age of online college students is between 26.99 and 34.61 32 F 18 32 M 95% Confidence Interval for Proportion of Male Online College Students: 33 F 20 33 M Sample Size: 25 21 33 F Number of Males: 9 Number of Females 16/ 22 43 F N Male Proportion: 1.36 Female Proportion 0.64 23 45 M 24 46 F 2 Distribution: Normal Distribution 47 F 26 54 F 2 Critical Value: 1.96 27 Round Margin of Error: 0.18816 0.1882 Calculation: 1.96 x (VD.36 x 0.64/25) #REF! Lower Bound: 0.17184 0.1718 Calculation: 0.36 -0.18816 30 #REF Upper Bound 0.54816 0.5482 Calculation: 0.36+0.18816 #REF 32 33 2 Interpret |Weare 95%% confident the age of online college students is between 0.1718 and 0.5482 34 35 25 Total Points 36 37 38 39 Week 3 Week 5 Week 6 +A B C D E F G H I For the following two hypothesis tests, use the alpha =.05 level of confidence Points Claim: The average age of online students is 32 years old. Ho: Ha 1:32 ample mean 30.8 Sample St. Dev: 9.224062735 10 11 2 Distribution: T-Distribution 12 Round 13 Test Statistic 0.650473 0.65 Calculation: 30.8-32)/(9.224063/V25) 14 p-value: 0.5219 0.5219 15 There is not enough evidence to conclude that the average age of online students 16 3 Interpretation: is not 32 years old. 17 18 19 Claim: The proportion of males in online classes is 35% 20 21 1 Ho: p=0.35 22 Ha: p#0.35 23 24 Sample Proportion Males 0.36 Sample Proportion Females 0.64 25 2 Distribution: Normal Distribution 27 Round 28 Test Statistic: 0.10482848 0.1 Calculation: (0.36-0.35)/ (Vo.35(1-0.35)/25) N p-value: 0.9204 0.9204 30 There is not enough evidence to conclude that the proportion of males in online 31 Interpretation: classes is not 35% 32 33 25 Total Points 34 35 37