Chapter 34
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 worksheet. Often, members of the company want to answer questions such as these:
How many dollars’ worth of lip gloss did Jen sell?
What was the average number of lipstick units sold each time Jen had a sale in the East region?
What was the total dollar amount of all the makeup sold by Emilee or sold 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 ...
Get Microsoft Excel Data Analysis and Business Modeling (Office 2021 and Microsoft 365), 7th Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
