始める無料で始める

A recipe for change

Before we assume that our pricing changes didn't work (or even worked in the opposite direction), we might want to conduct some additional analyses. After all, there might have been other factors that affected sales in those weeks. For example, it may be that more rain kept potential customers at home, which would have nothing to do with the price changes you instituted. You'll compare sales and rainfall to determine whether factors other than price changes affected sales.

Keep in mind that the number of inches of rain is the daily total, not the total during that given transaction. This means adding the rain totals together will inflate the numbers. You should use the daily maximum instead.

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

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

コースを見る

演習の手順

  • In cell I2, create a list of the unique dates in the dataset.
  • In cells J2:J15, calculate the maximum number of inches of rain for the corresponding day in column I.
  • In cells K2:K15, calculate the total sales for the corresponding day in column I.

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

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

演習を開始する