Zacznij terazZacznij za darmo

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

To ćwiczenie jest częścią kursu

Wprowadzenie do statystyki w Google Sheets

Zobacz kurs

Instrukcje do ćwiczenia

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

Interaktywne ćwiczenie praktyczne

Przekształć teorię w praktykę dzięki jednemu z naszych interaktywnych ćwiczeń

Rozpocznij ćwiczenie