Thank you for all your help!
My best,
Rui
Cumprimentos,
Rui Pedro Caldeira
On Thu, Jul 9, 2015 at 11:15 AM, Rob Jasper wrote:
> Joel,
>
> just read the MS-Excel explanation you are referring to. Great explanation.
> Thanks for pointing to this.
>
> Rob.
>
> On 8 jul. 2015, at 20:42, Joel Mader
Joel,
just read the MS-Excel explanation you are referring to. Great explanation.
Thanks for pointing to this.
Rob.
On 8 jul. 2015, at 20:42, Joel Madero wrote:
> Sounds to me like normal floating number behavior. I know someone is trying
> to document this and explain why it happens (it's a te
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 ha
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.
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
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
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