始める無料で始める

Adding variation

Your analysis suggests the weather didn't cause the drop in sales either, but there might have been other outside factors that influenced sales. As we reviewed, you can add random variation to your data to model different circumstances. More specifically, we'll add variation to the quantities of items purchased in our models to see the effects of different sales volumes.

Use the functions described in the video to add variation to the data to see if your price changes might increase sales under other circumstances.

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

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

コースを見る

演習の手順

  • In cells E3:E10, generate a random number between 0 and 2.
  • In cells F3:F10, use the random number you generated to compute the new sale amount (price times quantity).

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

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

演習を開始する