Data Analysis with Microsoft Excel: Updated for Office 2007

Chapter 7 Tables 309

Excel automatically sorts the Interest categories in the PivotTable in the

proper order—least, low, some, high, and most—rather than alphabetically.

You’ve completed your work with categorical data with Excel. You can

save your changes to the workbook now and close Excel if you want to take

a break before starting on the exercises.

Exercises

Figure 7-29
Custom sort order

1. Use Excel to calculate the following
   p values for the x^2 distribution:
   a. x^25 4 with 4 degrees of freedom
   b. x^25 4 with 1 degree of freedom
   c. x^25 10 with 6 degrees of freedom
   d. x^25 10 with 3 degrees of freedom


2. Use Excel to calculate the following
   critical values for the x^2 distribution:
   a. a5 0 .1 0 , degrees of freedom 54
   b. a5 0. 0 5, degrees of freedom 54
   c. a5 0. 0 5, degrees of freedom 59
   d. a5 0. 0 1, degrees of freedom 59


3. True or false, and why? The Pearson
   chi-square test measures the degree of

association between one categorical vari-

able and another.

4. You are suspicious that a die has been
   tampered with. You decide to test it.
   After several tosses, you record the fol-
   lowing results shown in Table 7-5:

Table 7-5 Die-Tossing Experiment

Number Occurrences

132

220

328

414

523

615