Paragraph 1: o Brief summary of the U.S. News Data: The Average Online Bachelor's Student the article, including the source ? A direct link to this article is located here and I have attached the info below :

https://www.usnews.com/higher-education/online-education/articles/2017-04-04/us-news-data-the-average-online-bachelors-student

or file:///C:/Users/bobby/Desktop/33761706.htm Week 7 entitled Read: U.S. News Data: The Average Online Bachelor's Student. o Define the population, sample, and statistics for the study o Statement of the two claims in the article that were tested in this project o Null and alternative hypotheses for both tests run for this project (in words) ? Paragraph 2 (address the claim about the mean): o Summary of sample statistics (mean, standard deviation, median, quartiles, sample size) o Confidence interval, along with the interpretation of the confidence interval o Description of hypothesis test (alpha, test statistic, p-value, conclusion, interpretation) ? Paragraph 3 (address the claim about the proportion): o Summary of sample statistics (sample size, successes, proportion) o Confidence interval, along with the interpretation of the confidence interval o Description of hypothesis test (alpha, test statistic, p-value, conclusion, interpretation)

Search the menus (Alt+/) 100% 123 - Calibri B 2. 41 fx | Age A B C D E F G H I J K L M N 0 P Q R S T U V 18 36 F Q1 22.5 *Round to one decimal below. Please do not put them on a 19 36 F 03 36.5 *Round to one decimal separate page. 20 37 F Ogive: Ogive: 21 41 F Polygon 16.5 0.0000 22 42 F 26.5 11.0000 Polygon : Age of Online Students 23 43 F 36.5 18.0000 24 44 F 46.5 23.0000 25 57 M Total: 25 56.5 23.0000 Frequency Polygon: Ages of Online Students 26 66.5 24.0000 12 27 10 28 Ogive: Age of Online Students 29 30 31 Cumulative Relative Frequency: Ages of Online Students Freq.: Students 32 25.0000 33 20.0000 34 15.0000 Cumulative Relative Freq.:- 35 10.0000 36 5.0000 22 32 42 52 62 37 0.0000 20 30 40 50 60 38 Ages of Students in Classes 39 Ages of Students 40M Note: The goal of the project is to practice making a confidence interval for a mean and proportion with real data. Do not worry about failed assumptions tests and do not make corrections for small sample size. Use primary methods described in text and used on Help for this spreadsheet 2 3 Age Gender Points 95% Confidence Interval for Average Age of Online College Students: . Review 8.2 of your text as well as the 17 F Project Help tab below for the first 5 18 M Sample Mean: 30.67 confidence interval calculation (mean). 6 19 M Sample St. Dev: 10.05 Note: Calculation cells should list the numbers and Also watch Excel videos in BlackBoard. 7 19 M 1 Sample Size: 24 8 operations used to get your Review 8.3 of your text as well as the 21 M answers. Do not put the 22 F Project Help tab below for the second 2 Distribution: T-Distribution generic formula and show all 10 23 F confidence interval calculation calculation steps. 11 24 M 2 Critical Value: 2.07 *2 decimals (proportion). Also watch Excel videos in 12 26 F BlackBoard. 13 26 M 2 Margin of Error: 4.25 #2 decimals Calculation: 2.07*10.05/sqrt(24) "Show Your Calculation" - these cells 14 26 F Lower Bound: 26.42 #2 decimals Calculation: 30.67-4.25 should list the numbers and operations 15 30 F 1 Upper Bound: 34.92 #2 decimals Calculation: 30.67+4.25 used to get your answers. Do not just 16 31 F put the general formula and show all 17 32 F Interpret We are 95% confident that the average age of a online student is between 18 33 M (context) 26.42 and 34.92 calculation steps. Do not put "=" in 2 19 33 F formulas so I can see the formula by just 20 36 F 95% Confidence Interval for Proportion of Male Online College Students: looking at the cell, not opening it. 21 36 F For the "Interpret" text, what can we 22 37 F 1 Sample Size: 24 conclude about the population mean 23 41 F f Males: age and the population male proportionM11 fx A B C D E F G H K L M 0 P Q R S T U V W X 13 26 M Margin of Error: 4.25 #2 decimals Calculation: 2.07*10.05/sqrt(24) "Show Your Calculation" - these cells 14 26 F Lower Bound: 26.42 #2 decimals Calculation: 30.67-4.25 should list the numbers and operations 15 30 F Upper Bound: 34.92 $2 decimals Calculation: 30.67+4.25 16 31 F used to get your answers. Do not just 17 32 F put the general formula and show all Interpret We are 95% confident that the average age of a online student is between 18 33 M 2 (context) 26.42 and 34.92 calculation steps. Do not put "=" in 19 33 F formulas so I can see the formula by just 20 36 F 95% Confidence Interval for Proportion of Male Online College Students: looking at the cell, not opening it. 21 36 F . For the "Interpret" text, what can we 22 37 F Sample Size: 24 conclude about the population mean 23 41 F Number of Males: 8 age and the population male proportion 24 42 F Male Proportion: 0.3333 Female Proportion 0.6666 $4 decimals of online students with respect to these 25 43 F bounds? 26 44 F 2 Distribution: Normal Distribution . Your data for Columns A and B will link 27 57 M from the Week 3 tab on this 28 #REF! #REF! 2 Critical Value: 1.96 $2 decimals spreadsheet - no need to re-input! 29 #REF #REF . The green cells (G3 and G4) will link 30 #REF #REF! Margin of Error: 0.1886 #4 decimals Calculation: |1.96*sqrt(0.3333*0.6667/24) from the Week 3 tab on this 31 #REF #REF Lower Bound 30.4814 $4 decimals Calculation: 30.67-0.1886 32 #REF spreadsheet. #REF Upper Bound: 30.8586 #4 decimals Calculation: 30.67+0.1886 33 #REF #REF . Only cells that are yellow need to be 34 #REF! BREF completed. Interpret We are 95% confident that the average age of a male online student is 35 #REF #REF 2 (context) between 30.4814 and 30.8586 . Please note rounding for calculations! 26AT.KI A B C D E F G H K L N O P Q R S T U V W X Note: The goal of the project is to practice conducting a hypothesis test for a mean and proportion with real data. Do Helps for this spreadsheet: not worry about failed assumptions tests. Use primary methods described in text and used on homework. 2 . Review 9.1 of your text as well as the Project For the following two hypothesis tests, use alpha = .05 4 Help tab below for stating your null and alternate 5 Points Claim: The average age of online students is 32 years old. Can you prove it is not? hypotheses. 6 . Review 9.3 of your text as well as the Project 7 Ho mu=32 Help tab below to do a hypothesis test for a 8 Ha: mu 32 Note: Calculation cells should population mean. Also watch the Excel videos. g list the numbers and operations used to get your . Review 9.4 of your text as well as the Project 10 Sample mean: 30.67 answers. Do not put the Help tab below to do a hypothesis test for a 11 Sample St. Dev: 10.05 generic formula and show all 12 population proportion. Also watch the Excel calculation steps. 13 2 Distribution: T-Distribution videos. 14 . "Show Your Calculation" - these cells should list 15 Test Statistic: 0.648322 $2 decimals Calculation: (32-30.67)/(10.05/SQRT(24)) the numbers and operations used to get your 16 INN -value: 0.523196 $4 decimals answers. Do not just put the general formula and 17 Decision: Fail to Reject Ho show all calculation steps. Do not put "=" in 18 formulas so I can see the formula by just looking The average age of online students is 32 years old and can not be 19 Interpretation: proven. There is not enough evidence to conclude that the mean at the cell, not opening it. 2 (context) age of online college students differs from 32 years old . For the "Interpret" text, what can we conclude 20 about the null hypothesis with respect to the 21 Claim: The proportion of males in online classes is 35%. Can you prove it is not? evidence produced by the hypothesis test? What17 1 Decision: Fail to Reject Ho Y show all calculation steps. Do not put "=" in 18 formulas so I can see the formula by just looking The average age of online students is 32 years old and can not be 19 Interpretation: proven. There is not enough evidence to conclude that the mean at the cell, not opening it. 2 context) age of online college students differs from 32 years old. . For the "Interpret" text, what can we conclude 20 about the null hypothesis with respect to the 21 Claim: The proportion of males in online classes is 35%. Can you prove it is not? evidence produced by the hypothesis test? What 22 does this mean about the average age and male 23 Ho mu=.35 proportion of all online college students? 24 Ha: m=.35 . The green cells (E8 and E9) will link from the 25 26 Week 3 tab on this spreadsheet. Sample Proportion Males 0.3333 Sample Proportion Females 0.6666 27 . The green cells (F24 and J24) will link from the 28 2 Distribution: T-Distribution Week 5 tab on this spreadsheet. 29 . Only cells that are yellow need to be completed. 30 Test Statistic: 0.17 #2 decimals Calculation: (-0.35/(10.05/SQRT(24))) . Please note rounding for calculations! 31 -value: 0.432505 $4 decimals 32 Decision: Fail to Reject Ho 33 Interpretation: There is not enough evidence to conclude that the proportions of 2 context males in online classes differs from 35%. 35 36 25 Total Points 37 + Week 3 - Week 5 - Week 6 - Project Help +Age Gender For the following questions, use only the "age" column: 2 17 F Help for this spreadsheet 3 18 M Points Age Frequency Distribution: Class Width 10 4 19 M . Review 2.2, 3.1 - 3.3 of your text. Also 19 M Class Limits Relative Cumulative watch Excel Videos in BlackBoard. 6 21 M Low High Midpoint Freq Frequency Relative Freq . Your data is already copied into columns 7 22 F Limits 17 26 22 11 ).4400 1.0000 A and B. 8 23 F Freq. 27 36 32 0.2800 18.0000 . Only cells in yellow need to be 9 24 M Mid PNNNN 37 46 42 5 .2000 23.0000 completed. 10 26 F RF 47 56 52 O 0.0000 23.0000 . Choose a class width according to the 11 26 M CF 57 66 62 1 0.0400 24.0000 12 26 F following equation (rounded up to whole 13 30 F #DIV/O! number): 14 31 F CLASS WIDTH = (MAX VALUE - MIN 15 32 F N NNNN Mean 30.67 *Round to two decimals VALUE)/# of Classes (5) 16 33 M Median 30.5 *Round to one decimal . The ogive and polygon graphs need to be 17 33 F Sample Standard deviation: 10.05 *Round to two decimals included on this page under the headers 18 36 F Q1 22.5 *Round to one decimal below. Please do not put them on a 19 36 F 03 36.5 *Round to one decimal separate page. 20 37 F Ogive: Ogive 21 41 F Polygon 16.5 0.0000 22 42 F 26.5 11.0000 Polygon : Age of Online Students 23 43 F 36.5 18.0000