ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Trig functions (https://www.excelbanter.com/excel-worksheet-functions/112280-trig-functions.html)

Kokopeelle

Trig functions
 
I have been studing the early formation fo trig tables by Ptolemy abotu
100-200Ad. I now would like to know the methodolgy tht ecel uses for
calculating these functions. I'm not interested in the detailed code, just
the general methods.

Can anyone help?
--
rk koko pele

paul

Trig functions
 
the excel functions for trig are
COS
ACOS
ACOSH
COSH
SIN
ASIN
SINH
ASINH
TAN
ATAN
TANH
ATANH
RADIANS
DEGREES
excel works in radians by default so the radians and degree function are
there to swap back and forth
--
paul

remove nospam for email addy!



"Kokopeelle" wrote:

I have been studing the early formation fo trig tables by Ptolemy abotu
100-200Ad. I now would like to know the methodolgy tht ecel uses for
calculating these functions. I'm not interested in the detailed code, just
the general methods.

Can anyone help?
--
rk koko pele


Bernard Liengme

Trig functions
 
My bet is that Excel uses a series expansion
sin(x) = x -x^3/3! + x^5/5! - x^7/7! ...

Google on binomial, Taylor and Maclaurin series to learn more (or read a
math textbook)
best wishes

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Kokopeelle" wrote in message
...
I have been studing the early formation fo trig tables by Ptolemy abotu
100-200Ad. I now would like to know the methodolgy tht ecel uses for
calculating these functions. I'm not interested in the detailed code,
just
the general methods.

Can anyone help?
--
rk koko pele




Dana DeLouis

Trig functions
 
My guess would be some version of the "CORDIC algorithm."
One of many search hits:
http://www.dspguru.com/info/faqs/cordic2.htm (See 2.1)

http://www.andraka.com/cordic.htm
etc..
--
Dana DeLouis
Windows XP & Office 2003


"Bernard Liengme" wrote in message
...
My bet is that Excel uses a series expansion
sin(x) = x -x^3/3! + x^5/5! - x^7/7! ...

Google on binomial, Taylor and Maclaurin series to learn more (or read a
math textbook)
best wishes

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Kokopeelle" wrote in message
...
I have been studing the early formation fo trig tables by Ptolemy abotu
100-200Ad. I now would like to know the methodolgy tht ecel uses for
calculating these functions. I'm not interested in the detailed code,
just
the general methods.

Can anyone help?
--
rk koko pele







All times are GMT +1. The time now is 04:55 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com