Issue 89691 - chitest() allows division by zero
Summary: chitest() allows division by zero
Status: CLOSED FIXED
Alias: None
Product: Calc
Classification: Application
Component: programming (show other issues)
Version: OOo 1.0.0
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: oc
QA Contact: issues@sc
URL:
Keywords: oooqa
: 89692 (view as issue list)
Depends on: 90703
Blocks: 18704
  Show dependency tree
 
Reported: 2008-05-20 18:42 UTC by jrkrideau
Modified: 2013-08-07 15:15 UTC (History)
2 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description jrkrideau 2008-05-20 18:42:16 UTC 
Using the data set:
Observed	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

the chitest() returns the answer 0 (zero).  Since the basic equation for the 
test is  X^2 = Σ(O − E)^2/E   Calc is allowing division by zero.

Both gnumeric and Excel return error messages as would be expected.
Comment 1 ace_dent 2008-05-21 08:28:50 UTC 
*** Issue 89692 has been marked as a duplicate of this issue. ***
Comment 2 Regina Henschel 2008-05-28 20:14:01 UTC 
Confirm the zero for OOoDev300 m10.

@Eike: With my version of ScChiDist I get an error message "no result" for that
example.
Comment 3 ooo 2008-06-13 17:01:38 UTC 
Will be fixed with issue 90703.
Comment 4 ooo 2008-06-18 17:17:15 UTC 
Fixed with issue 90703.
Comment 5 ooo 2008-06-25 19:03:41 UTC 
Reassigning to QA for verification.
Comment 6 oc 2008-07-01 10:42:26 UTC 
verified in internal build cws_odff04
Comment 7 lohmaier 2008-08-05 11:21:51 UTC 
ok in m28, now returns #VALUE! error