How do I find arctanh() in exel
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 "¹³"
|