I need help, They keep saying missing data, I don't know what other data I need.

Based on your sample. you will conduct a hypothesis test to test two of the claims of the above article. Using the same excel sheet as last week. answer the following In the "week 6" tab: 0 Claim: the average age of online students is 32 years old. Can you prove it is not}I o What is the null hypothesis? What is the alternative hypothesis? What distribution should be used? What is the test statistic? What is the pvalue? What is the conclusion? 0 How do we interpret the results, in context of our study? 0 Claim: the proportion of males in online classes is 35%. Can you prove it is not? o What is the null hypothesis? What is the alternative hypothesis? What distribution should be used? What is the test statistic? What is the pvalue? What is the conclusion? How do we interpret the results, in context of our study? OOOOO OOOOOO AutoSave ON . A 3 9 . C ... 1 Student Project Work Sheet Spring B Term - Last Modified: Yesterday at 12:41 PM ~ Home Insert Draw Page Layout Formulas Data Review View 9 Tell me Share Comments & Cut Calibri (Body) 16 ~ A A 27 v a2 Wrap Text General Normal Bad Good Neutral X. 2 AutoSum " Av CE Copy Fill Paste Format BIU~ ~ OvAv Merge & Center v $ % " 00 0 Conditional Forma Calculation Check Cell Explanatory T... Followed Hyp... Insert Delete Format Sort & Analyze Formatting as Table Clear Find & Filter Select Data A1 X V fx BEFORE BEGINNING, PLEASE VIEW MY VIDEO TUTORIAL FOR THIS PROJECT - THE LINK IS FOUND IN OUR WEEK 6 ANNOUNCEMENTS A M N 0 P Q R S T U V w Z AA AB BEFORE BEGINNING, PLEASE VIEW MY VIDEO TUTORIAL FOR THIS PROJECT - THE LINK IS FOUND IN OUR WEEK 6 ANNOUNCEMENTS Review your ALEKS e-text sections 9.1, 9.3, 9.4 Note: The goal of the project is to practice conducting a hypothesis test for a mean and proportion with real data. Do not worry about failed assumptions tests. Use primary methods described in text and used on homework. For the following two hypothesis tests, use th POINT DISTRIBUTION Point Values Points Earned Claim: The average age of online students is 32 years old. Can you prove it is not? Ho: Ha: Sample mean: 28.6 Sample St. Dev: 9.2 Distribution: (Choose from drop-down menu) HNN N Test Statistic: p-value: Interpret p-value Choose from drop-down menu) N State a conclusion: Claim: The proportion of males in online classes is 35%. Can you prove it is not? Ho: Ha: Sample Proportion Males Sample Proportion Females 0.5 Distribution: (Choose from drop-down menu) HNW N Test Statistic: P-value: Interpret p-value: Choose from drop-down menu) Tell me what you want to do State a conclusion: G N 0 = 0% Week 3 Week 5 Week 6 Project - Video Helps + Ready 100%BEFORE BEGINNING, PLEASE VIEW MY VIDEO TUTORIAL FOR THIS PROJECT - THE LINK IS FOUND IN OUR WEEK 5 ANNOUNCEMENTS Review your ALEKS e-text sections 8.2, 8.3 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 2 primary methods described in text and used on homework. Use a 95% Confidence Interval for Average Age of Online College Students: Age Gender 22 F POINT DISTRIBUTION 19 Point Values Points Earned Sample Mean: 28.60 23 Sample St. Dev: 9.20 33 M Sample Size: (n) = 42 21 Distribution: T-Distribution (Choose from drop-down menu) 21 N 38 26 Critical Value: = 0.05 N 18 Margin of Error: 2.106 Lower Bound: 30.50224 HAN Upper Bound: 38.75776 State a N conclusion: Based on the confidence interval is that the true population mean age for online students is between 30.5224 and 38.75776 95% Confidence Interval for Proportion of Male Online College Students: Sample Size: 42 Number of Males: M) = 21 Male Proportion: Female Proportion 0.5 Distribution: T-Distribution (Choose from drop-down menu) N 27 28 N Critical Value: = 0.05 29 20 30 54 Margin of Error: 3.34581 29 HAN Lower Bound: 25.44221 32 23 Upper Bound: 38.55779 33 18 M Based on the confidence itnerval is that the true population proportion of male online stduents is between 25.4422 and 32 35 29 M N State a 38.6678 36 42 M conclusion: 37 19 25 0 = 0% 38 44 M 39 35 40 32 M 19 42 30 M 43 25 M 44 M70 00 -*0 Formatting as Table Styles Filter Select Dat J31 x v fx A B C D E F G H K L M N 0 P Q R S T U Age Gende For the following, use Column A for your data CLICK HERE: VIDEO TO CREATE AN OGIVE 22 19 Age Frequency Distribution: Class Width 23 POINT DISTRIBUTION Cumulative Relative freq.curve 33 M Class Limits Relative Relative 21 Point Values Points Earned Low High Midpoint Frequency Frequency Frequency 21 Class Limits 18 25 21.5 21 45.7000 45.7000 38 F Midpoint 26 33 29.5 13 28.3000 74.0000 26 Frequency 34 41 37.5 10.9000 34.9000 HNN NN 18 M Relative Frequency 42 49 15. 6 13.000 97.9000 36 Cumulative Relative Frequency 50 57 53.5 2.2000 100.1000 45 M 28 M Mean Mean 28.6 37 Median Median 26 32 M Sample Standard Deviation NNNNN Sample Standard deviation: 9.2 26 Quartile 1 Q1 21.75 22 M Quartile 3 03 34.25 18 Ogive: 22 M Polygon 26 M CLICK HERE: VIDEO TO CREATE A FREQUENCY POLYGON 31 F TOTAL POINTS 25 0 = 0% 42 M F2 - frequency polygon 26 47 M 22 M 20 54 M 29 23 F 18 32 M 29 M 42 M 19 F M 35 F 32 M