Re: [libreoffice-users] VAR, STDEV, CHISQ.INV

2015-07-09 Thread Rui Pedro Caldeira
Thank you for all your help! My best, Rui Cumprimentos, Rui Pedro Caldeira On Thu, Jul 9, 2015 at 11:15 AM, Rob Jasper r...@famjasper.nl 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

Re: [libreoffice-users] VAR, STDEV, CHISQ.INV

2015-07-08 Thread Rui Pedro Caldeira
the formula in the spreadsheet it gives the value: 0.328061419 (VAR) and 0.5727664611 (STDEV) And yes, i do mean CHISQ.INV :) Thanks, Rui. Cumprimentos, Rui Pedro Caldeira On Wed, Jul 8, 2015 at 7:24 PM, Brian Barker b.m.bar...@btinternet.com wrote: At 18:44 08/07/2015 +0100, Rui Pedro Caldeira

[libreoffice-users] VAR, STDEV, CHISQ.INV

2015-07-08 Thread Rui Pedro Caldeira
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