Difference between revisions of "Manuals/calci/CHIDIST"

From ZCubes Wiki
Jump to navigation Jump to search
(Created page with "<div id="6SpaceContent" class="zcontent" align="left"> <font size="3"><font face="Times New Roman">'''CHIDIST''' ('''n''',''' df''')</font></font> <font size="3"><font f...")
 
 
(46 intermediate revisions by 4 users not shown)
Line 1: Line 1:
<div id="6SpaceContent" class="zcontent" align="left">
+
<div style="font-size:30px">'''CHIDIST (Number,DegreeOfFreedom)'''</div><br/>
  
<font size="3"><font face="Times New Roman">'''CHIDIST''' ('''n''',''' df''')</font></font>
+
*<math>Number</math> is the value for which distribution is evaluated.
 +
*<math>Degreeoffreedom</math> is the number of degrees of freedom.
 +
**CHIDIST(), returns the one-tailed probability of the chi-squared distribution.
  
<font size="3"><font face="Times New Roman">'''n'''   is the value for which the distribution is calculated and df is the number of degrees of freedom</font></font>
+
==Description==
 +
*This function gives the one_tailed probability of the chi-squared distribution.
 +
*It is denoted by  <math>\chi^2</math> distribution.
 +
*Normally categorical data's may displayed in tables.
 +
*The <math>\chi^2</math> static used to compare the observed value in each table to the assumed value.
 +
*The conditions of <math>\chi^2</math> test is  
 +
#The table should be 2x2 or more than 2x2
 +
#Each observations should not be dependent
 +
#All expected values should be 10 or greater.
 +
*The test statistic is:
 +
<math>\chi^2=\sum\frac{(Oi-Ei)^2}{Ei}</math>
 +
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
  
</div>
+
Also this function will the result as Error when
----
+
#The <math>Number</math> & <math>Degreeoffreedom</math> values are non-numeric
<div id="1SpaceContent" class="zcontent" align="left">
+
#The <math>Number</math> value is negative or <math>Degreeoffreedom</math> value is not an integer
 +
#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.
  
<font size="3"><font face="Times New Roman">It calculates the one-tailed probability of the chi-squared distribution. </font></font>
+
*CHIDIST(-2,1)=Error, because Number is negative.
 +
*CHIDIST(2,-1)=Error, because Degreeoffreedom<1
  
</div>
+
==ZOS==
----
+
*The syntax is to calculate CHIDIST in ZOS is CHIDIST(Number,Degreeoffreedom).
<div id="7SpaceContent" class="zcontent" align="left">
+
*<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.1..7.1..0.6)
 +
{{#ev:youtube|44cEta1FnA4|280|center|Chi-squared Distribution}}
  
<font size="3">·</font>        <font size="3"><font face="Times New Roman">When arguments are nonnumeric, CHIDIST shows error.</font></font>
+
==Examples==
 
+
{| id="TABLE3" class="SpreadSheet blue"
<font size="3">·</font>        <font size="3"><font face="Times New Roman">When x is negative, CHIDIST shows error.</font></font>
+
|- class="even"
 
+
| CHIDIST(Number,Degreeoffreedom)
<font size="3">·</font>        <font size="3"><font face="Times New Roman">ds is shortened for non-integer values. </font></font>
+
! x
 
+
! df
<font size="3" face="Times New Roman"> </font>
+
! RESULT
 +
|-
 +
|- class="odd"
 +
|CHIDIST(18,2)
 +
|18
 +
|2
 +
|0.0001234098
 +
|- class="even"
 +
|CHIDIST(15,1)
 +
|15
 +
|1
 +
|0.0001075112
 +
|- class="odd"
 +
|CHIDIST(2,1)
 +
|2                                     
 +
|1
 +
|0.157299207050
 +
|- class="even"
 +
|CHIDIST(-2,1)
 +
| -2
 +
|1
 +
|#N/A (NUMBER > 0)
 +
|- class="odd"
 +
|CHIDIST(2,-1)
 +
|2                                     
 +
| -1
 +
|null
 +
|}
  
</div>
+
==Related Videos==
----
 
<div id="12SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="left">CHIDIST </div></div>
 
----
 
<div id="8SpaceContent" class="zcontent" align="left">
 
  
<font size="3"><font face="Times New Roman">Let’s see an example in (Column1 Row 1, Column2Row1)</font></font>
+
{{#ev:youtube|dXB3cUGnaxQ|280|center|Chi-Square Distribution}}
  
<font size="3">CHIDIST (n, df)</font>
+
==See Also==
 +
*[[Manuals/calci/CHITEST | CHITEST]]
  
<font size="3">CHIDIST (C1R1, C2R1)</font>
+
==References==
 +
[http://en.wikipedia.org/wiki/Chi-squared_distribution  CHI-SQUARE Distribution]
  
<font size="3">i.e. =CHIDIST (16.867, 6) is 0.0098</font>
 
  
</div>
 
----
 
<div id="10SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Syntax </div><div class="ZEditBox"><center></center></div></div>
 
----
 
<div id="4SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Remarks </div></div>
 
----
 
<div id="3SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Examples </div></div>
 
----
 
<div id="11SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Description </div></div>
 
----
 
<div id="2SpaceContent" class="zcontent" align="left"><div>
 
  
{| id="TABLE1" class="SpreadSheet blue"
+
*[[Z_API_Functions | List of Main Z Functions]]
|- class="even"
 
| class=" " |
 
| Column1
 
| class="            " | Column2
 
| class="    " | Column3
 
| class="  " |
 
| class="  " | Column4
 
|
 
|- class="odd"
 
| class=" " | Row1
 
| class=" " | 16.867
 
| class="sshl_f " | 6
 
| class="sshl_f" | 0.0098
 
| class="sshl_f" |
 
| class="sshl_f" |
 
|
 
|- class="even"
 
| class="  " | Row2
 
| class="sshl_f" |
 
| class="sshl_f" |
 
| class="sshl_f SelectTD SelectTD" |
 
<div id="2Space_Handle" title="Click and Drag to resize CALCI Column/Row/Cell. It is EZ!"></div><div id="2Space_Copy" title="Click and Drag over to AutoFill other cells."></div>
 
| class="sshl_f" |
 
| class="sshl_f" |
 
|
 
|- class="odd"
 
| Row3
 
| class="sshl_f" |
 
| class="sshl_f" |
 
| class="sshl_f" |
 
| class="  " |
 
| class="sshl_f" |
 
|
 
|- class="even"
 
| Row4
 
| class="sshl_f" |
 
| class="sshl_f" |
 
|
 
| class=" " |
 
| class="sshl_f" |
 
|
 
|- class="odd"
 
| class="sshl_f" | Row5
 
| class="sshl_f" |
 
| class="  " |
 
|
 
|
 
| class="  " |
 
<div id="2Space_Handle" title="Click and Drag to resize CALCI Column/Row/Cell. It is EZ!"></div><div id="2Space_Copy" title="Click and Drag over to AutoFill other cells."></div>
 
|
 
|- class="even"
 
| class=" " | Row6
 
| class="sshl_f" |
 
| class="sshl_f" |
 
|
 
| class="sshl_f" |
 
|
 
|
 
|}
 
  
<div align="left"></div>''''''</div></div>
+
*[[ Z3 |  Z3 home ]]
----
 

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 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