Difference between revisions of "Manuals/calci/CHIINV"

From ZCubes Wiki
Jump to navigation Jump to search
(Created page with "<div id="6SpaceContent" class="zcontent" align="left"> '''CHIINV'''(Probability, DegreeOfFreedom) where, '''Probability''' - probability associated with the chi-squ...")
 
 
(23 intermediate revisions by 4 users not shown)
Line 1: Line 1:
<div id="6SpaceContent" class="zcontent" align="left">
+
<div style="font-size:30px">'''CHIINV (probability,degrees_freedom,Accuracy,DivisionDepthArray)'''</div><br/>
 +
*Where <math>probability</math> is the  value associated with the Chi-squared Distribution
 +
*<math>degrees freedom</math> is the number of Degrees of Freedom.
 +
*<math>Accuracy</math> is the correct decimal places of the result.
 +
**CHIINV(), returns the inverse of the one-tailed probability of the chi-squared distribution.
  
'''CHIINV'''(Probability, DegreeOfFreedom)
 
  
where,
+
==Description==
 +
*This function gives the inverse value of One_tailed probability of the Chi-squared Distribution.
 +
*It is called Inverted-Chi-square Distribution and it is  a Continuous Probability Distribution of a positive-valued random variable.
 +
 +
*Degrees of freedom <math>df</math>=<math>(r-1)(c-1)</math>.
 +
*The <math>\chi^2</math> static used to compare the observed value in each table to the value which would be the expected  under the assumption.
 +
*If <math>X</math> has the chi-squared distribution with n degrees of freedom, then according to the definition, <math>\frac{1}{X}</math> has the Inverse-chi-squared distribution with <math>n</math> degrees of freedom;
 +
*If <math>CHIDIST (Number,DegreeOfFreedom)=probability</math>, then <math>CHIINV (probability,degrees freedom,Accuracy,DivisionDepthArray)= Number</math>.
 +
*CHIINV use the iterating method to find the value of <math>x</math>.suppose the iteration has not converged after 100 searches, then the function gives the error result.
 +
*This function will give the error result when 
 +
1.Any one of the arguments are non-numeric
 +
2.degrees freedom value is not an integer
 +
3.degrees freedom < 1  or degrees freedom><math>10^{10}</math>
 +
4.Also  probability < 0  or probability>1.
  
'''Probability''' - probability associated with the chi-squared distribution.
+
==ZOS==
 +
*The syntax is to calculate CHIINV in ZOS is <math>CHIINV (probability,degrees_freedom,Accuracy,DivisionDepthArray)</math>.
 +
**Where <math>probability</math> is the  value associated with the Chi-squared Distribution
 +
**<math>degrees freedom</math> is the number of Degrees of Freedom
 +
