T.INV Function in Excel: t Value for a Left-Tail Probability
T.INV returns the t value for a left-tail probability; T.INV.2T is the usual critical value.
Read article →Statistical
Excel Statistical functions explained with syntax, examples and common mistakes.
F.INV.RT Function in Excel: F Critical Value
F.INV.RT Function in Excel: F Critical Value
StatisticsLevel: ExpertAvailable in: Excel 2010+F.INV.RT gives the critical F value for ANOVA at a chosen significance level.Syntax=F.INV.RT(probability.
Read article →F.DIST.RT Function in Excel: F Test p-Value (Right Tail)
F.DIST.RT Function in Excel: F Test p-Value (Right Tail)
StatisticsLevel: ExpertAvailable in: Excel 2010+F.DIST.RT turns an F statistic (from ANOVA or a variance ratio) into a p-value.Syntax=F.DIST.RT(x.
Read article →T.INV.2T Function in Excel: Critical t Value
T.INV.2T Function in Excel: Critical t Value
T.INV.2T returns the t value for a two-tailed test — the multiplier for a confidence interval on a small sample.
Read article →F.DIST Function in Excel: F Distribution (Left Tail)
F.DIST Function in Excel: F Distribution (Left Tail)
F.DIST gives the left-tailed F probability; for ANOVA and variance tests use F.DIST.RT.
Read article →CHITEST Function in Excel: Chi-Square Test (Older Name)
CHITEST Function in Excel: Chi-Square Test (Older Name)
CHITEST returns the p-value comparing observed and expected counts. It is a compatibility function: Excel keeps it so workbooks from Excel 2007 and earlier…
Read article →FTEST Function in Excel: F-Test (Older Name)
FTEST Function in Excel: F-Test (Older Name)
FTEST returns the p-value comparing two variances. It is a compatibility function: Excel keeps it so workbooks from Excel 2007 and earlier still calculate,…
Read article →T.DIST Function in Excel: Student’s t Probability
T.DIST Function in Excel: Student’s t Probability
T.DIST gives probabilities for the t-distribution — used instead of the normal curve when samples are small.
Read article →F.TEST Function in Excel: Are Two Spreads Different?
F.TEST Function in Excel: Are Two Spreads Different?
F.TEST checks whether two samples have different variances — for instance, before choosing T.TEST type 2 or 3.
Read article →CHISQ.TEST Function in Excel: Are These Categories Related?
CHISQ.TEST Function in Excel: Are These Categories Related?
StatisticsLevel: ExpertAvailable in: Excel 2010+CHISQ.TEST compares observed counts with expected counts and returns a.
Read article →T.TEST Function in Excel: Is the Difference Real?
T.TEST Function in Excel: Is the Difference Real?
T.TEST returns a p-value for whether two groups have different means — did the new process really cut processing time?
Read article →LOGNORMDIST Function in Excel: Lognormal (Older Name)
LOGNORMDIST Function in Excel: Lognormal (Older Name)
LOGNORMDIST returns the cumulative lognormal probability. It is a compatibility function: Excel keeps it so workbooks from Excel 2007 and earlier still calculate, but…
Read article →