FORECAST.ETS Function in Excel: Forecast With Seasonality
FORECAST.ETS uses exponential smoothing and detects seasonal patterns — the engine behind Excel’s Forecast Sheet.
Read article →Statistical
Excel Statistical functions explained with syntax, examples and common mistakes.
STEYX Function in Excel: Typical Error of a Trend Line
STEYX Function in Excel: Typical Error of a Trend Line
STEYX returns the standard error of predicted y values — roughly how far actual points sit from the trend line.
Read article →FORECAST.LINEAR Function in Excel: Predict a Value From a Trend
FORECAST.LINEAR Function in Excel: Predict a Value From a Trend
FORECAST.LINEAR predicts a y-value for a given x using a straight-line trend fitted to past data.
Read article →CHISQ.DIST Function in Excel: Chi-Square Distribution (Left Tail)
CHISQ.DIST Function in Excel: Chi-Square Distribution (Left Tail)
CHISQ.DIST gives the left-tailed chi-square probability; most tests need the right tail, CHISQ.DIST.RT.
Read article →CHIDIST Function in Excel: Chi-Square p-Value (Older Name)
CHIDIST Function in Excel: Chi-Square p-Value (Older Name)
CHIDIST returns the right-tailed chi-square probability. It is a compatibility function: Excel keeps it so workbooks from Excel 2007 and earlier still calculate, but…
Read article →CHISQ.DIST.RT Function in Excel: Chi-Square p-Value (Right Tail)
CHISQ.DIST.RT Function in Excel: Chi-Square p-Value (Right Tail)
CHISQ.DIST.RT turns a chi-square statistic into a p-value: the chance of a result at least this extreme if nothing is going on.
Read article →CHISQ.INV Function in Excel: Chi-Square Value for a Left-Tail Probability
CHISQ.INV Function in Excel: Chi-Square Value for a Left-Tail Probability
StatisticsLevel: ExpertAvailable in: Excel 2010+CHISQ.INV is the inverse of CHISQ.DIST (left tail).Syntax=CHISQ.INV(probability, deg_freedom)ArgumentWhat.
Read article →CHISQ.INV.RT Function in Excel: Chi-Square Critical Value
CHISQ.INV.RT Function in Excel: Chi-Square Critical Value
CHISQ.INV.RT gives the critical value for a chi-square test: if your statistic is bigger, the result is significant.
Read article →FDIST Function in Excel: F Probability (Older Name)
FDIST Function in Excel: F Probability (Older Name)
FDIST returns the right-tailed F probability. It is a compatibility function: Excel keeps it so workbooks from Excel 2007 and earlier still calculate, but…
Read article →LOGINV Function in Excel: Inverse Lognormal (Older Name)
LOGINV Function in Excel: Inverse Lognormal (Older Name)
LOGINV returns the value at a lognormal probability. It is a compatibility function: Excel keeps it so workbooks from Excel 2007 and earlier still…
Read article →TINV Function in Excel: Two-Tailed t Critical Value (Older Name)
TINV Function in Excel: Two-Tailed t Critical Value (Older Name)
TINV returns the two-tailed t critical value. It is a compatibility function: Excel keeps it so workbooks from Excel 2007 and earlier still calculate,…
Read article →FINV Function in Excel: F Critical Value (Older Name)
FINV Function in Excel: F Critical Value (Older Name)
FINV returns the F critical value. It is a compatibility function: Excel keeps it so workbooks from Excel 2007 and earlier still calculate, but…
Read article →