The directions are in green on the excel spreadsheet and in the word document. The yellow cells are what I’m having trouble figuring out. ABDEGNote: The goal of the project is to practice making a confidence interval for a mean and proportion with real data. Do not worry about failedassumptions tests and do not make corrections for small sample size. Use primary methods described in text and used on homework.95% Confidence Interval for Average Age of Online College Students:23 Age456789101112131415161718192021222333 M34 M35 F20 F18 F19 M45 F33 M24 M37 F26 M2425262728Gender29303132333432 F32 F18 F3516 M37 F23 F428 F77 F50 F22 M25 M26 F30 M25 M24 MWeek 3Points12221121122221Sample Mean:Sample St. Dev:Sample Size:1Distribution:Critical Value:Margin of Error:Lower Bound:Upper Bound:Interpret(context)Sample Size:Number of Males:Male Proportion:Distribution:Critical Value:95% Confidence Interval for Proportion of Male Online College Students:Margin of Error:Lower Bound:Upper Bound:28.8812.92Interpret2(context)Week 5 Week 6 Project Help*2 decimals+*2 decimals Calculation:*2 decimals Calculation:*2 decimals 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 decimals Calculation:*4 decimalsHelp for this spreadsheet• 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 link.from the Week 3 tab on thisspreadsheet.Only cells that are yellow need to becompleted. For this part of the project and based on the class sample, you will create a 95% confidenceinterval for the mean age and the proportion of males in the population of all online collegestudents.Note: The goal of the project is to practice making a confidence interval for a mean andproportion with real data. Do not worry about failed assumptions tests and do not makecorrections for small sample size. Use primary methods described in text and used on homework.Using the same excel sheet you submitted for Part 2, answer the following in the "Module 5" tab:● For the average age, form a 95% confidence interval:What distribution should be used?What is the critical value?What is the error bound?What is the lower bound?What is the upper bound?How do we interpret the results, in context of our study?For the proportion of males, form a 95% confidence interval:●OOD 0 0 0 0O What distribution should be used?0 0 0 0 0 0What is the critical value?What is the error bound?What is the lower bound?What is the upper bound?How do we interpret the results, in context of our study?

Question

The directions are in green on the excel spreadsheet and in the word document. The yellow cells are what I’m having trouble figuring out. ABDEGNote: The goal of the project is to practice making a confidence interval for a mean and proportion with real data. Do not worry about failedassumptions tests and do not make corrections for small sample size. Use primary methods described in text and used on homework.95% Confidence Interval for Average Age of Online College Students:23 Age456789101112131415161718192021222333 M34 M35 F20 F18 F19 M45 F33 M24 M37 F26 M2425262728Gender29303132333432 F32 F18 F3516 M37 F23 F428 F77 F50 F22 M25 M26 F30 M25 M24 MWeek 3Points12221121122221Sample Mean:Sample St. Dev:Sample Size:1Distribution:Critical Value:Margin of Error:Lower Bound:Upper Bound:Interpret(context)Sample Size:Number of Males:Male Proportion:Distribution:Critical Value:95% Confidence Interval for Proportion of Male Online College Students:Margin of Error:Lower Bound:Upper Bound:28.8812.92Interpret2(context)Week 5 Week 6 Project Help*2 decimals+*2 decimals Calculation:*2 decimals Calculation:*2 decimals 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 decimals Calculation:*4 decimalsHelp for this spreadsheet• 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 link.from the Week 3 tab on thisspreadsheet.Only cells that are yellow need to becompleted. For this part of the project and based on the class sample, you will create a 95% confidenceinterval for the mean age and the proportion of males in the population of all online collegestudents.Note: The goal of the project is to practice making a confidence interval for a mean andproportion with real data. Do not worry about failed assumptions tests and do not makecorrections for small sample size. Use primary methods described in text and used on homework.Using the same excel sheet you submitted for Part 2, answer the following in the &#34;Module 5&#34; tab:● For the average age, form a 95% confidence interval:What distribution should be used?What is the critical value?What is the error bound?What is the lower bound?What is the upper bound?How do we interpret the results, in context of our study?For the proportion of males, form a 95% confidence interval:●OOD 0 0 0 0O What distribution should be used?0 0 0 0 0 0What is the critical value?What is the error bound?What is the lower bound?What is the upper bound?How do we interpret the results, in context of our study?

Accepted Answer

* Hi! Thank you for the question As per the honour code, We’ll answer the first question since the…

Critical Value: Margin of Error: Lower Bound: Upper Bound: Interpret (context) OEM C *2 decimals *2 decimals Calculation: *2 decimals Calculation: *2 decimals Calculation: bie Online College Studente:

Critical Value: Margin of Error: Lower Bound: Upper Bound: Interpret (context) OEM C 2 decimals 2 decimals Calculation: 2 decimals Calculation: 2 decimals Calculation: bie Online College Studente: