Need help with steps for this excel. Age and gender data goes from A4:A74

A B C D E G H M AA AB AC AD AE AF AG AH Al AJ AK AL AM AN AO AP 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 homework. Help for this spreadsheet Gender Points 95% Confidence Intervalfor Average Age of Online College Students: 19 F 28 M Sample Mean: 30.32 17 M Sample St. Dev: 10.7 Note: Calculation cells should list 41 M Sample Size: the numbers and operations used 19 M to get your answers. Do not put 35 M Distribution: the generic formula and show all 20 M calculation steps. Critical Value: *2 decimals "Show Your Calculation" - these cells should list Margin of Error: "2 decimals Calculation: the numbers and operations used to get your Lower Bound: "2 decimals Calculation: answers. Do not just put the general formula and Upper Bound: *2 decimals Calculation: show all calculation steps. Do not put "=" in formulas so I can see the formula by just looking nterpret at the cell, not opening it. context) For the "Interpret" text, what can we conclude about the population mean age and the 95% Confidence Interval for Proportion of Male Online College Students: population male proportion of online students with respect to these bounds? Sample Size: Your data for Columns A and B will link from the Number of Males: Week 3 tab on this spreadsheet - no need to re- Male Proportion: Female Proportion *4 decimals input! The green cells (G3 and G4) will link from the 2 Distribution: Week 3 tab on this spreadsheet. 2 Critical Value: *2 decimals . Only cells that are yellow need to be completed. . Please note rounding for calculations! Margin of Error: 4 decimals Calculation: Lower Bound: *4 decimals Calculation: Upper Bound: "4 decimals Calculation: Interpret (context) 25 Total Points 35 MA B M AA AB AC AD AE AF AG AH 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 AK AL AM AN AO AP 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: 19 F 28 M Sample Mean: 30.32 17 M Sample St. Dev: 10.7 Note: Calculation cells should list 41 M Sample Size: the numbers and operations used 19 M to get your answers. Do not put 35 M Distribution: the generic formula and show all Critical Value: "Show Your Calculation" - these cells should list Margin of Error: Normal Distribution the numbers and operations used to get your Lower Bound: answers. Do not just put the general formula and Upper Bound: T-Distribution show all calculation steps. Do not put "=" in formulas so I can see the formula by just looking Interpret at the cell, not opening it. (context) For the "Interpret" text, what can we conclude about the population mean age and the 95% Confidence Interval for Proportion of Male Online College Students: population male proportion of online students with respect to these bounds? Sample Size: Your data for Columns A and B will link from the Number of Males: Week 3 tab on this spreadsheet - no need to re- NH Male Proportion: Female Proportion "4 decimals input! Distribution: The green cells (G3 and G4) will link from the Week 3 tab on this spreadsheet. Critical Value: "2 decimals . Only cells that are yellow need to be completed. Please note rounding for calculations! Margin of Error: *4 decimals Calculation: Lower Bound: *4 decimals Calculation: Upper Bound: "4 decimals Calculation: Interpret (context) 25 Total Points 19 M