Difference between revisions of "Documentation/How Tos/Calc: CHITEST function"

From Apache OpenOffice Wiki
Jump to: navigation, search
m (Robot: Automated text replacement %s)
m
 
(7 intermediate revisions by 4 users not shown)
Line 1: Line 1:
__NOTOC__
+
{{DISPLAYTITLE:CHITEST function}}
 +
{{Documentation/CalcFunc StatisticalTOC
 +
|ShowPrevNext=block
 +
|PrevPage=Documentation/How_Tos/Calc:_CHISQINV_function
 +
|NextPage=Documentation/How_Tos/Calc:_CONFIDENCE_function
 +
}}__NOTOC__
  
 
== CHITEST ==
 
== CHITEST ==
Line 14: Line 19:
 
: returns approximately 0.969.
 
: returns approximately 0.969.
  
{{Documentation/SeeAlso|
+
=== Issues: ===
* [[Documentation/How_Tos/Calc: CHIDIST function|CHIDIST]],
+
* The international standard ODFF calls this function <tt>'''LEGACY.CHITEST'''</tt>, and points out that it has limited mathematical validity. <tt>'''CHITEST'''</tt> is compatible with the Excel <tt>'''CHITEST'''</tt> function.
 +
 
 +
{{SeeAlso|EN|
 +
* [[Documentation/How_Tos/Calc: CHIDIST function|CHIDIST]]
 
* [[Documentation/How_Tos/Calc: CHIINV function|CHIINV]]
 
* [[Documentation/How_Tos/Calc: CHIINV function|CHIINV]]
  
Line 22: Line 30:
 
* [[Documentation/How_Tos/Calc: Functions listed alphabetically|Functions listed alphabetically]]
 
* [[Documentation/How_Tos/Calc: Functions listed alphabetically|Functions listed alphabetically]]
 
* [[Documentation/How_Tos/Calc: Functions listed by category|Functions listed by category]]}}
 
* [[Documentation/How_Tos/Calc: Functions listed by category|Functions listed by category]]}}
 
+
[[Category: Documentation/Reference/Calc/Statistical functions]]
=== Issues: ===
+
* The draft international standard ODFF calls this function <tt>'''LEGACY.CHITEST'''</tt>, and points out that it has limited mathematical validity. <tt>'''CHITEST'''</tt> is compatible with the Excel <tt>'''CHITEST'''</tt> function.
+

Latest revision as of 13:48, 2 February 2024



CHITEST

Returns a measure of χ2 'goodness of fit'.

Syntax:

CHITEST(observed; expected)

observed and expected are ranges or arrays of observed and expected values. They must have the same number of rows and columns and there must be at least 2 values in each.
CHITEST calculates the χ2 statistic and degrees of freedom, then calls CHIDIST.

Example:

CHITEST({8;9;7;8}; {8;8;8;8})

returns approximately 0.969.

Issues:

  • The international standard ODFF calls this function LEGACY.CHITEST, and points out that it has limited mathematical validity. CHITEST is compatible with the Excel CHITEST function.



See Also
Retrieved from "https://wiki.openoffice.org/w/index.php?title=Documentation/How_Tos/Calc:_CHITEST_function&oldid=260039"
Views
Personal tools
Navigation
Tools