How do I find arctanh() in exel
"Dana DeLouis" wrote:
a = 6,378,137.0 (Semi-major axis...)
Hi. Just note that your units are not consistent.
a 6378.137
b 6356.75231424518
e 0.0818191908426215
=2*PI()*(POWER(a,2)+(POWER(b,2)*ATANH(e))/e)
510,065,621.724088
= = =
HTH
Dana DeLouis
Neville wrote:
Please help me with a formular I need to enter into an exel spreedsheet cell;
Surface area of the Earth =
A = 2πaSQRT+π(bSQRT/e)ln[(1+e)/(1e)] = (answer 510065621.724)
or (= 2π[aSQRT+(bSQRT/e)arctanh(e)])= (answer 510065621.724)
where
a = 6,378,137.0 (Semi-major axis = equatorial radius = a)
b = 6,356,752.314245180 (Semi-minor axis = polar radius = b)
e = 0.08181919084262150(first eccentricity)
I get stuck with the symbols "ln" and "arctanh"
Radius of sphere of equal surface area = ½(A/π) = (answer 6371007.1809)
I get stuck with the symbol ""
Radius of sphere of equal volume = (¾V/π)¹³ = (a2b)¹³ = (answer
6,371,000.790)
where "V" volume = 1,083,207,319,801.0
I get stuck with the symbol "¹³"
Thanks Rick and Dana,
All my calculations in the spreadheet are now completed and a 100% correct,
both of you have helped me from pulling my hair out, thanks again.
Nev.
|