I want to find the cosine of a degree measure. My formula is =COS(DEGREES(G4)) where G4 is (-56.3). The answer excel spits out is -0.79, while my calculator says it is 0.55. I'm not sure where the incorrect answer is coming from, because -0.79 isn't the correct answer in radians either.
This is Excel '13 and this calculation is part of a college physics lab.
If G4 is in degrees, then use =cos(radians(G4))
If it's in radians, use =cos(G4)
Entia non sunt multiplicanda sine necessitate
The angle must be in radians.
Please Login or Register to view this content.
My General Rules if you want my help. Not aimed at any person in particular:
1. Please Make Requests not demands, none of us get paid here.
2. Check back on your post regularly. I will not return to a post after 4 days.
If it is not important to you then it definitely is not important to me.
Wow, that's a little counterintuitive, don't you think? Thanks for helping, guys!
No, it's pretty intuitive. Radians are the natural measure of an angle, and the algorithms (Taylor series) that calculate trig functions all use radians. Degrees is an arbitrary division into 360 degrees.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks