Square Root

[Sadik]

How does one calculate the Nth square root of X. Is there
a function? Anyone has formula to acomplish this? Thanks
for your help.

Regards
Sadik

 

[Frank Kabel]

Hi Sadik
try
=POWER(value,1/n)
or
=value^(1/n)

Frank

 

[Sadik]

Frank,

Thanks a lot. Its so easy when you know it. Thanks.

Regards
Sadik

 

[Earl Kiosterud]

Sadik,

Not to be picky, but for what it's worth, you're asking for the "nth root of
x," not square root.

 

[Jonathan Rynd]

Not to be picky, but for what it's worth, you're asking for the "nth
root of x," not square root.

It's the notation that's confusing. Square root is written like this:
_______
/
'\ / 25
\/

but the nth root is written like this:

_______
n /
'\ / 25
\/

It's easy to look at that change and think "this is the same thing as
square root plus an n, so it's the nth square root"

The problem is that
_______
/
'\ / 25
\/

is a shorthand notation for
_______
2 /
'\ / 25
\/

and terminology is weird that we say the "square root" instead of "second
root".

 

[Earl Kiosterud]

Jonathan,

I agree. In the absence of a number, it's presumed to be 2.

As an aside, you should work in audio, where presumptions lead people quite
astray. My favorite is "RMS Power," a fairly misunderstood and essentially
meaningless term. It even has to do with squares and square roots.

 

[Stuart]

Or try explaining the impact of harmonics on three phase power systems.

Jonathan,

I agree. In the absence of a number, it's presumed to be 2.

As an aside, you should work in audio, where presumptions lead people quite
astray. My favorite is "RMS Power," a fairly misunderstood and essentially
meaningless term. It even has to do with squares and square roots.

 

[Stuart]

And since we have gone to power systems explain the use of the square root of -1
Or try explaining the impact of harmonics on three phase power systems.

Jonathan,

I agree. In the absence of a number, it's presumed to be 2.

As an aside, you should work in audio, where presumptions lead people quite
astray. My favorite is "RMS Power," a fairly misunderstood and essentially
meaningless term. It even has to do with squares and square roots.