Welcome to the NavList Message Boards.

NavList:

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

Compose Your Message

Message:αβγ
Message:abc
Add Images & Files
    or...
       
    Reply
    Re: Two-body fix caveat
    From: George Huxtable
    Date: 2009 Nov 6, 22:02 -0000

    Dave Walden wrote, about a suitable Excel function for fitting polynomials
    
    "Using excel 2000, this works!", and showed the LINEST function being used
    to do exactly that job.
    
    Thanks, Dave, that certainly answers my question, and also provides a useful
    example of how to use that function.
    
    But why, I wonder, does Excel's Help file describe that function so
    differently, as a way of fitting to one or more variables that all make a
    LINEAR contribution to the result? I can find no reference, in Excel 2000's
    Help, to any way of using LINEST on quadratic and higher terms.
    
    And I'm trying to see how you restrict  LINEST to fit a polynomial up to a
    certain order. Whether, that is, you ask for a linear fit, a quadratic fit,
    a cubic fit, and so on. What specifies that, in your spreadsheet?|
    
    George.
    
    contact George Huxtable, at  george{at}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 unsubscribe, email NavList+unsubscribe@fer3.com
    -~----------~----~----~----~------~----~------~--~---
    
    

       
    Reply
    Browse Files

    Drop Files

    NavList

    What is NavList?

    Join NavList

    Name:
    (please, no nicknames or handles)
    Email:
    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:

    Email Settings

    Posting Code:

    Custom Index

    Subject:
    Author:
    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