On 9/25/2007 7:45 AM, (Ted Harding) wrote: > On 25-Sep-07 11:11:44, Patrick Burns wrote: >> Just speaking of the field I'm most familiar with, there >> are now users of R in many of the largest financial >> companies in the world. >> >> http://www.burns-stat.com/pages/Tutor/spreadsheet_addiction.html >> >> is one place to look for arguments against Excel. >> This was just updated to include an amusing numerical >> bug in Excel 2007. Guess what 850 * 77.1 equals. > > What a nasty little puzzle to set, Patrick! I had to turn > to OpenOffice Calc, which told me that the answer is 65535. > Is that right, Patrick? Should I check it on Excel?
Since Excel is the government approved gold standard, you should. OO Calc got it wrong. The correct Excel answer is 100000. (Only in 2007; Office 97 and 2003 had the same bug as OO Calc, and give 65535.) Duncan Murdoch ______________________________________________ R-help@r-project.org mailing list 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.
