Advanced prediction strategies

Error and Uncertainty in Google Sheets

Evan Kramer

Instructor

Linear models

  • Predict unobserved values
  • Predict using other measures
  • Independent variable
    • Causes some change
  • Dependent variable
    • Outcomes

Positive correlation scatterplot

Error and Uncertainty in Google Sheets

Forecasting

  • FORECAST() function
    • x: value to use to predict
    • data_y: actual outcomes
    • data_x: predictors

FORECAST formula result

Error and Uncertainty in Google Sheets

Forecasting

  • FORECAST(C2, data_y, data_x)

FORECAST formula result

Error and Uncertainty in Google Sheets

Forecasting

  • FORECAST(C2, A2:A, data_x)

FORECAST formula result; final grade column selected

Error and Uncertainty in Google Sheets

Forecasting

  • FORECAST(C2, A2:A, C2:C)

FORECAST formula result; period 2 grade selected

Error and Uncertainty in Google Sheets

Forecasting

  • FORECAST(C2, A2:A, C2:C)

FORECAST formula result based on period 1 grade

Error and Uncertainty in Google Sheets

Let's practice!

Error and Uncertainty in Google Sheets

Preparing Video For Download...