NavList:
A Community Devoted to the Preservation and Practice of Celestial Navigation and Other Methods of Traditional Wayfinding
Re: Two-body fix caveat
From: George Huxtable
Date: 2009 Nov 5, 08:46 -0000
From: George Huxtable
Date: 2009 Nov 5, 08:46 -0000
Dave Walden promptly responded to my request for help with Excel's trend-fitting ability. He advised- "You can get more significant figures from the box on the plot by editing the format of the text in the box and changing the number decimal places displayed." Which were just the words I needed. Of course! That seems obvious (now) but it's been bugging me for ages. Thanks, Dave. ======================== However, his other suggestion- "The Excel function "linest", lets you get at the coefficients from a regression and manipulate them in cells." doesn't look as if it will help, for me. The manual, and the help file, both tell me that LINEST is for fitting straight lines to data, whereas I need a polynomial (quadratic), fit. Which must be available, internally within Excel, in order for it to produce that quadratic trend line on a graph.. I wonder whether this difficulty relates to the old version of Excel that I'm using (2000). Perhaps, later development has made that LINEST function more versatile.Or perhaps there's a different function, for fitting polynomials. Anyway, thanks to Dave's help, I'm now quite a lot further ahead. George. contact George Huxtable, at george@hux.me.uk or at +44 1865 820222 (from UK, 01865 820222) or at 1 Sandy Lane, Southmoor, Abingdon, Oxon OX13 5HX, UK. --~--~---------~--~----~------------~-------~--~----~ NavList message boards: www.fer3.com/arc Or post by email to: NavList@fer3.com To , email NavList+@fer3.com -~----------~----~----~----~------~----~------~--~---