Difference between revisions of "Manuals/calci/CHIDIST"

From ZCubes Wiki
Jump to navigation Jump to search
Line 44: Line 44:
  
 
|- class="even"
 
|- class="even"
|Complex(5,2,"j")
+
|CHIDIST(15,1)
|5
+
|15
|2
+
|1
|j
+
|0.0001075112
|5+6j
 
 
|- class="odd"
 
|- class="odd"
| Complex(2,0,"i")
+
|CHIDIST(2,1)
 
|2                                       
 
|2                                       
|0
+
|1
|i
+
|0.157299207050
|2
 
 
|- class="even"
 
|- class="even"
| Complex(0,-4,i)
+
| CHIDIST(-2,1)
|0
+
|-2
|4
+
|1
|i
+
|error
|4i
 
 
|- class="odd"
 
|- class="odd"
|Complex(5,"j")
+
|CHIDIST(-2,1)
|5
+
|-2
|
+
|1
|j
 
 
|Error
 
|Error
 
|}
 
|}

Revision as of 04:56, 12 November 2013

CHIDIST(x,df)


  • 'X' is the value for which distribution is evaluated and df is the number of degrees of freedem.

Description

  • This function gives the one_tailed probability of the chi-squared distribution.
  • It is denoted by X^2 distribution.Normally categorical datas may displayed in tables.
  • The X^2 static used to compare the observed value in each table to the value
  • which would be the expected under the assumption. The conditions of X^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: X^2=summation(Oi-Ei)^2/Ei The degrees of freedom are: (r–1)(c–1) r =No. of rows and 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 x&df values are nonnumeric 2.The x value is negative or df value is not an integer 3. The df <1or df>10^10 4.Here CHIDIST=P(X>x),where X is a X^2 random variable.

    • gives
    • Failed to parse (syntax error): {\displaystyle =COMPLEX(5,2,"j")} gives

Examples

Complex(RN,IN,SF) RN IN 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)
1 error
CHIDIST(-2,1)
1 Error

See Also

References

Complex Numbers