At 18:44 08/07/2015 +0100, Rui Pedro Caldeira wrote:
I'm having some problems with the VAR and STDEV function, when
executing these lines of code. The average is well calculated but
the remaining two return very low, unrealistic and equal values
(6.93018471335974E-310).
That value is 2^-1027
Hey and thanks for your fast answer. This is the data set:
0.01 0.01 0.01 0.01 0.01 0.01 0.01
0.01 0.01 0.01 0.01 0.01 0.01 0.01
0.02 0.03 0.97 0.97 0.97 0.97 0.98
1.01 1.97
Using the
Sounds to me like normal floating number behavior. I know someone is trying
to document this and explain why it happens (it's a technical reason that
goes beyond my skills) but this seems entirely normal behavior given the
constraints of programming languages generally and hardware in particular.
Hello guys, I’m having some problems with the VAR and STDEV function, when
executing these lines of code. The average is well calculated but the
remaining two return very low, unrealistic and equal values
(6.93018471335974E-310).
To add to a bad situation, I can’t execute the function CHISQINV as
Trying to get started with templates and styles with
LibreOffice Writer (4.4.4.3).
I noticed the following anomalous behavior. To re-create:
From a freshly installed LibreOffice (4.4.4.3), start Writer
from either the Windows (this is Windows 7 X64 Ultimate, FYI)
Start menu or the LibreOffice
Guess what 1f*5/5==1f (Java; 1 AS float multiplied by 5 divided by 5 is equals
to 1 as a float)
Everyone not studying computer science won't understand this at first glance
(and Google has the best explanations) but with Math.abs((1f/5*5)-1)0.0001 you
do not have a workaround, but the way it
