calculating radix for logaritmical scale?

donalde · Apr 12th, 2002, 04:57 AM

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 -

Tim Francis-Wright · Apr 12th, 2002, 10:18 AM

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!

donalde · Apr 15th, 2002, 01:15 AM

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

Apr 12th, 2002, 10:18 AM	#2
Tim Francis-Wright Board Regular Join Date: Feb 2002 Posts: 74	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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 12th, 2002, 04:57 AM	#1
donalde Board Regular Join Date: Feb 2002 Location: Finland Posts: 72	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 -

Apr 15th, 2002, 01:15 AM	#3
donalde Board Regular Join Date: Feb 2002 Location: Finland Posts: 72	Tim, many thanks of your advice, it really helped. - donalde -