Thread: Excel Math Bug
View Single Post
  #56   Report Post  
Posted to microsoft.public.excel.programming,sci.math
fred fred is offline
external usenet poster
 
Posts: 26
Default Excel Math Bug

I found a little more on this at:

http://www.macnauchtan.com/pub/precedence.html

It says that many softwares don't comply with 'chalkboard' math rules.

---------------------------------------------------------------------------


Microsoft Excel 4 CAUT[ion] Index
A B C
1 2.0 2 numeric entry
2 = - A1^2 4 return is positive
3 = - A1^2 / 4 1 return is positive
4 = - + A1^2 4 return is +4 without error message

Microsoft acknowledges the disconnect with chalkboard algebra for all
versions of Excel calling it an "unexpected positive value" but argues that
the result is correct because of their order of operations. The suggested
workaround is to use prophylactic parentheses.


----------------------------------------------------------------------------
----
Microsoft Excel 2001 CAUT[ion] Index
A B C
1 2.0 2 numeric entry
2 =-A1^2 4 return is positive
3 =2 2
4 =5 5
5 = - A3^2 / (-A3^2-A4^2) - A4^2 / (-A3^2-A4^2) 1 return is positive
6 =(- A4^2 - A3^2) / (- A3^2 - A4^2) -1 return is negative

The behavior is the same as Excel 4 but note that macros and user defined
functions written in VBA work the opposite way. A user defined function
avoids the unary minus interpretation just as, say, = - SQRT(A1) would.

In the help documentation for Excel 2001 one finds, for the error function
add-in, this definition:



But what is that -t2? The kernel of the integral is exp(-t^2) and the reader
is invited to make a plot of that. You will create a curve,which has value 1
at t = 0 and increases exponentially at each side. It's a far cry from the
infamous Bell Curve that is the correct Gaussian form for the error
function. One needs to call out exp(0-t^2) or exp (-(t^2)) in Excel.