logarithmic scale starting with 0



I'm trying to interpolate between to numbers using the logarithm
function.
I divided the inteval between the numbers in 20 parts and use the
equation in:
http://www.mpip-mainz.mpg.de/~deserno/science_notes/log_interpol/log_...

to compute the value at each step.
My problem is that my interval begins with 0.
I've already been suggested to shift the graph by 1. In this way the
equation becomes:
x = (x2 + 1)^f * (x1+1)^(1-f) - 1
But it doesn't work. If I use log10 on the interval [0;100] and f, the
position of the point of which I need the interpolated value, is 1/2 x
should be 10, but the equation gives another number.
Any suggestions?

.



Relevant Pages

  • RE: Selecting data in tables, if not given then interpolating
    ... I have a similar problem where I want to interpolate values between entries ... Have been looking through many help sites like this one and have concluded ... that Excel can't interpolate. ... in the table would make a straight line on a graph. ...
    (microsoft.public.excel.programming)
  • RE: Selecting data in tables, if not given then interpolating
    ... that Excel can't interpolate. ... in the table would make a straight line on a graph. ... and change the relevant cell values in order to interpolate the ... For my tables, I copied the table on one worksheet, kept the calculations on ...
    (microsoft.public.excel.programming)
  • Re: Logarithmic Interpolation
    ... interpolate the FFT logarithmically, shift the contents towards ... interpolate back to linear form, ... Since adding to log frequency is the same as multiplying linear ...
    (comp.dsp)
  • Re: qr + shift
    ... it's because shift *is* a function. ... As OP's example shows, variables interpolate, functions don't. ... It doesn't matter whether the interpolated string is ...
    (perl.beginners)
  • RE: Linear Interpolation
    ... In order to come up with the interpolation formula just graph ... the source data and add a linear trend line. ... Now most of the time the value for cell I6 ... Always "interpolate" between points even when an exact match is found in ...
    (microsoft.public.excel.programming)