A half-baked idea

Error and Uncertainty in Google Sheets

Evan Kramer

Instructor

Data overview

  • Sales data from Risky Business Bakery
  • Columns
    • Transaction ID
    • Day
    • Date
    • Time
    • Item
    • Price

Data table with bakery item purchases, timestamps, and transaction IDs`

`

Error and Uncertainty in Google Sheets

It's all adding up

  • SUMIF()
    • range: cells to apply parameter to
    • criterion: parameter to apply
    • sum_range: cells to add
Error and Uncertainty in Google Sheets

It's about time

  • 0: Midnight
  • 1: 11:59:59
  • Example: 11:04:06 AM = 0.4611805
  • Example: noon = 0.5
Error and Uncertainty in Google Sheets

A UNIQUE() challenge

  • UNIQUE()
  • SORT()
  • Calculating percentages:
    • amount / sum
    • =L2 / SUM(L$2:L$10)

List of bakery items, total sales by item, and proportion of sales by item using the UNIQUE function

Error and Uncertainty in Google Sheets

Let's practice!

Error and Uncertainty in Google Sheets

Preparing Video For Download...