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 →Atul Vij
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 →LOG Function in Excel: Logarithm to Any Base
LOG Function in Excel: Logarithm to Any Base
LOG answers “what power gives this number?” — how many doublings, how many digits.
Read article →Google Sheets vs Excel: What Each Is Actually Better At
Google Sheets vs Excel: What Each Is Actually Better At
An honest comparison from daily use: collaboration, formulas, data size, automation, offline use and cost — plus the functions that behave differently and how…
Read article →