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

1. ## 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. ## 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

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

#### 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