+ Reply to Thread
Results 1 to 1 of 1

Linear interpolation

  1. #1
    Registered User
    Join Date
    04-25-2009
    Location
    SLC, Utah
    MS-Off Ver
    Excel 2003
    Posts
    5

    Linear interpolation

    I have some data from a test I need to find the point that the subject crosses, first inflection, 2.0, 3.0, 4.0 and last mark above 4.0. (Column D) on the test then give the interpolated value from (column A and C)
    A C D
    Means Sum Increase Point
    100 130 0.9
    130 133 1.1
    160 142 1.2
    190 153 2.4
    220 160 4.3
    250 168 7.2
    280 173 9.1


    I then need to plot this in the graph at the 2.0 mark and give the number the vertical line crosses from the interpolation in a chart below the graph. I need to do the same thing at first inflection, 2.0, 3.0, 4.0 and the point just above 4.0 or in this case 4.4. Then plot vertical lines at each point on the graph. I attached a sample excel sheet for reference, it does not have any macros or other bugs.

    As I have the numbers already for this sample they would look something like this:
    First Inflection (i.e. Above 1.0 and significant increase in column C) This one is easy as it is always the exact values.
    Means=160
    Sum=142

    2.0
    Means 182
    Sum 150

    3.0
    Means 200
    Sum 156

    4.0
    Means 216
    Sum 159

    Above in this case 4.3
    Means 222
    Sum 161

    Thanks for any help you can give.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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