OpenOffice fails to calculate
Here is a buggy thing - don't ever believe what you see in openoffice calc.
I don't know why but calc will calculate a semy-true value for a mathematical equation but will show only 2 numbers after the dot.
As in instead of 0.00852353 it show 0.01
It isn;t so obvious or harmful in the common use but it makes your life real hard if you blindly believe to the results.
While studing Introduction to Statistics and Probability (Shauman's books) i started to calculate Binomial :
as in
n! k n - k
-------- * p * q
k!(n-k)!
so i tested the next 0.1 ^3 * 0.9^7 * 4*5*6*7 / (1*2*3*4) and used the output (0.02) then i started to use this result in other calulations and realized that it isn't true so by using some elemntry school skils i found the correct value but still it is really frustrating!
I don't know why but calc will calculate a semy-true value for a mathematical equation but will show only 2 numbers after the dot.
As in instead of 0.00852353 it show 0.01
It isn;t so obvious or harmful in the common use but it makes your life real hard if you blindly believe to the results.
While studing Introduction to Statistics and Probability (Shauman's books) i started to calculate Binomial :
as in
n! k n - k
-------- * p * q
k!(n-k)!
so i tested the next 0.1 ^3 * 0.9^7 * 4*5*6*7 / (1*2*3*4) and used the output (0.02) then i started to use this result in other calulations and realized that it isn't true so by using some elemntry school skils i found the correct value but still it is really frustrating!
1 comments:
Sorry, but the right label for this post is PEBKAC (look it up).
Right click the cell, and in the context menu choose "format cells". Then, pick the Number tab. Play with it a little.
In my opinion, a spreadsheet is also categorically the wrong tool for this kind of calculation; use a math-oriented interpreter instead. I hear good things about Octave, and for me, even Python will do.
Post a Comment