開始使用免費開始

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 試算表中的誤差與不確定性

檢視課程

練習說明

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

動手互動練習

將理論付諸實踐,立即體驗我們的互動練習

開始練習