NavList:
A Community Devoted to the Preservation and Practice of Celestial Navigation and Other Methods of Traditional Wayfinding
Re: Two-body fix caveat
From: Dave Walden
Date: 2009 Nov 5, 08:05 -0800
From: Dave Walden
Date: 2009 Nov 5, 08:05 -0800
I say: Using excel 2000, this works! george said: 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. --~--~---------~--~----~------------~-------~--~----~ NavList message boards: www.fer3.com/arc Or post by email to: NavList@fer3.com To , email NavList+@fer3.com -~----------~----~----~----~------~----~------~--~---
File: 110463.quadfit.xls
