Excel Statistic Function
Excel offers these statistic functions.
Normal Distribution
Use either of the following functions to calculate a critical Z statistic for e.g. a significance level of 5%.
=NORM.INV(1 - 0.05/2) =NORM.S.INV(1 - 0.05/2, 0, 1)
Excel offers these statistic functions.
Use either of the following functions to calculate a critical Z statistic for e.g. a significance level of 5%.
=NORM.INV(1 - 0.05/2) =NORM.S.INV(1 - 0.05/2, 0, 1)
Excel/StatisticFunctions (last edited 2025-04-08 16:14:14 by DominicRicottone)