Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Celeste
 
Posts: n/a
Default The description of the ATAN2 function in Microsoft Excel is not 1.

The description of the ATAN2 function in Microsoft Excel help does not seem
100% accurate to me. It states "ATAN2(a,b) equals ATAN(b/a), except that a
can equal 0 in ATAN2. "

I don't think that is accurate because ATAN2 takes into account the quadrant
in which z lies and has the range of -pi to pi (excluding -pi). This
special inverse tangent uses the sign of x and y to determine the quadrant,
and allows for answers in quandrant 2 (-x, +y) and quadrant 3
(-x,-y) whereas the standard arctan is restricted to quadrants 1 and 4
(range of -pi/2 to +pi/2).

There are cases in which ATAN(y/x) does not equal ATAN2(x,y), other than
when x = 0. For example, when x = -5 and y =-15, ATAN(-15/-5) = 1.249 and
ATAN2(-5,-15) = -1.89

I'm not a math expert, but this description seems misleading to me. I
suggest a description similar to the C++ ATAN2(x,y) function "The atan2()
function computes the arc tangent of y/x, using the signs of the arguments to
compute the quadrant of the return value. "

  #2   Report Post  
Harlan Grove
 
Posts: n/a
Default

"Celeste" wrote...
The description of the ATAN2 function in Microsoft Excel help does not
seem 100% accurate to me. It states "ATAN2(a,b) equals ATAN(b/a), except
that a can equal 0 in ATAN2. "

....

Yes, this is inaccurate except for x and y 0.

There are cases in which ATAN(y/x) does not equal ATAN2(x,y), other than
when x = 0. For example, when x = -5 and y =-15, ATAN(-15/-5) = 1.249 and
ATAN2(-5,-15) = -1.89


This has everything to do with quadrants. In this case, the ATAN result is
angularly displaced 180 degrees from the ATAN2 result. The ATAN result is
1.249 radians counterclockwise from the positive X axis, and the ATAN2
result is 1.89 radians clockwise from the positive X axis, which happens to
be 1.249 radians counterclockwise from the negative X axis.

I'm not a math expert, but this description seems misleading to me.
I suggest a description similar to the C++ ATAN2(x,y) function . . .


You're making the understandable but naive assumption anyone within
Microsoft wants to expend any effort or resources fixing their
documentation. This isn't the only place Excel's documentation (aka online
help) is misleading or just plain wrong.


  #3   Report Post  
Tushar Mehta
 
Posts: n/a
Default

Hi Celeste,

You are right. ATAN2 can do with a better explanation. As can many
other XL functions. {g}

I'll see if someone among my limited contacts within MS -- I am not
particularly astute at networking {vbg} -- is willing to follow up and
improve the documentation. But, I wouldn't hold my breath expecting a
change any time soon.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article ,
says...
The description of the ATAN2 function in Microsoft Excel help does not seem
100% accurate to me. It states "ATAN2(a,b) equals ATAN(b/a), except that a
can equal 0 in ATAN2. "

I don't think that is accurate because ATAN2 takes into account the quadrant
in which z lies and has the range of -pi to pi (excluding -pi). This
special inverse tangent uses the sign of x and y to determine the quadrant,
and allows for answers in quandrant 2 (-x, +y) and quadrant 3
(-x,-y) whereas the standard arctan is restricted to quadrants 1 and 4
(range of -pi/2 to +pi/2).

There are cases in which ATAN(y/x) does not equal ATAN2(x,y), other than
when x = 0. For example, when x = -5 and y =-15, ATAN(-15/-5) = 1.249 and
ATAN2(-5,-15) = -1.89

I'm not a math expert, but this description seems misleading to me. I
suggest a description similar to the C++ ATAN2(x,y) function "The atan2()
function computes the arc tangent of y/x, using the signs of the arguments to
compute the quadrant of the return value. "


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
SUMIF function yak10 Excel Worksheet Functions 0 February 12th 05 06:12 PM
Trim function doesn't clean out ASCII Code 160 (Space) Ronald Dodge Excel Worksheet Functions 6 January 27th 05 04:48 AM
recherche into a special range Maileen Excel Worksheet Functions 6 December 28th 04 04:16 PM
Formula to list unique values JaneC Excel Worksheet Functions 4 December 10th 04 01:25 AM
HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. Robert AS Excel Worksheet Functions 4 December 2nd 04 11:49 AM


All times are GMT +1. The time now is 11:05 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"