CommencerCommencez 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.

Cet exercice fait partie du cours

<cours>Erreurs et incertitudes dans Google Sheets</cours>
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

Transformez la théorie en action avec l’un de nos exercices interactifs

Commencer l’exercice