« Special Characters | Main | A Simple Macro: Fibonacci Numbers »
September 03, 2004
Generating the nth roots of a number
The builtin OOo Calc function SQRT returns the square root of it's numerical argument. There are no
builtin functions for cube roots or higher - but you can use the exponentiation operator to derive any
order of root - as is illustrated below.
As you may notice, the parentheses are required in the example - because of the higher order of
precedence of the "^" operator over "/". If you are not sure of the precedence rules - it is better
to add the parentheses anyway - as it makes for more legible equations.
Posted by Dave at September 3, 2004 06:20 AM
Comments
I am using OO V2.0 on Win/XP. When trying to create a trend line, I open Object Properties, to get the Data Series dialogue, then click on Statistics. According to your web page, I should see a trend line selection list for linear regression, however I don't.
Is this a version difference, maybe?
Thanks.
Posted by: Paul at November 28, 2005 11:20 AM