CI and 1 Prop Z Test Spreadhseet.xlsx - One Proportion Confidence Interval Z p-hat q-hat n 1.96 0.4875 0.5125 1200 Standard Error Margin of Error 0.014
CI and 1 Prop Z Test Spreadhseet.xlsx - One Proportion...
One Proportion Confidence IntervalZ*1.96p-hat0.4875q-hat0.5125n1200Standard Error0.014Margin of Error0.028Confidence Interval45.9%51.6%As Decimals0.4590.516One Sample t Test for Population Meann25df24Standard Deviation9.05ȳ32.48Signigicance Level0.05Standard Error1.81t*2.06389856Margin of Error3.7356564Confidence Interval28.744343636.2156564
One Proporp-hatnSD(p-hat)ZAlpha LevelP-Value:Left Tailed1.0000Right Tailed0.0000Two-Tailed0.0000Conditions:Success/FailureNPNQP0Q0
rtion Z Test0.81250.560.4412000.014317.62100.05Reject?Fail to Reject?noyesyesnoyesno672