CHITEST function

Discuss the spreadsheet application

CHITEST function

Postby romunov » Mon May 19, 2008 10:09 pm

I'm having trouble using the aforementioned function. When I calculate the chi test by hand I get a "good result", however, the function keeps returning minute "incorrect" values. Has anyone toyed around with this function and can chip in? Is the function functional at all?
romunov
 
Posts: 3
Joined: Sun May 18, 2008 1:04 pm

Re: CHITEST function

Postby Villeroy » Mon May 19, 2008 11:30 pm

Works for me.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, no OpenOffice, LibreOffice 6.4
User avatar
Villeroy
Volunteer
 
Posts: 28573
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: CHITEST function

Postby romunov » Tue May 20, 2008 7:00 am

Can you test these values?

Experimental: 5 4 1 1 0 0 0 0 0 0
Expected:2,63 2,87 1,91 1,91 0,96 0 0,24 0 0,48 0

When I perform CHITEST, I get a return value of zero (0,00).
romunov
 
Posts: 3
Joined: Sun May 18, 2008 1:04 pm

Re: CHITEST function

Postby jrkrideau » Tue May 20, 2008 7:26 pm

romunov wrote:Can you test these values?

Experimental: 5 4 1 1 0 0 0 0 0 0
Expected:2,63 2,87 1,91 1,91 0,96 0 0,24 0 0,48 0

When I perform CHITEST, I get a return value of zero (0,00).


For some reason Calc gives 0 (zero) as the answer but unless I missing something it shouldn't give anything except an error message since expected cell sizes of zero would mean dividing by zero.

Is this a bug?
LibreOffice 6.4.3.2; Ubuntu 20.04
jrkrideau
Volunteer
 
Posts: 3788
Joined: Sun Dec 30, 2007 10:00 pm
Location: Kingston Ontario Canada

Re: CHITEST function

Postby Villeroy » Tue May 20, 2008 7:28 pm

If we accept Gnumeric as pseudo-standard for statistics in spreadsheets then yes, it's a bug. Gnumeric returns #NUM if there are zero measurements.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, no OpenOffice, LibreOffice 6.4
User avatar
Villeroy
Volunteer
 
Posts: 28573
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: CHITEST function

Postby jrkrideau » Tue May 20, 2008 7:42 pm

Villeroy wrote:If we accept Gnumeric as pseudo-standard for statistics in spreadsheets then yes, it's a bug. Gnumeric returns #NUM if there are zero measurements.


Gnumeric is much closer to real stats than either Excel or Calc.

A couple of refs gives the formula for a X^2 test as X^2 = Σ(O − E)^2/E which definately implies division by zero with this dataset. so I think we have bug.

Just tried it in Excel and I get a div/0 error
LibreOffice 6.4.3.2; Ubuntu 20.04
jrkrideau
Volunteer
 
Posts: 3788
Joined: Sun Dec 30, 2007 10:00 pm
Location: Kingston Ontario Canada

Re: CHITEST function

Postby romunov » Tue May 20, 2008 9:30 pm

Some datasets do have zero, but the chi test is a SUM of devisions, so an invalid (div/0 error) should not render a function useless.
romunov
 
Posts: 3
Joined: Sun May 18, 2008 1:04 pm

Re: CHITEST function

Postby Villeroy » Wed May 21, 2008 2:36 pm

Just for the records: http://www.openoffice.org/issues/show_bug.cgi?id=89691
Thank you for filing, jrkrideau.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, no OpenOffice, LibreOffice 6.4
User avatar
Villeroy
Volunteer
 
Posts: 28573
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: CHITEST function

Postby jrkrideau » Wed May 21, 2008 3:59 pm

Villeroy wrote:Just for the records: http://www.openoffice.org/issues/show_bug.cgi?id=89691
Thank you for filing, jrkrideau.


Thanks for posting this. I totally forgot it.
LibreOffice 6.4.3.2; Ubuntu 20.04
jrkrideau
Volunteer
 
Posts: 3788
Joined: Sun Dec 30, 2007 10:00 pm
Location: Kingston Ontario Canada


Return to Calc

Who is online

Users browsing this forum: Villeroy and 14 guests