90.2K

Verified Solution

Link Copied!

A B C E F G H 1 J K M 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 1 not make corrections for small sample size Use primary methods described in text and used on homework 2 3 Age 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 FATHER2858 22 23 24 26 27 29 30 31 32 22 Gender 23 Female 34 Female 41 Female 26 Male 18 Male 25 Male 19 Male 36 Male 21 Female 19 Female 20 Male 19 Female 20 Female 18 Male 21 Male 19 Female 23 Female 27 Male 26 Male 25 Female 23 Female 18 Male 37 Female D Points 1 2 2 2 1 1 2 1 1 2 2 2 2 1 1 Sample Mean Sample St Dev Sample Size Distribution 95 Confidence Interval for Average Age of Online College Students Critical Value Margin of Error Lower Bound Upper Bound Interpret context We can conclude Sample Size Number of Males Male Proportion Distribution Critical Value 24 26 6 68 23 Normal Distribution Margin of Error Lower Bound Upper Bound m 95 Confidence Interval for Proportion of Male Online College Students 19 64 2 decimals 2 decimals Calculation Calculation 2 decimals 2 decimals Calculation 23 11 9 0909 Female Proportion T Distribution 23 43 2 decimals 4 decimals 4 decimals 4 decimals Calculation Calculation Calculation Note Calculation cells should list the numbers and operations used to get your answers Do not put the generic formula and show all calculation steps L 8 3333 4 decimals 0 P Q R S Help for this spreadsheet Review 8 2 of your text as well as the Project Help tab below for the first confidence interval calculation mean Also watch Excel videos in Canvas T Review 8 3 of your text as well as the Project Help tab below for the second confidence interval calculation proportion Also watch Excel videos in Canvas For the Interpret text what can we conclude about the population mean age and the population male proportion of online students with respect to these bounds Your data for Columns A and B will link from the Week 3 tab on this spreadsheet no need to re input Show Your Calculation these cells should list the numbers and operations used to get your answers Do not just put the general formula and show all calculation steps Do not put in formulas so I can see the formula by just looking at the cell not opening it The green cells G3 and G4 will link from the Week 3 tab on this spreadsheet Only cells that are yellow need to be completed Please note rounding for calculations U V

Answer & Explanation Solved by verified expert

See Answer