Please solve the yellow

AutoSave (C Off) _ week 5 (2) - Search (Alt+0) Data Review Help File Home Insert Page Layout Formulas View Calibri ~ 11 ~ A" A 29 Wrap Text General Conditional Format Paste BI U~ ~ MA~ 4= Merge & Center % Formatting Table Number Styles Clipboard Font Alignment D13 X z C N A D E Interpretation: calcul 19 2 ( context) formu 20 looking 21 For the 22 Claim: The proportion of males in online classes is 35%. Can you prove it is not? conclud 23 24 respect Ho: 25 Ha: hypothe 26 about th 27 Sample Proportion Males 0.375 Sample Proportion Females 0.625 proporti 28 The gree 2 Distribution: the Week 31 3 Test Statistic: *2 decimals Calculation: The green 32 p-value: *4 decimals the Week 33 Decision: - Only cells 34 completed Interpretation: Please not 2 (context) 25 Total Points Week 3 Week 5 Week 6 Project Help Enter Circular References TX Accessibility: Investigate Type here to search O G X hp esc ? 13 f4 101 + 19 144 10 DII DDI 2 4 5 C O ab Q E RAutoSave ( Off) week 5 (2) - Search (Alt +0) File Home Insert Page Layout Formulas Data Review View Help Calibri - 11 ~ A A 29 Wrap Text General Paste Conditional Format BIU~ ~ MA Formatting Table Styles Clipboard Font Alignment Number D13 X Z C C G H K N A B 3 For the following two hypothesis tests, use alpha = .05 Project 4 null and 5 Points Claim: The average age of online students is 32 years old. Can you prove it is not? Review 6 7 Project Ho: Note: Calculation cells should test for ist the numbers and 9 Excel vid 10 operations used to get your Sample mean: 27.63 11/ Sample St. Dev: answers. Do not put the Review 9 8.78 Project 12 generic formula and show all test for a Distribution: Z C calculation steps. 2 watch the Test Statistic: *2 decimals Calculation: "Show You p-value: *4 decimals should list Decision: used to ge the genera Interpretation: calculation (context ) formulas so looking at t Claim: The proportion of males in online classes is 35%. Can you prove it is not? For the "Int conclude ab carnoct to the Week 3 Week 5 Week 6 Project Help Enter Circular References x Accessibility investigate Type here to search O G X hp . . . . . . . . . . . . . .'. . . . :" : esc ? 19 144 10 3 4 O tab Q E R P