Welcome to the NavList Message Boards.


A Community Devoted to the Preservation and Practice of Celestial Navigation and Other Methods of Traditional Wayfinding

Compose Your Message

Add Images & Files
    Re: Two-body fix caveat
    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
    Anyway, thanks to Dave's help, I'm now quite a lot further ahead.
    NavList message boards: www.fer3.com/arc
    Or post by email to: NavList@fer3.com
    To unsubscribe, email NavList+unsubscribe@fer3.com

    File: 110463.quadfit.xls
    Browse Files

    Drop Files


    What is NavList?

    Join NavList

    (please, no nicknames or handles)
    Do you want to receive all group messages by email?
    Yes No

    You can also join by posting. Your first on-topic post automatically makes you a member.

    Posting Code

    Enter the email address associated with your NavList messages. Your posting code will be emailed to you immediately.

    Email Settings

    Posting Code:

    Custom Index

    Start date: (yyyymm dd)
    End date: (yyyymm dd)

    Visit this site
    Visit this site
    Visit this site
    Visit this site
    Visit this site
    Visit this site