始める無料で始める

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.

この演習はコースの一部です

Google Sheets で学ぶ誤差と不確実性

コースを見る

演習の手順

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

実践的なインタラクティブ演習

理論を実践に変える、インタラクティブな演習のひとつをお試しください

演習を開始する