Difference between revisions of "Manuals/calci/CHIDIST"

From ZCubes Wiki
Jump to navigation Jump to search
 
(2 intermediate revisions by the same user not shown)
Line 1: Line 1:
<div style="font-size:30px">'''CHIDIST(Number,Degreeoffreedom)'''</div><br/>
+
<div style="font-size:30px">'''CHIDIST (Number,DegreeOfFreedom)'''</div><br/>
  
 
*<math>Number</math> is the value for which distribution is evaluated.
 
*<math>Number</math> is the value for which distribution is evaluated.
 
*<math>Degreeoffreedom</math> is the number of degrees of freedom.
 
*<math>Degreeoffreedom</math> is the number of degrees of freedom.
 +
**CHIDIST(), returns the one-tailed probability of the chi-squared distribution.
  
 
==Description==
 
==Description==
Line 65: Line 66:
 
| -2
 
| -2
 
|1
 
|1
|error
+
|#N/A (NUMBER > 0)
 
|- class="odd"
 
|- class="odd"
 
|CHIDIST(2,-1)
 
|CHIDIST(2,-1)
 
|2                                       
 
|2                                       
 
| -1
 
| -1
|error
+
|null
 
|}
 
|}
  

Latest revision as of 09:50, 2 June 2020

CHIDIST (Number,DegreeOfFreedom)


  • is the value for which distribution is evaluated.
  • is the number of degrees of freedom.
    • CHIDIST(), returns the one-tailed probability of the chi-squared distribution.

Description

  • This function gives the one_tailed probability of the chi-squared distribution.
  • It is denoted by distribution.
  • Normally categorical data's may displayed in tables.
  • The static used to compare the observed value in each table to the assumed value.
  • The conditions of Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle \chi^2} test is
  1. The table should be 2x2 or more than 2x2
  2. Each observations should not be dependent
  3. All expected values should be 10 or greater.
  • The test statistic is:

The degrees of freedom is: (r–1)(c–1)

  • r = No. of rows
  • c = No. of columns

Where:

  • Oi-the observed value in the ith cell
  • Ei- the expected value in the ith cell

Also this function will the result as Error when

  1. The & values are non-numeric
  2. The value is negative or value is not an integer
  3. The or
  4. Here CHIDIST=P(X>x),where X is a random variable.
  • CHIDIST(-2,1)=Error, because Number is negative.
  • CHIDIST(2,-1)=Error, because Degreeoffreedom<1

ZOS

  • The syntax is to calculate CHIDIST in ZOS is CHIDIST(Number,Degreeoffreedom).
  • is the value for which distribution is evaluated.
  • is the number of degrees of freedom.
  • For e.g.,CHIDIST(10..12,5.1..7.1..0.6)
Chi-squared Distribution

Examples

CHIDIST(Number,Degreeoffreedom) x df RESULT
CHIDIST(18,2) 18 2 0.0001234098
CHIDIST(15,1) 15 1 0.0001075112
CHIDIST(2,1) 2 1 0.157299207050
CHIDIST(-2,1) -2 1 #N/A (NUMBER > 0)
CHIDIST(2,-1) 2 -1 null

Related Videos

Chi-Square Distribution

See Also

References

CHI-SQUARE Distribution