Do you know your muffins, man?

Error and Uncertainty in Google Sheets

Evan Kramer

Instructor

It's a DATE()

• FILTER()
  • Ex: FILTER(A2:B10, A2:A10 > 10)
• DATE()
  • year, month, and day
• FILTER(H1:M14, J1:J14 <= DATE(2017,2,13))

Function review

• STDEV(): average distance from the average value
• T.TEST(): differences between groups
  • range1, range2
  • tails: 1 or 2
  • type: 1, 2, or 3

Let's practice!

Error and Uncertainty in Google Sheets