시작하기무료로 시작하기

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.

실습형 인터랙티브 연습문제

이론을 실습으로 바꾸는 인터랙티브 연습 중 하나를 만나보세요

연습 시작