Please help with the first section, the section being “Average Age of College Students”. I am having issues coming up with the Distribution and Calculations for the Margin of Error, Lower and Upper Bound.Thank you. 73 Age4567A891011121314✓: X✓ fx We are 95% confident that true population mean lies inside the confidence interval (23.66, 34.10).CEFGHJK95% Confidence Interval for Average Age of Online College Students:1533 M16BGender34 M35 F171820 F1918 F19 M45 F20212233 M24 M232437 F2526 M32 F262732 F18 F16 M37 F2823 F28 F77 F323350 F30 M25 M29 24 M253022 M343525 M26 F363777'FDPoints12Week 322112Sample Mean:Sample St. Dev:Sample Size:1122Week 5Distribution:Critical Value:Margin of Error:Lower Bound:Upper Bound:2211Interpret We are 95% confident that true population mean lies inside the confidence.(context) interval (23.66, 34.10).95% Confidence Interval for Proportion of Male Online College Students:2Sample Size:Number of Males:Male Proportion:2528.8812.9226Distribution:Critical Value:Margin of Error:Lower Bound:Upper Bound:Interpret(context)2.06*2 decimalsTotal PointsWeek 6 Project Help5.222 decimals23.66*2 decimals34.1*2 decimalsCalculation:Calculation:Calculation:Female Proportion*2 decimalsNote: Calculation cells shouldlist the numbers andoperations used to get youranswers. Do not put thegeneric formula and show allcalculation steps.4 decimals Calculation:4 decimals Calculation:4 decimalsCalculation:L*4 decimalsM0PQRST.• Review 8.2 of your text as well as theProject Help tab below for the firstconfidence interval calculation (mean).Also watch Excel videos in BlackBoard.• Review 8.3 of your text as well as theProject Help tab below for the secondconfidence interval calculation(proportion). Also watch Excel videos inBlackBoard.."Show Your Calculation" - these cellsshould list the numbers and operationsused to get your answers. Do not justput the general formula and show allcalculation steps. Do not put "=" informulas so I can see the formula by justlooking at the cell, not opening it.. For the "Interpret" text, what can weconclude about the population meanage and the population male proportionof online students with respect to thesebounds?.Your data for Columns A and B will linkfrom the Week 3 tab on thisspreadsheet - no need to re-input!The green cells (G3 and G4) will linkfrom the Week 3 tab on thisspreadsheet.. Only cells that are yellow need to becompleted.. Please note rounding for calculations!40%3:35 PM$27/2000 6

Question

Please help with the first section, the section being “Average Age of College Students”. I am having issues coming up with the Distribution and Calculations for the Margin of Error, Lower and Upper Bound.Thank you. 73 Age4567A891011121314✓: X✓ fx We are 95% confident that true population mean lies inside the confidence interval (23.66, 34.10).CEFGHJK95% Confidence Interval for Average Age of Online College Students:1533 M16BGender34 M35 F171820 F1918 F19 M45 F20212233 M24 M232437 F2526 M32 F262732 F18 F16 M37 F2823 F28 F77 F323350 F30 M25 M29 24 M253022 M343525 M26 F363777'FDPoints12Week 322112Sample Mean:Sample St. Dev:Sample Size:1122Week 5Distribution:Critical Value:Margin of Error:Lower Bound:Upper Bound:2211Interpret We are 95% confident that true population mean lies inside the confidence.(context) interval (23.66, 34.10).95% Confidence Interval for Proportion of Male Online College Students:2Sample Size:Number of Males:Male Proportion:2528.8812.9226Distribution:Critical Value:Margin of Error:Lower Bound:Upper Bound:Interpret(context)2.06*2 decimalsTotal PointsWeek 6 Project Help5.222 decimals23.66*2 decimals34.1*2 decimalsCalculation:Calculation:Calculation:Female Proportion*2 decimalsNote: Calculation cells shouldlist the numbers andoperations used to get youranswers. Do not put thegeneric formula and show allcalculation steps.4 decimals Calculation:4 decimals Calculation:4 decimalsCalculation:L*4 decimalsM0PQRST.• Review 8.2 of your text as well as theProject Help tab below for the firstconfidence interval calculation (mean).Also watch Excel videos in BlackBoard.• Review 8.3 of your text as well as theProject Help tab below for the secondconfidence interval calculation(proportion). Also watch Excel videos inBlackBoard..&#34;Show Your Calculation&#34; - these cellsshould list the numbers and operationsused to get your answers. Do not justput the general formula and show allcalculation steps. Do not put &#34;=&#34; informulas so I can see the formula by justlooking at the cell, not opening it.. For the &#34;Interpret&#34; text, what can weconclude about the population meanage and the population male proportionof online students with respect to thesebounds?.Your data for Columns A and B will linkfrom the Week 3 tab on thisspreadsheet - no need to re-input!The green cells (G3 and G4) will linkfrom the Week 3 tab on thisspreadsheet.. Only cells that are yellow need to becompleted.. Please note rounding for calculations!40%3:35 PM$27/2000 6

Accepted Answer

In above scenario we have to construct confidence interval for one population mean 
The formula for…