F.INV Function in Excel: F Value for a Left-Tail Probability
StatisticsLevel: ExpertAvailable in: Excel 2010+F.INV returns the F value for a left-tail probability.Syntax=F.INV(probability, deg_freedom1.
Read article →Statistical
Excel Statistical functions explained with syntax, examples and common mistakes.
LOGEST Function in Excel: Exponential Curve Fit
LOGEST Function in Excel: Exponential Curve Fit
LOGEST fits y = b·mˣ and returns m (the growth factor) and b. m of 1.05 means 5% growth per period.
Read article →PEARSON Function in Excel: Correlation (Pearson)
PEARSON Function in Excel: Correlation (Pearson)
StatisticsLevel: ExpertAvailable in: Excel 2007+PEARSON returns the same value as CORREL: −1 to 1.Syntax=PEARSON(array1, array2)ArgumentWhat it.
Read article →LINEST Function in Excel: Full Regression Statistics
LINEST Function in Excel: Full Regression Statistics
LINEST fits a straight line (or a multiple regression) and returns slope, intercept and, optionally, R², standard errors and more — an entire regression…
Read article →INTERCEPT Function in Excel: Where the Trend Line Starts
INTERCEPT Function in Excel: Where the Trend Line Starts
INTERCEPT gives the y-value of the trend line when x is 0. With SLOPE you have the full equation y = intercept + slope…
Read article →GROWTH Function in Excel: Extend an Exponential Trend
GROWTH Function in Excel: Extend an Exponential Trend
GROWTH is TREND for things that grow by a percentage — sign-ups, compounding balances — rather than by a fixed amount.
Read article →FORECAST.ETS.SEASONALITY Function in Excel: Which Cycle Did Excel Find?
FORECAST.ETS.SEASONALITY Function in Excel: Which Cycle Did Excel Find?
FORECAST.ETS.SEASONALITY reports the season length Excel detected — 12 for a yearly cycle in monthly data, 7 for a weekly cycle in daily data.
Read article →FORECAST.ETS.STAT Function in Excel: Statistics of an ETS Forecast
FORECAST.ETS.STAT Function in Excel: Statistics of an ETS Forecast
FORECAST.ETS.STAT returns a statistic about the ETS model behind FORECAST.ETS, such as the smoothing parameters (alpha, beta, gamma) or error measures (MAPE, RMSE), to…
Read article →FORECAST.ETS.CONFINT Function in Excel: How Uncertain Is the Forecast?
FORECAST.ETS.CONFINT Function in Excel: How Uncertain Is the Forecast?
FORECAST.ETS.CONFINT returns the ± interval around a FORECAST.ETS value. A forecast of 1,200 ± 400 tells a very different story from 1,200 ± 40.
Read article →RSQ Function in Excel: How Well a Line Fits
RSQ Function in Excel: How Well a Line Fits
RSQ returns R², between 0 and 1. Near 1 means a straight line explains the data well; near 0 means your trend forecast is…
Read article →TREND Function in Excel: Extend a Straight-Line Trend
TREND Function in Excel: Extend a Straight-Line Trend
TREND fits a straight line and returns values on it, for existing points or new ones. In Excel 365 it spills several forecasts at…
Read article →SLOPE Function in Excel: How Fast a Trend Rises
SLOPE Function in Excel: How Fast a Trend Rises
SLOPE returns the slope of the best-fit straight line — “sales grow by about ₹42,000 a month”.
Read article →