You will submit a final report, written in Word (or similar word processing software), based on your findings and submissions from Parts 1 - 4. It is highly suggested you not submit this paper without first reviewing all the feedback from your instructor on submissions from all parts of this project. Be sure to ask any questions you may have on your feedback. This final submission should be three paragraphs and summarize your entire project. It will be submitted to Turnitin to check for originality. The project must be submitted in paragraph form and not just a list of the calculations from your project. Be sure your paragraphs flow (not just listing the answers to the questions, but complete sentences with transitions) and are written in third person. The goal is not to define all the terms, nor describe how they are calculated. Rather, you should describe the results and what they told you about online students. You are presenting your results to a nonstatistical audience, do not describe the calculations, describe your results. It should include the following: ? Paragraph 1: o Brief summary of the U.S. News Data: The Average Online Bachelor's Student article, including the source ? A direct link to this article is located in the Learn section of Module 7: Week 7 entitled Read: U.S. News Data: The Average Online Bachelor's Student. o Define the population, sample, and statistic for the study o Statement of the two claims in the article that were tested in this project o Null and alternative hypothesis 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 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 interpretation of the confidence interval o Description of hypothesis test (alpha, test statistic, p-value, conclusion, interpretation)

Gender For the following questions, use only the "age" column: 28 F Help for this spreadsheet WEZ Points Age Frequency Distribution: Class Width Review 2.2, 3.1 - 3.3 of your text. Also watch 30 M 19 F Class Limits Relative Cumulative Excel Videos in BlackBoard. 44 F Low High Midpoint Freq. Your data is already copied into columns A Frequency Relative Freq and B. 24 M Limits RE Freq. Only cells in yellow need to be completed. 19 M Mid. Choose a class width according to the 28 M RIF following equation (rounded up to whole 36 M OF number]: 44 F CLASS WIDTH = (MAX VALUE - MIN VALUE)/N 25 F Mean *Round to two decimals of Classes (5) 21 F Median *Round to one decimal The ogive and polygon graphs need to be 21 M Sample Standard deviation: *Round to two decimals included on this page under the headers 22 M 01 *Round to one decimal below. Please do not put them on a separate 22 F *Round to one decimal page. 35 F 31 M 29 M Ogive: Ogive: Polygon: 17 M Polygon 23 F 30 F 37 M Total; 25Note: 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 homework Help for this spreadsheet Age Gender Points 95% Confidence Interval for Average Age of Online College Students: Review 8.2 of your text as well as the 28 F Project Help tab below for the first 23 M Sample Mean: confidence interval calculation (mean). Also o 30 M Sample St. Dev: Note: Calculation cells should watch Excel videos in BlackBoard. 19 F 1 Sample Size: list the numbers and operations Review 8.3 of your text as well as the 44 F used to get your answers. Do Project Help tab below for the second 24 M 2 Distribution: not put the generic formula and confidence interval calculation (proportion). 38 F show all calculation steps. Also watch Excel videos in BlackBoard. 19 M 2 Critical Value: *2 decimals "Show Your Calculation" - these cells should 28 M list the numbers and operations used to get 36 M Margin of Error: *2 decimals Calculation: your answers. Do not just put the general 44 F Lower Bound: *2 decimals Calculation: formula and show all calculation steps. Do 25 F Upper Bound: *2 decimals Calculation: not put "=" in formulas so I can see the 21 F formula by just looking at the cell, not 21 M Interpret opening it. 22 M 2 (context) For the "Interpret" text, what can we 22 F conclude about the population mean age 35 F 95% Confidence Interval for Proportion of Male Online College Students: and the population male proportion of 31 M online students with respect to these 29 M Sample Size: bounds? 17 M Number of Males: 23 F Male Proportion: Female Proportion *4 decimals Your data for Columns A and B will link from #REF #REF the Week 3 tab on this spreadsheet - no 30 F N Distribution: need to re-input! 37 M The green cells (G3 and G4) will link from 2 Critical Value: *2 decimals the Week 3 tab on this spreadsheet. Only cells that are yellow need to be Margin of Error: *4 decimals Calculation: completed. Lower Bound: *4 decimals Calculation: Please note rounding for calculations! Upper Bound: *4 decimals Calculation: Interpret 2 (context) 25 Total PointsNote: The goal of the project is to practice conducting a hypothesis test for a mean and proportion with real data. Do not worry Helps for this spreadsheet: about failed assumptions tests. Use primary methods described in text and used on homework. " Review 9.1 of your text as well as the For the following two hypothesis tests, use alpha . .05 Project Help tab below for stating your Points Claim: The average age of online students is 32 years old. Can you prove it is not? null and alternate hypotheses. - Review 9.3 of your text as well as the Ho: Project Help tab below to do a hypothesis Ha Note: Calculation cells should test for a population mean. Also watch list the numbers and operations the Excel videos. Sample mean: used to get your answers. Do Review 9.4 of your text as well as the Sample St. Dev: not put the generic formula and Project Help tab below to do a hypothesis show all calculation steps. 2 Distribution: test for a population proportion. Also watch the Excel videos. Test Statistic: 2 decimals Calculation: "Show Your Calculation" - these cells p-value: *4 decimals should list the numbers and operations Decision: used to get your answers. Do not just put the general formula and show all Interpretation: calculation steps. Do not put "=" in (context) formulas so I can see the formula by just looking at the cell, not opening it. Claim: The proportion of males in online classes is 35%. Can you prove it is not? For the "Interpret" text, what can we conclude about the null hypothesis with Ho: respect to the evidence produced by the Ha: hypothesis test? What does this mean Sample Proportion Males Sample Proportion Females 0 about the average age and male proportion of all online college students? 2 Distribution: The green cells (E8 and E9) will link from the Week 3 tab on this spreadsheet. Test Statistic: #2 decimals Calculation: The green cells (F24 and J24) will link p-value: #4 decimals from the Week 5 tab on this spreadsheet. Decision: " Only cells that are yellow need to be Interpretation: completed. 2 [context) Please note rounding for calculations! 25 Total PointsHo: H=32 Ha: H#32 Sample mean 28.08695652 Sample St. Dev. 7.838790743 Distribution t normal distribution Test statistic -2.39 p value 0.0256 Decision Reject Ho Interpretation There is sufficient evidence to claim that average age of online student is 32 year old Ho: p=0.35 Ha: p#0.35 Sample proportion male 0.5217 Sample proportion female 0.4783 Distribution z normal distribution Test statistic 1.73 p value 0.0842 Decision Do not reject Ho Interpretation There is not sufficient evidence to claim that promotion of males in online class is 35%