Difference between revisions of "Manuals/calci/CHIDIST"

From ZCubes Wiki
Jump to navigation Jump to search
Line 1: Line 1:
<div style="font-size:30px">'''CHIDIST(x,df)'''</div><br/>
+
<div style="font-size:30px">'''CHIDIST(Number,Degreeoffreedom)'''</div><br/>
  
*<math>x</math> is the value for which distribution is evaluated.
+
*<math>Number</math> is the value for which distribution is evaluated.
*<math>df</math> is the number of degrees of freedom.
+
*<math>Degreeoffreedom</math> is the number of degrees of freedom.
  
 
==Description==
 
==Description==
Line 23: Line 23:
  
 
Also this function will the result as Error when
 
Also this function will the result as Error when
#The <math>x</math> & <math>df</math> values are non-numeric
+
#The <math>Number</math> & <math>Degreeoffreedom</math> values are non-numeric
#The <math>x</math> value is negative or <math>df</math> value is not an integer
+
#The <math>Number</math> value is negative or <math>Degreeoffreedom</math> value is not an integer
#The <math>df < 1</math> or <math>df > 10^{10}</math>
+
#The <math>Degreeoffreedom < 1</math> or <math>Degreeoffreedom > 10^{10}</math>
 
#Here  CHIDIST=P(X>x),where X is a <math>\chi^2</math> random variable.  
 
#Here  CHIDIST=P(X>x),where X is a <math>\chi^2</math> random variable.  
  
*CHIDIST(-2,1)=Error, because x is negative.
+
*CHIDIST(-2,1)=Error, because Number is negative.
*CHIDIST(2,-1)=Error, because df<1
+
*CHIDIST(2,-1)=Error, because Degreeoffreedom<1
 +
 
 +
 
 +
==ZOS section==
 +
*The syntax is to calculate CHIDIST in ZOS is CHIDIST(Number,Degreeoffreedom).
 +
*<math>Number</math> is the value for which distribution is evaluated.
 +
*<math>Degreeoffreedom</math> is the number of degrees of freedom.
 +
*For e.g.,CHIDIST(10..12,5..7)
  
 
==Examples==
 
==Examples==
 
{| id="TABLE3" class="SpreadSheet blue"
 
{| id="TABLE3" class="SpreadSheet blue"
 
|- class="even"
 
|- class="even"
| CHIDIST(x,df)
+
| CHIDIST(Number,Degreeoffreedom)
 
! x
 
! x
 
! df
 
! df
Line 67: Line 74:
  
 
==See Also==
 
==See Also==
 
 
*[[Manuals/calci/CHITEST | CHITEST]]
 
*[[Manuals/calci/CHITEST | CHITEST]]
  
 
==References==
 
==References==
 
[http://en.wikipedia.org/wiki/Chi-squared_distribution  CHI-SQUARE Distribution]
 
[http://en.wikipedia.org/wiki/Chi-squared_distribution  CHI-SQUARE Distribution]

Revision as of 01:40, 9 April 2014

CHIDIST(Number,Degreeoffreedom)


  • is the value for which distribution is evaluated.
  • is the number of degrees of freedom.

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 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 are: Failed to parse (syntax error): {\displaystyle (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 section

  • 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..7)

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 error
CHIDIST(2,-1) 2 -1 error

See Also

References

CHI-SQUARE Distribution