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 →Excel
Excel formulas, unusual formula combinations, VBA, Power Query and dashboards — from basics to clever tricks.
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 →SUMXMY2 Function in Excel: Sum of Squared Differences
SUMXMY2 Function in Excel: Sum of Squared Differences
Maths & trigLevel: ExpertAvailable in: Excel 2007+SUMXMY2 returns Σ(x - y)²: the squared error between forecasts and actuals.Syntax=SUMXMY2(array_x.
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 →LOG10 Function in Excel: Base-10 Logarithm
LOG10 Function in Excel: Base-10 Logarithm
LOG10 tells you the order of magnitude. Charts of values ranging from hundreds to crores are easier to read on a log scale.
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 →