시작하기무료로 시작하기

Paired t-test

Now you are looking at driver data. Most research suggests drivers perform better in the morning versus in the afternoon. The researcher here measured 10 drivers in the morning and again the same drivers in the evening. The milliseconds response time is the time needed to apply the brakes after seeing a prompt in the simulator. You need to perform a t-test to see if this data supports the research that drivers do indeed perform better in the morning.

Remember the parameters of the T.TEST() function. Think about if this test has two tails or is measuring the difference in one direction. Also think about what it means for both samples to be from the same people. These will affect the values you pass to T.TEST().

이 연습은 강의의 일부입니다

Google Sheets로 배우는 통계 입문

강의 보기

연습 안내

  • In E7 calculate the p-value using a t-test.
  • Type REJECT in E8 if the p-value is less than 0.05. Otherwise type FAIL TO REJECT.

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

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

연습 시작