View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Claus Busch Claus Busch is offline
external usenet poster
 
Posts: 3,872
Default Trendline formula does not mimic actual trendline

Hi Ottmar,

Am Wed, 23 Sep 2015 20:38:48 +0200 schrieb Claus Busch:

you get the exactest trendline with a XY chart. I got the formula
y=1,2416*e^0,4058*X
and with this formula the Calc time looks like this:
3,0318
3,2881
3,5661
3,8676
4,1946
4,5492
4,9339
5,3510
5,8034
6,2940
6,8262


please look he
https://onedrive.live.com/redir?resi...=folder%2cxlsm
for "Trendline"


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional