Excel Forum

Excel Statistics 89: Hypothesis Testing With Critical Value & p-value

See the Excel functions NORMSINV for critical value and NORSDIST for p-value. Detailed description and examples for steps necessary to conduct a Hypothesis Test about a Population Mean.

1.Hypothesis Testing Test
2.Null Hypothesis
3.Alternative Hypothesis
4.Alpha Type 1 Error
5.Beta Type 2 Error
6.Tests Statistic z
7.Test Statistic z
8.Critical Value and p-value
9.Hypothesis Testing Test About a Population Mean Sigma Known (z Distribution)
10.Conclusions about Statements about whether they are reasonable or not

Busn 210 Business Statistical Using Excel Highline Community College taught by Mike Gel excelisfun Girvin

Got a Question? Ask it Here in the Forum.