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