How clear is your crystal ball?

Error and Uncertainty in Google Sheets

Evan Kramer

Instructor

Predicted vs. actual

  • Compare forecasts to observations
    • prediction - observation

Data table with absolute deviation of the weighted average

Error and Uncertainty in Google Sheets

Absolute deviation

  • ABS() function
    • =ABS(prediction - observation)

Positive correlation; difference between observed plotted value and prediction line of best fit

Error and Uncertainty in Google Sheets

Mean absolute deviation

  • AVERAGE() of absolute deviations
  • Useful for comparing predictions
    • Lower deviation, better predictions
Error and Uncertainty in Google Sheets

Let's practice!

Error and Uncertainty in Google Sheets

Preparing Video For Download...