Wrap-up

Error and Uncertainty in Google Sheets

Evan Kramer

Instructor

Chapter 1

• Correlations
  • CORREL()
• Summary statistics
  • SUMIFS()
  • AVERAGEIF()
  • COUNTIFS()

Chapter 2

• Predictions
  • FORECAST()
  • WEIGHTED.AVERAGE()
• Prediction accuracy
  • ABS()

Chapter 3

• Variation
  • RANDBETWEEN()
  • FILTER()
  • SORT()
  • SPARKLINE()
• Psychology of risk perception
  • Loss aversion

Chapter 4

• Case study
  • Risky Business Bakery

Next steps

• Data Visualization with Spreadsheets
• Pivot Tables with Spreadsheets

To an uncertain future!

Error and Uncertainty in Google Sheets