Microsoft Office Tutorials and References
In Depth Information
Comparing Results to an Estimate
4. Enter a comma ( ,).
5. Enter the degrees of freedom.
6. Enter a ).
The CHISQ.INV.RT function rounds out the list of Chi Square functions in
Excel. CHISQ.INV.RT is the inverse of CHISQ.DIST.RT. That is, with a given
probability and degrees of freedom number, CHISQ.INV.RT returns the Chi
Square test statistic.
Cell D18 in Figure 10-3 has the formula =CHISQ.INV.RT(D14,6). This
returns the value of the Chi Square: 1.594017094. CHISQ.INV.RT is useful then
when you know the probability and degrees of freedom and need to
determine the Chi Square test statistic value.
To use the CHISQ.INV.RT function, follow these steps:
1. Position the cursor in the cell where you want the result to appear.
2. Enter =CHISQ.INV.RT( to start the function.
3. Click the cell that has the probability.
4. Enter a comma (,).
5. Enter the degrees of freedom.
6. Enter a ).
Working with inferential statistics is difficult! I suggest further reading to help
with the functions and statistical examples discussed in this chapter. A great
book to read is Statistics For Dummies by Deborah Rumsey (Wiley).
Search JabSto ::

Custom Search