How to use tan function in micosoft works spreadsheet

Click For Summary

Homework Help Overview

The discussion revolves around using the tangent function in Microsoft Works spreadsheet to calculate angles in a right triangle, specifically focusing on the inverse tangent function. Participants explore how to implement this function and clarify the default settings for angle measurement in the software.

Discussion Character

  • Exploratory, Conceptual clarification, Mathematical reasoning

Approaches and Questions Raised

  • Participants discuss the use of the inverse tangent function, with one suggesting the use of "asin(x)" and another mentioning the "ATAN2" function for angle calculation. There are questions regarding the default measurement units (degrees or radians) in Microsoft Works.

Discussion Status

Some participants have provided guidance on using specific functions and noted the behavior of angle outputs. There is acknowledgment of the need to be cautious about the order of arguments in the "atan2" function. The original poster has expressed gratitude for the clarification regarding radians.

Contextual Notes

One participant introduces a complex scenario involving radiation between two spheres, which may indicate a shift in focus from the original question about the tangent function.

philrainey
Messages
88
Reaction score
0

Homework Statement


IN microsoft works spread sheet how do you insert a inverse tan function. that is I know the opposite and adjacent side lengths but want to use the tan function to find the angle of a right angle triangle.Please help ,simple I know but I just can't work out how to do it. Does microsoft works work in degrees rads or grad by default?


Homework Equations





The Attempt at a Solution

 
Last edited:
Physics news on Phys.org
If it's the same as all the other versions of excel then it is "asin(x)"
the result is returned in radians, you can etiher use degress(asin(x)) or simply multiply by 57.3
 
=DEGREES(ATAN2(x,y)) will return an angle in any quadrant

Experimenting, I find that the return value, theta ranges as -180 < theta <= 180.
 
Last edited:
One thing to be careful of, excel's atan2() function has the arguments in the opposite order to most libraries which are atan2(y,x), since atan2(y,x) = atan(y/x)
 
Yes thankyou it works in radians. I was trying to work out a question where there is a little sphere inside a big sphere with a perfect vacuum inbetween.the big sphere been 0.13m dia. and 1550 degrees kelvin hot. The little sphere .1m dia. and 1500 degrees kelvin. All of the radiation from the little sphere hits the big but some from the big misses the small and hits itself.What is the net radiation between them ?
 

Similar threads

  • · Replies 10 ·
Replies
10
Views
3K
Replies
17
Views
3K
  • · Replies 20 ·
Replies
20
Views
3K
Replies
3
Views
2K
  • · Replies 2 ·
Replies
2
Views
2K
  • · Replies 2 ·
Replies
2
Views
2K
  • · Replies 4 ·
Replies
4
Views
3K
  • · Replies 3 ·
Replies
3
Views
2K
  • · Replies 14 ·
Replies
14
Views
10K
  • · Replies 1 ·
Replies
1
Views
2K