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
    Name or NavList Code:
    Email:
       
    Reply
    Re: Two-body fix caveat
    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
    -~----------~----~----~----~------~----~------~--~---
    
    

       
    Reply
    Browse Files

    Drop Files

    NavList

    What is NavList?

    Get a NavList ID Code

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

    A NavList ID Code guarantees your identity in NavList posts and allows faster posting of messages.

    Retrieve a NavList ID Code

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

    Email Settings

    NavList ID 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