| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how can I perform trig. functions usings grads 400deg per circle | Excel Worksheet Functions | |||
| Can I get Excel to determine the line curve formula without graph. | Excel Discussion (Misc queries) | |||
| User-defined functions created in Excel 2000 fail in Excel 2003 | Excel Discussion (Misc queries) | |||
| Database functions should use criteria in formula, as 1-2-3 does | Excel Worksheet Functions | |||
| Visible rows and functions that work | Excel Worksheet Functions | |||
Hybrid Mode
