Hi Jerry,
Do be aware that while Dave Braden's code might be the best option for
the job at hand, it has limitations. If I remember correctly, one of
them is that if a coefficient is 1, XL doesn't show it and the code
fails to handle that correctly. I have an improved version on some
computer but haven't shared it with the world because it has been tested
very lightly and, of course, XL2003 came along.
--
Regards,
Tushar Mehta
www.tushar-mehta.com
Multi-disciplinary business expertise
+ Technology skills
= Optimal solution to your business problem
Recipient Microsoft MVP award 2000-2005
In article ,
says...
Alternately, David Braden has posted VBA code to extract the
coefficients directly from the chart into cells
http://groups.google.com/groups?selm...54705032003%40...
The advantage of using the chart coefficients (either manually or via
Braden's code) is that LINEST (prior to Excel 2003) uses a numerically
poor algorithm that can give inaccurate results with some data sets.
The chart trendline (extracted by Braden's code) is much better numerically.
Jerry
Andy Pope wrote:
Hi,
You can get those values via formula, see this explanations.
http://www.stfx.ca/people/bliengme/E...Polynomial.htm
http://tushar-mehta.com/excel/tips/t...efficients.htm
Cheers
Andy
Miguel Saldana wrote:
I believe it will be useful to add an option to Excel that when adding
a tendline to a graph, Excel could ask in which cells it will store
the coefficients and exponents in the resulting trendline. In this
way, the user can use those coefficients in other calculations.