Let me add a little bit here: When using math formulas, one should know about the parsing rules form complex expression which do not have all the necessary parenthesis.
Different systems do have different parings rules. In the case of a^b^c, the expression is ambiguus because (as mentioned in a previous mail) in general (a^b)^c != a^(b^c) To avoid unintended consequences, just us parentheses and you will get the right result. in the case of -a^b The question is the order of precedence of unary - and binary ^. In Excel, -2^2=4, but 0-2^2=-4 Reason: For Excel, unary - is stronger than the power operator, but binary minus is weaker. My feeling is that too many people are bashing spreadsheets for the wrong reason. Spreadsheets ca do things R cannot do: Automatic recalculation when input changes, and visual point and click modelling of dependencies. The calculation engine of Excel admittedly has some weak points. That is the reason why I wrote RExcel which gives you all the advantages of the spreadsheet interface and allows you to use the R calculation within this interface whenever needed.
signature.asc
Description: Message signed with OpenPGP using GPGMail
______________________________________________ R-help@r-project.org mailing list -- To UNSUBSCRIBE and more, see https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.