#Stat

Stat

by

Test Statistic Excel functions Confidence Interval formula One population mean sigma known H0:  = value H1:  ><≠ value z = x - s / n =NORM.S.DIST( ) X± Za/2sn=NORM.S.INV(a/2) One population mean sigma unknown H0:  = value H1:  ><≠ value t = x - s/ n =T.DIST( ) =T.DIST.RT( ) =T.DIST.2T( … Read more