Chapter 7: Tables.

1. You are to analyze data from a survey of professors who teach statistics courses. The Survey.xls data set includes 392 responses to questions about whether the course requires calculus, whether statistical software is used, how the software is obtained by students, what kind of computer is used and so on. You've been asked to determine what computers are used most often in statistics instruction. What is your conclusion. Please explain your answer.

2. Now they ask you to see how computer use varies by department. Do different departments tend to choose different types of computers? Does one department tend to use Macintoshes, whereas another tends to use PCs? Summarize your findings.

3. Is there any relationship between computer use and department? Why? How do you test that? What's your conclusion?

4. When you're done the following remark (or question) comes to you from someone that has not seen your results yet but anticipates with some approximation the method you've used in your analysis. The message says: "Did you notice any sparse cells?" What does this mean? What is your answer? Explain.

5. Is there a relationship between a class requiring calculus as a prerequisite and the size of the class? Might you expect that classes requiring calculus would have smaller enrollments? Why? Explain your analysis and conclusions.

6. How do you create a custom sort order for your workbook?