Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: calculating radix for logaritmical scale?

  1. #1
    Board Regular
    Join Date
    Feb 2002
    Location
    Finland
    Posts
    76
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I was wondering, if there is method for calculating radix for logarhitmical scale.

    I have values like this:
    A B
    809,4 2741,92
    1567,68 5483,85
    2351,52 8225,78
    3435,36 10967,71
    4703,04 16451,56

    C D
    502 3889,31
    755 4486,45
    1156 6670,07
    1435 9108,07
    2129 12928,26
    2809 17802,73

    I want to have chart where B and D are displayed (Y-axis) and values of A and C specify X-axis. So, is there way to calculate redix for logaritmical scale in x-axis? I could try by just testing values for redix, but since cases like this appear quite often in my work, I want to know if there is any good method for calculating, not guessing.

    - donalde -

  2. #2
    Board Regular
    Join Date
    Feb 2002
    Posts
    75
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Check out the online help for the LOGEST function}: it tries to fit data to the
    form y = b * m^x
    I think that m would be your radix.

    LOGEST is an array function, so you will
    need to use Ctrl-Shift-Enter instead
    of Enter when you use it.

    Good luck!
    "Interfere? Of course we should interfere! Always do what you're best at, that's what I say!" -- The Doctor, Nightmare of Eden

  3. #3
    Board Regular
    Join Date
    Feb 2002
    Location
    Finland
    Posts
    76
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Tim, many thanks of your advice, it really helped.
    - donalde -

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •