LOGEST Function - explantion of calculations

P

peter.banthorpe

Does anyone have a workbook that breaks down the LOGEST calculation
from scratch?

I'm trying to better understand what the function is doing and would
like to reproduce the function's results step-by-step in a workbook.
In particular, I'm trying to understand the standard errors calculation.
 
B

Bernard Liengme

DO you understand how LINEST works.
It does a least-squares fit to the (x,y) data pairs using standard
regression equations found in most statistics text books
LOGEST just fits (x, ln(y)) data pairs
Suppose your x-values are in A2:A21 and y-values are in B2:B21; in C2 enter
=LN(B2) and copy down to C21
Now you could use LINEST on the C and A columns. LOGEST just saves you the
trouble.
For more see
http://people.stfx.ca/bliengme/ExcelTips/ExponentialTrendline& LOGEST.htm
 
Top