Hello everyone!
I would like to figure out the formula for the given two columns of data.
The data:
X Axis = 0.5|0.75|1.0|1.5|2.5|3.5|4.5|7.5|15.0|25.0|35.0|45.0
(Numbers separated by vertical lines for ease of viewing)
Y Axis = (number's too large to list here...see below
1.509E-09 (this number corresponds to the 0.5 column)
1.111E-09 (this number corresponds to the 0.75 column)
8.536E-10 (ETC...)
5.001E-10
2.647E-10
1.788E-10
1.206E-10
5.231E-11
1.711E-11
1.248E-11
3.737E-11
6.706E-11
Should be a reverse exponential curve! I would like the formula to figure out the value that falls between the given numbers. Example: If I have a number (x axis) that falls between 7.5 & 15...say 10.1, I would like the formula to figure out the y-axis number...the number should fall between these to numbers: 5.231E-11 (which represents the 7.5) & 1.711E-11 (which represents the 15.0). I would like to set this formula up in Excel in a way that I could just type in a value and it will spit out the y-axis number.
I had a dos program that used to extrapolate these numbers but it's an old program and wont work on my computer.
I have about 15 sets of numbers that will have a different formula...so if you have time could you go over how to set up the data to get the formula. I want to thank you in advance for the effort on your part to help me out. Much appreciative!
I would like to figure out the formula for the given two columns of data.
The data:
X Axis = 0.5|0.75|1.0|1.5|2.5|3.5|4.5|7.5|15.0|25.0|35.0|45.0
(Numbers separated by vertical lines for ease of viewing)
Y Axis = (number's too large to list here...see below
1.509E-09 (this number corresponds to the 0.5 column)
1.111E-09 (this number corresponds to the 0.75 column)
8.536E-10 (ETC...)
5.001E-10
2.647E-10
1.788E-10
1.206E-10
5.231E-11
1.711E-11
1.248E-11
3.737E-11
6.706E-11
Should be a reverse exponential curve! I would like the formula to figure out the value that falls between the given numbers. Example: If I have a number (x axis) that falls between 7.5 & 15...say 10.1, I would like the formula to figure out the y-axis number...the number should fall between these to numbers: 5.231E-11 (which represents the 7.5) & 1.711E-11 (which represents the 15.0). I would like to set this formula up in Excel in a way that I could just type in a value and it will spit out the y-axis number.
I had a dos program that used to extrapolate these numbers but it's an old program and wont work on my computer.
I have about 15 sets of numbers that will have a different formula...so if you have time could you go over how to set up the data to get the formula. I want to thank you in advance for the effort on your part to help me out. Much appreciative!