O'Reilly logo

Microsoft® Excel Data Analysis and Business Modeling by Wayne L. Winston

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required