Review: Are we certain now?

Error and Uncertainty in Google Sheets

Evan Kramer

Instructor

Hungry for profits

How random

• RANDBETWEEN()
  • Upper and lower limit
• RANDBETWEEN(0,2)
  • 0, 1, or 2
  • Useful for modeling different conditions

Revisiting sparklines

• SPARKLINE()
  • data: The cell(s) to plot
  • options: Options to configure the plot
    • charttype: bar, line, etc.
    • max: upper limit

Revisiting sparklines

=SPARKLINE(H2, {"charttype", "bar"; "max", MAX(H$2:H$10)})

Let's practice!

Error and Uncertainty in Google Sheets