+ Reply to Thread
Results 1 to 2 of 2

Need to derive curve from values, then apply curve to another data set

  1. #1
    Registered User
    Join Date
    09-28-2012
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    53

    Need to derive curve from values, then apply curve to another data set

    I have a data set (Set#1) that consists of a positional rank (1-240) and a dollar value ($46-$1) for each positional rank. It's not a straight line set.

    DataSet.JPG

    What I need to do is take that curve and apply it to another data set (Set#2) (1-240) and assign a dollar value ($46-$1) to each positional rank.

    A "corner cutting" way of doing it would be an Index/Match to simply carry over the dollar value from (for example) #45 from my Set#1 to #45 in my Set#2. This could work reasonably well with data sets of the same size, but mine aren't always the same size, so I need to apply the curve itself. I imagine I'll probably have to work with percentiles and such, but I'm just not sure how to go about this.

    Any ideas?

  2. #2
    Forum Contributor Gregor y's Avatar
    Join Date
    10-24-2011
    Location
    Colorado, USA
    MS-Off Ver
    Excel 2010 32-Bit
    Posts
    204

    Re: Need to derive curve from values, then apply curve to another data set

    This reminds me of highschool physics, in which we solved this by a using a change of axies. So you do a linear fit to g(x) vs f(y), and solve f(y)=m*g(x)+b for y to get your equation.

    looks like your data fits a y=1/x curve. Setup the following data table

    Data Table Example.png

    note: in the exampel g(x)=x, and f(y)=1/y

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Graph a curve, then enter data to generate new similar curve
    By denphi03 in forum Excel Charting & Pivots
    Replies: 11
    Last Post: 11-03-2013, 05:33 PM
  2. Normal distribution curve / Bell curve
    By LAG1 in forum Excel General
    Replies: 0
    Last Post: 05-24-2012, 07:20 AM
  3. Finding values based on the standard curve - Pls help
    By Wilsern in forum Excel General
    Replies: 4
    Last Post: 08-25-2011, 09:30 PM
  4. Adding curve values
    By jeastman in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 03-21-2011, 10:39 AM
  5. curve fitting a charging capacitor type curve
    By mcgradys in forum Excel General
    Replies: 4
    Last Post: 11-15-2005, 08:50 AM

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