Results 1 to 3 of 3

Extrapolating Missing Data

Threaded View

  1. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP, 2007, 2024
    Posts
    16,391

    Re: Extrapolating Missing Data

    What specifically do you need help with?

    If this is a "I have no idea where to begin" kind of thing, here's how I would analyze the data:
    1) put the data in a spreadsheet -- level in one column and exp in a second column
    2) Plot the data on a scatter plot with one column along the x axis and one column on the y axis.
    3) Look at the chart and see if anything obvious becomes apparent.
    3a) Switch X and or Y axes between linear an logarithmic to see if this causes the data to form a straight line
    3b) compare the shape of the curve with the usual families of curves (quadratic, exponential, logarithmic, square root, etc.) that I recall from algebra/calculus. If you need a refresher on these: http://mathfortress.com/Precalculus/...0Functions.pdf
    4) Hopefully at the end of step 3, I have some idea of what the regression equation should look like, so I set up the regression. Exactly how to set up this regression depends on my conclusions at the end of step 3.

    With the problem broken down in steps, where do you get stuck?
    Last edited by MrShorty; 05-13-2016 at 10:51 PM.
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Extrapolating data
    By sherlock1241 in forum Excel General
    Replies: 3
    Last Post: 04-21-2015, 12:03 PM
  2. Extrapolating data over time
    By Dan Shorer in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-20-2014, 04:07 PM
  3. [SOLVED] Extrapolating data from a three-variables chart
    By Noero in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 10-02-2014, 05:59 PM
  4. Extrapolating data within a table
    By MacroIdiot in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-25-2011, 12:20 PM
  5. Extrapolating spreadsheet data
    By djohnalyn in forum Excel General
    Replies: 4
    Last Post: 07-06-2011, 05:58 PM
  6. Extrapolating Data from 1 Period to Another?
    By stviking in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 10-07-2008, 08:49 AM
  7. extrapolating data from chart
    By tricard@gmail.com in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 01-31-2006, 06:45 PM

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