StatisticsLevel: ExpertAvailable in: Excel 2007+
In this article
- Syntax
- Examples
- Example 1
- Related functions
LOGEST fits y = b·mˣ and returns m (the growth factor) and b. m of 1.05 means 5% growth per period.
Syntax
=LOGEST(known_ys, [known_xs], [const], [stats])
| Argument |
What it means |
known_ys |
Positive values. |
Examples
Example 1
=INDEX(LOGEST(C2:C13, A2:A13), 1) - 1
Average monthly growth rate of sign-ups.
GROWTH · LINEST
📚 Part of the free Excel course: Beginner → Expert · Try it in the Formula Lab or ask the AI Helper.
✨ Ask AI about this articleStuck on a step? Ask a question and the AI answers using this article.
Free · AI can be wrong