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 37. Summarizing Data with Database Statistical Functions

Joolas is a small makeup company. In an Excel spreadsheet they track each sales transaction. Often they want to answer questions such as:

  • How many dollars worth of lip gloss did Jen sell?

  • What was the average number of units of lipstick sold each time Jen made a sale in the East region?

  • How many dollars of sales were made by Emilee or in the East region?

  • How many dollars worth of lipstick were sold by Colleen or Zaret in the East region?

  • How many lipstick transactions were not in the East?

  • How many dollars worth of lipstick did Jen sell during 2004?

  • How many units of makeup were sold for a price of at least $3.20?

  • What is the total dollar amount each salesperson sold of each product?

  • What ...

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