*For e.g.,CHIINV(0.0257,3)
 +
{{#ev:youtube|sfB2dLFPu1U|280|center|Inverse Chi-Squared Distribution}}
  
'''DegreeOfFreedom ''' - the number of degree of freedom.
+
==Examples==
  
</div>
+
#CHIINV(0.0001234098,2) = 18
----
+
#CHIINV(0.2547876,5) = 6.5669999999999655
<div id="1SpaceContent" class="zcontent" align="left">Returns the inverse of the one-tailed probability of the chi-squared distribution.</div>
+
#CHIINV(0.157299207050,1) = 1.9991000000000005
----
+
#CHIINV(0.6785412,-1) = #N/A (DEGREESOFFREEDOM < 1)
<div id="7SpaceContent" class="zcontent" align="left">
 
  
If Probability &lt; 0 or Probability &gt;1 ,CHIINV returns #ERROR.
+
==Related Videos==
 +
{{#ev:youtube|UPawNLQOv-8|280|center|Chi-Square Test}}
  
If either parameters is nonnumeric, it returns NaN.
+
==See Also==
 +
*[[Manuals/calci/CHIDIST  | CHIDIST ]]
 +
*[[Manuals/calci/CHITEST  | CHITEST]]
  
If DegreeOfFreedom &lt; 1 or DegreeOfFreedom &gt; = 10^10, CHIIINV returns the #ERROR.
+
==References==
 +
[http://en.wikipedia.org/wiki/Inverse-chi-squared_distribution| Inverse-chi-squared Distribution]
  
</div>
 
----
 
<div id="12SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="left">
 
  
CHIINV
 
  
</div></div>
+
*[[Z_API_Functions | List of Main Z Functions]]
----
 
<div id="8SpaceContent" class="zcontent" align="left">
 
  
Lets see an example in (Column1, Row3)
+
*[[ Z3 |   Z3 home ]]
 
 
<nowiki>=CHIINV(R1C1, R2C1)</nowiki>
 
 
 
CHIINV RETURNS 15.
 
 
 
Consider an another example
 
 
 
<nowiki>=CHIINV(-1,0,2)</nowiki>
 
 
 
CHIINV returns the #ERROR.
 
 
 
</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">
 
 
 
{| id="TABLE3" class="SpreadSheet blue"
 
|- class="even"
 
| class=" " |
 
| class="  " | Column1
 
| Column2
 
| Column3
 
| Column4
 
|- class="odd"
 
| class=" " | Row1
 
| class=" " | 0.0058
 
|
 
|
 
|
 
|- class="even"
 
| class="  " | Row2
 
| class="sshl_f " | 5
 
|
 
|
 
|
 
|- class="odd"
 
| Row3
 
| class="sshl_f" | 15
 
|
 
|
 
|
 
|- class="even"
 
| Row4
 
| class="  " |
 
| class=" SelectTD ChangeBGColor" |
 
<div id="2Space_Handle" class="zhandles" title="Click and Drag to resize CALCI Column/Row/Cell. It is EZ!"></div><div id="2Space_Copy" class="zhandles" title="Click and Drag over to AutoFill other cells."></div><div id="2Space_Drag" class="zhandles" title="Click and Drag to Move/Copy Area.">[[Image:copy-cube.gif]]  </div>
 
|
 
|
 
|- class="odd"
 
| class=" " | Row5
 
|
 
|
 
|
 
|
 
|- class="even"
 
| Row6
 
|
 
|
 
|
 
|
 
|}
 
 
 
<div align="left">[[Image:calci1.gif]]</div></div>
 
----
 

Latest revision as of 03:22, 25 August 2020

CHIINV (probability,degrees_freedom,Accuracy,DivisionDepthArray)


  • Where is the value associated with the Chi-squared Distribution
  • is the number of Degrees of Freedom.
  • is the correct decimal places of the result.
    • CHIINV(), returns the inverse of the one-tailed probability of the chi-squared distribution.


Description

  • This function gives the inverse value of One_tailed probability of the Chi-squared Distribution.
  • It is called Inverted-Chi-square Distribution and it is a Continuous Probability Distribution of a positive-valued random variable.
  • Degrees of freedom =.
  • The static used to compare the observed value in each table to the value which would be the expected under the assumption.
  • If has the chi-squared distribution with n degrees of freedom, then according to the definition, has the Inverse-chi-squared distribution with degrees of freedom;
  • If , then .
  • CHIINV use the iterating method to find the value of .suppose the iteration has not converged after 100 searches, then the function gives the error result.
  • This function will give the error result when
1.Any one of the arguments are non-numeric
2.degrees freedom value is not an integer
3.degrees freedom < 1  or degrees freedom>
4.Also  probability < 0  or probability>1.

ZOS

  • The syntax is to calculate CHIINV in ZOS is .
    • Where is the value associated with the Chi-squared Distribution
    • is the number of Degrees of Freedom
  • For e.g.,CHIINV(0.0257,3)
Inverse Chi-Squared Distribution

Examples

  1. CHIINV(0.0001234098,2) = 18
  2. CHIINV(0.2547876,5) = 6.5669999999999655
  3. CHIINV(0.157299207050,1) = 1.9991000000000005
  4. CHIINV(0.6785412,-1) = #N/A (DEGREESOFFREEDOM < 1)

Related Videos

Chi-Square Test

See Also

References

Inverse-chi-squared Distribution