Differences between revisions 1 and 2
Revision 1 as of 2025-04-08 16:14:14
Size: 418
Comment: Initial commit
Revision 2 as of 2026-02-17 15:26:24
Size: 416
Comment: Link
Deletions are marked like this. Additions are marked like this.
Line 13: Line 13:
Use either of the following functions to calculate a [[Statistics/TestStatistic|critical]] [[Statistics/NormalDistribution|Z statistic]] for e.g. a significance level of 5%. Use either of the following functions to calculate a [[Statistics/TestStatistic|critical]] [[Analysis/NormalDistribution|Z statistic]] for e.g. a significance level of 5%.

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)


CategoryRicottone

Excel/StatisticFunctions (last edited 2026-02-17 15:26:24 by DominicRicottone)