| Errors and other issues with statistical and mathematical functions in GSheets | Bas Braams | 5/6/12 1:30 PM | Introduction Several previous postings and conversations on this forum, e.g. [1-7], are concerned with numerical errors or accuracy issues in Google Spreadsheets. The posting [7] is mine and at first I only repeated observations made in earlier conve |
| Re: Errors and other issues with statistical and mathematical functions in GSheets | Bas Braams | 6/16/12 6:04 AM | <This message has been deleted.> |
| Re: Errors and other issues with statistical and mathematical functions in GSheets | Bas Braams | 6/17/12 1:42 PM | <This message has been deleted.> |
| Re: Errors and other issues with statistical and mathematical functions in GSheets | Bas Braams | 6/26/12 12:02 PM | <This message has been deleted.> |
| Re: Errors and other issues with statistical and mathematical functions in GSheets | Bas Braams | 7/1/12 10:29 AM | All the errors described in this posting and in the more extended posting [1] are still present on 2012-07-01 without acknowledgement that they are indeed errors. Some of the errors were reported back in 2010 and maybe earlier. In connection with thi |
| Re: Errors and other issues with statistical and mathematical functions in GSheets | Bas Braams | 7/22/12 1:17 PM | The issues and errors described here, and some other issues and errors too, are displayed in this spreadsheet. https://docs.google.com/spreadsheet/ccc?key=0An6cHU4sR7HmdG9fZ2FsZ2gtSE44QjdaVVVJUU8wNHc It is viewable by anyone that has the link. The s |
| Re: Errors and other issues with statistical and mathematical functions in GSheets | Bas Braams | 8/19/12 12:23 PM | <This message has been deleted.> |
| Re: Errors and other issues with statistical and mathematical functions in GSheets | Bas Braams | 8/19/12 12:29 PM | I believe that all the errors mentioned earlier in this posting are still present on 2012-08-19, and there are a few more that weren't previously described here. The posting [1] and the GSheetsIssues spreadsheet [2] display some gross faults with the |
| Re: Errors and other issues with statistical and mathematical functions in GSheets | Bas Braams | 10/13/12 1:39 PM | All errors described earlier in this conversation are still errors on 2012-10-13. The most remarkable one, for me, is the faulty implementation of the binary search in the lookup and match functions; it provides proof of some real structural problems |
| Re: Errors and other issues with statistical and mathematical functions in GSheets | Bas Braams | 2/6/13 2:22 PM | Binary search in an N-element sorted array returning the N+1 element, round to integer returning a non-integer or the wrong integer, cumulative distribution functions returning a negative value, standard deviation and variance functions implemented i |
| Re: Errors and other issues with statistical and mathematical functions in GSheets | Bas Braams | 5/20/13 1:15 AM | None of the errors described here have been fixed and none have been acknowledged as errors by Google staff. On the other hand, a previously unreported error can be added to the list. As was found by Yogi Anand [1-2], the CEILING function may round d |