开始使用免费开始使用

Just t-testing

You made quick comparisons between groups of data, but you want to know whether the modeled data you created differ significantly from your original sales.

This is a good situation to use a t-test, which you can call with the function T.TEST(). Remember that T.TEST() takes four arguments: the two ranges, and then a 'tails' and 'type' argument. These latter two arguments you can specify simply with an integer.

本练习是课程的一部分

Google Sheets 中的误差与不确定性

查看课程

练习说明

  • In cell I5, perform a t-test to compare sales before and after changing prices.
  • In cell I6, use a t-test to compare sales after changing prices against the modeling dataset you created.
  • In cell I7, compare sales before changing prices with your modeling dataset.

动手互动练习

通过我们的互动练习之一,将理论转化为实践

开始练习