Microsoft® Excel Data Analysis and Business Modeling

Chapter 36. Using PivotTables to Describe Data

• I work for a small travel agency, and I’m about to do a mass mailing of a travel brochure. My funds are limited, so I want to mail the brochure to people who spend the most money on travel. For a random sample of 925 people, I have the gender, age, and the amount they spent on travel last year. How can I use this data to determine how gender and age influence a person’s travel expenditures? What recommendations can I make about the type of person to whom I should mail the brochure?

• Suppose that you’re doing market research about Volvo Cross Country Wagons. Your goal is to determine what factors influence the likelihood that a family will purchase a station wagon. For a large sample of families, you’re ...