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().

This exercise is part of the course

Introduction to Statistics in Google Sheets

View Course

Exercise instructions

  • 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.

Hands-on interactive exercise

Turn theory into action with one of our interactive exercises

Start Exercise