CommencezCommencez gratuitement

Prediction accuracy

You'll need to create multiple sets of predicted values to determine which one is more accurate.

Remember that you can forecast values with the FORECAST() function by supplying three arguments:

  • x, which is the value to use to predict,
  • data_y, which is the set of outcome data to use, and
  • data_x, which is the set of predictor values.

Cette activité fait partie du cours

Erreurs et incertitude dans Google Sheets

Voir le cours

Instructions de l’exercice

  • In cells J2:J10, forecast students' final grades based on their period 1 grades.
  • In cells K2:K10, forecast students' final grades based on their period 2 grades.

Exercice interactif pratique

Passez de la théorie à l’action grâce à l’un de nos exercices interactifs

Commencer l’exercice