LoslegenKostenlos loslegen

What changes in a two-tailed test?

In the previous exercise, you rejected the null hypothesis. Suppose you set up the experiment differently before making this decision. Would that affect the outcome even if the data is the same?

Let's pretend you didn't know the outcome of the last exercise. Now you want to determine if the sample worker salary is equal to the population's. The NULL hypothesis operator changes to = .
This means you are testing whether the sample average is statistically above or below the average. As a result, the experiement is testing in 2 directions from the mean, so it's a two-tailed test.

If you have a two-tailed test you must multiple the Z.TEST() results by 2.

Diese Übung ist Teil des Kurses

Introduction to Statistics in Google Sheets

Kurs anzeigen

Anleitung zur Übung

  • In D9 once again perform a Z.TEST().
  • In D10, multiply the result by 2 to account for the second tail.
  • Determine the result of the hypothesis test in D11 as REJECT of FAIL TO REJECT.

Interaktive Übung

In dieser interaktiven Übung kannst du die Theorie in die Praxis umsetzen.

Übung starten