+ Reply to Thread
Results 1 to 2 of 2

Best Fit in Excel

  1. #1
    Registered User
    Join Date
    08-04-2009
    Location
    Chicago, Illinois
    MS-Off Ver
    Excel 2003
    Posts
    1

    Best Fit in Excel

    Hello All:

    I am trying to compare an observed dataset with three best-fit models

    I wish to see which candidate model best fits the observed dataset.

    Is there any way to do this in Excel? I know there is a correlation of determination available, but I only know how to compare observed data with a best-fit model Excel creates.

    Thank you!!

    Jo

    PS: The datasets are not the same size (i.e. observed x=50 points, y=50 points. models x=1030 points, y=1030 points)

  2. #2
    Forum Expert sweep's Avatar
    Join Date
    04-03-2007
    Location
    Great Sankey, Warrington, UK
    MS-Off Ver
    2003 / 2007 / 2010 / 2016 / 365
    Posts
    3,454

    Re: Best Fit in Excel

    Hi, and welcome

    The linest function will give you an r squared value.

    There's detail here and here
    Rule 1: Never merge cells
    Rule 2: See rule 1

    "Tomorrow I'm going to be famous. All I need is a tennis racket and a hat".

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1