Normal Population Hypothesis Test

A sample of 33 observations is selected from a normal population. The sample mean is 30, and the  population standard deviation is 3. Conduct the following test of hypothesis using the 0.05 significance  level.

  • H0 : μ<= 29
  • H1 : μ > 29

Setting up a Hypothesis Test in Excel

Use the following excel setup to help you solve this problem. Look closely at the formulas presented in the box below:

solve hypothesis test in excel

Use these formulas to solve a hypothesis test in excel

Is this a one- or two-tailed test?

One Tail

What is the decision rule?

H0, when z  > 1.645

What is the value of the test statistic?


What is your decision regarding H0?


There is not evidence to conclude that the population mean is greater than 29.

What is the p-value?

  • Student: Not Provided
  • Textbook: Statistical, Techniques in Business & Economics
  • Course: QNT 351

Your browser is out of date. It has security vulnerabilities and may not display all features on this site and other sites.

Please update your browser using one of modern browsers (Google Chrome, Opera, Firefox, IE 10).