始める無料で始める

Now weight a minute

Now it's time to calculate weighted averages. In this example, you'll compute students' final grades, but it's important to note that weighted averages could also apply to employee evaluations, weighting movie reviews, or other examples in which you are creating a composite of individual scores. For example, imagine you work for Netflix predicting which movies customers will like based on other films they have rated. People's tastes change, so you might want to assign more weight to reviews they made in the last six months compared with movies they reviewed five years ago.

Now use your skills to calculate weighted averages.

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

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

コースを見る

演習の手順

  • In cell I2, calculate the weighted average of period 1 and period 2 grades using the weights in cells G2 and H2.
  • Use the same weights to calculate weighted averages in cells I3:I10.
  • Change the weights to an 80-20 split between period 1 and period 2 grades.

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

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

演習を開始する