Chapter 45. Summarizing Data with Database Statistical Functions

Questions answered in this chapter

  • Joolas is a small makeup company that tracks each sales transaction in a Microsoft Excel 2010 worksheet. Often, they want to answer questions such as:

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

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

    • What was the total dollar amount of all makeup sold 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 region?

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

Get Microsoft® Excel® 2010: Data Analysis and Business Modeling now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.