Microsoft Office Tutorials and References
In Depth Information
CHITEST
Is the probability associated with the chi-squared ( x 2 ) distribution.
PROBABILITY
The degrees of freedom are typically the number of obser vations
that can be chosen freely and is usually denoted by df.
DEGREES FREEDOM
CHITEST
CHITEST returns the test for independence.
=CHITEST(actual_range,expected_range)
The CHITEST function is used with tables such as those shown in Figure 11.5. These tables
are referred to as contingency tables or cross-tabulation tables . The tables show two
characteristics—gender and opinion. The CHITEST function checks the independence of the
characteristics, in other words that the option is or is not related to gender.
Is the obser ved data.
ACTUAL RANGE
Is the ratio of the row and column totals to the grand total for the
obser ved data.
EXPECTED RANGE
Figure 11.5 shows the actual values and expected ratios. You need to calculate the expected
ratios before you can perform the CHITEST . The actual range and expected range must have the
same number of values. The expected ratios are calculated by multiplying the corresponding
actual row and column totals and dividing by the actual grand total.
Figure 11.5
You need to calculate
the expected ratios
before you can
perform the CHITEST .
CONFIDENCE
CONFIDENCE returns the confidence inter val for a population mean.
=CONFIDENCE(alpha,standard_dev,size)
The confidence inter val is a range on either side of a sample mean, indicating the lowest (or
earliest) and highest (or latest) values. Figure 11.6 shows the prices for efficiency apartments
Search JabSto ::




Custom Search