開始使用免費開始

Absolute deviation

Now you have multiple predictions, as well as the actual observed values. Recall that your predictions reflect both forecasts and weighted averages from previous calculations.

You can calculate absolute deviations to see which predictions vary more from the actual final grades students earned. Remember that absolute deviations indicate how far off a given prediction was from the actual value. This will allow you to summarize your predictions and determine which ones are more accurate.

本練習屬於課程

Google 試算表中的誤差與不確定性

檢視課程

練習說明

  • In cells K2:K10, compute the absolute deviation between the actual final grade and the weighted average predictions.
  • Compute the absolute deviation between final grades and period 1 forecasts in cells L2:L10.
  • Calculate the absolute deviation between final grades and period 2 forecasts in cells M2:M10.

動手互動練習

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

開始練習