Appendix 12.2 Chi-Square Tests Using MegaStat 511
Appendix 12.2 ■Chi-Square Tests Using MegaStat
The instructions in this section begin by describing the entry of data into an Excel worksheet. Alternatively, the data
may be downloaded from this book’s website. The appropriate data file name is given at the top of each instruc-
tion block. Please refer to Appendix 1.1 for further information about entering data, saving data, and printing
results in Excel. Please refer to Appendix 1.2 for more information about using MegaStat.
Contingency table and chi-square test of indepen-
dence similar to Figure 12.2(a) on page 499 (data file:
Invest.xlsx):
•Follow the instructions given in Appendix 2.2 for
using MegaStat to construct a crosstabulation
table of fund type versus level of customer
satisfaction.
•After having made entries to specify the row and
column variables for the table, in the list of Output
Options place a checkmark in the “chi-square”
checkbox.
•If desired, row, column, and cell percentages can
be obtained by placing checkmarks in the “%
of row,” “% of column,” and “% of total”
checkboxes in the list of Output Options. Here we
have elected to not request these percentages.
•Click OK in the Crosstabulation dialog box.
•The value of the chi-square statistic (=46.44) and
its related p-value (=0.000000002) are given below
the crosstabulation table.
bow01838_ch12_488-515.qxd 11/27/09 5:53 PM Page 511
