Is change on the menu?

Error and Uncertainty in Google Sheets

Evan Kramer

Instructor

Baking in the rain?

Frame from singing in the rain with a cupcake falling from the sky into Fred Astaire's open mouth

Error and Uncertainty in Google Sheets

Data overview

  • Inches of Rain: daily total
  • MAXIFS()
    • range
    • criteria_range1
    • criterion1

Sales data including rainfall data in inches per day

Error and Uncertainty in Google Sheets

Correlation review

  • CORREL(A:A, B:B)
  • Relationship
    • Negative
    • Positive
  • Strength
    • Weak: 0.0 to ± 0.3
    • Moderate: ± 0.3 to ± 0.7
    • Strong: ± 0.7 to ± 1.0
Error and Uncertainty in Google Sheets

Let's practice!

Error and Uncertainty in Google Sheets

Preparing Video For Download...