시작하기무료로 시작하기

Performing a Z-test

When you have over 30 observations, you should use a Z.TEST() over a T.TEST() to compare means. Listed to your right is some salary data of U.S Government workers. Your job is to conduct a hypothesis test using the Z-test.

Here you want to know if the sample average salary is less than or equal to the government's published average. Are you going to compare one or two tails of the distribution? The <= operator is exploring a single direction away from the value. Thus, this is a one-tailed test.

A Z-test accepts the data range followed by the population's mean - in this case, the government's published average salary. You can also add the population's standard deviation as a third parameter. If you don't, Z.TEST() will use the sample's standard deviation.

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

Google Sheets로 배우는 통계 입문

강의 보기

연습 안내

  • In D9, calculate the p-value using Z.TEST(). Use the entire data range followed by the population mean.
  • The result in D9 is for a one-tailed test. With a cutoff of 0.05, determine is you should REJECT or FAIL TO REJECT H0.

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

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

연습 시작