Syntax
=LOGEST(known_ys, [known_xs], [const], [stats])Arguments
| Argument | Required | Description |
|---|---|---|
known_ys | Required | The dependent values (positive) |
known_xs | Optional | The independent values (1, 2, 3... when left out) |
const | Optional | TRUE or left out to calculate b, FALSE to force b to 1 |
stats | Optional | TRUE to also return the regression statistics |
How to use LOGEST
When LOGEST returns more than one value, the result spills into the cells below and to the right. Keep those cells empty, or you get #SPILL!.
LOGEST takes 1 required argument and 3 optional arguments. Type =LOGEST( in a cell and SheetsBat shows the arguments as you go. Optional arguments are shown in square brackets; leave them out to use their default.
Examples
Each result below was calculated by the SheetsBat formula engine.
=LOGEST({33100;47300;69000;102000;150000;220000}, {11;12;13;14;15;16})Result Spilled result
| A | B | |
|---|---|---|
| 1 | 1.463275628 | 495.3047702 |
=LOGEST({2;4;8})Result Spilled result
| A | B | |
|---|---|---|
| 1 | 2 | 1 |
Related statistical functions
- INTERCEPTReturns where the best fit straight line crosses the y axis.
- KURTReturns the kurtosis of the numbers (how peaked or flat their distribution is).
- LARGEReturns the k-th largest number in a list.
- LINESTFits a straight line (or a plane for several x columns) by least squares and returns its coefficients and optional statistics.
- LOGNORM.DISTReturns the lognormal distribution of x, where ln(x) is normally distributed.
- LOGNORM.INVReturns the inverse of the cumulative lognormal distribution.
- MAXReturns the largest number.
- MAXAReturns the largest value, counting text as 0 and TRUE as 1.
- MAXIFSReturns the largest number among the cells that meet all conditions.