Discussion Overview
The discussion revolves around using Excel (Vista) to perform trigonometric calculations with angles expressed in degrees rather than radians. Participants explore how to convert degrees to radians for functions like sine and cosine, and whether it is possible to directly use degrees in these functions.
Discussion Character
- Technical explanation
- Debate/contested
Main Points Raised
- One participant asks how to reverse angles from radians to degrees for trigonometric functions in Excel.
- Another participant suggests using the functions =RADIANS(Angle) and =DEGREES(Angle) for conversions.
- A different participant expresses confusion about needing to convert degrees to radians to obtain correct trigonometric function results, citing an example where =sin(90) yields 0.893997 while =sin(radians(90)) yields 1.
- One participant confirms that it is necessary to use =sin(radians(90)) for correct results.
- Another participant proposes dividing the angle in degrees by 57.29577951 as a method to convert to radians.
- A later reply notes that most software and programming languages use radians, suggesting that users should become accustomed to this standard.
Areas of Agreement / Disagreement
Participants express differing views on the necessity of converting degrees to radians for trigonometric functions, with some affirming the need for conversion while others question it. The discussion remains unresolved regarding the possibility of using degrees directly in these functions.
Contextual Notes
There are assumptions about the behavior of Excel functions and the standard practices in programming that are not fully explored, particularly regarding the handling of angles in different units.
