Microsoft Office Tutorials and References
In Depth Information
Is the probability associated with the chi-squared ( x 2 ) distribution.
The degrees of freedom are typically the number of obser vations
that can be chosen freely and is usually denoted by df.
CHITEST returns the test for independence.
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.
Is the ratio of the row and column totals to the grand total for the
obser ved data.
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.
You need to calculate
the expected ratios
before you can
perform the CHITEST .
CONFIDENCE returns the confidence inter val for a population mean.
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