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 →Excel
Excel formulas, unusual formula combinations, VBA, Power Query and dashboards — from basics to clever tricks.
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 →BIN2OCT Function in Excel: Binary to Octal
BIN2OCT Function in Excel: Binary to Octal
BIN2OCT converts a binary number to octal. Used for device codes, permission bits, memory addresses and number-system lessons.
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 →LOGNORM.DIST Function in Excel: Lognormal Distribution
LOGNORM.DIST Function in Excel: Lognormal Distribution
LOGNORM.DIST models values whose logarithm is normal: incomes, house prices, stock prices, file sizes.
Read article →BAHTTEXT Function in Excel: Number to Thai Baht Words
BAHTTEXT Function in Excel: Number to Thai Baht Words
BAHTTEXT writes a number as Thai text with 'Baht'. There is no rupee equivalent built in; for Indian amounts in words you need a…
Read article →ACCRINTM Function in Excel: Interest Accrued When Paid at Maturity
ACCRINTM Function in Excel: Interest Accrued When Paid at Maturity
ACCRINTM returns interest accrued on a security that pays all its interest at maturity, such as a cumulative fixed deposit or a zero-coupon-style note.
Read article →