Results 1 to 3 of 3

Extrapolating Missing Data

Threaded View

  1. #3
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS 365 Family 64-bit 2502
    Posts
    26,995

    Re: Extrapolating Missing Data

    I took the liberty of doing what MrShorty suggested and the result is that a third-degree polynomial is a perfect fit for your existing data. Attached is a file that plots your points on a scatter graph. I tried various fits and the one shown has an R2 of 1, which is perfect (0 is no fit). The equation is shown on the chart. You can use that equation, where x is the Level, to give you the number of points for that level (y).

    The short answer to your question is Excel does not do interpolation* automatically by dragging values but it gives you enough tools to do it yourself.

    *Interpolation is filling in gaps within the known range of data, which is what we have here; extrapolation is extending your data outside the range for which actual data exists.
    Attached Files Attached Files
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

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. [SOLVED] 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