開始使用免費開始

Variable weights

Let's say you expect students' term 1 grades to be better predictors of their final grades. To test this hypothesis, you would expect that their predicted grades would get closer to their actual grades if you increase the weight on their term 1 grades.

However, because it's not clear how changing the weights in the average will affect the outcome, you'll set up a formula to make it easier to adjust weights on the fly to test your hypothesis. This will allow you to see how tweaking your weighted averages will change the accuracy of your predictions.

本練習屬於課程

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

檢視課程

練習說明

  • Use a formula in cell H2 to add a second weight. This formula should make sure the two weights add up to 100.
  • Change the weight in cell G2 to 60 to see how your formula responds.

動手互動練習

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

開始練習