Excel Forum
Similar Content
Pass Arguments to a Macro Called from a Button or Sheet in Excel
Tutorial: How to pass arguments and values to macros called from worksheets, buttons, and anything e...
Simple Excel Function to Combine Text with a Separator
Tutorial: Excel function that makes combining text very easy. This function is simpler and better th...
Input Form to Get Data and Store it in Another Tab in Excel
Tutorial: How to make a user input form in Excel and have the data stored on another worksheet at th...



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
11.NORMSDIST
12.NORMSINV


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





Got a Question? Ask it Here in the Forum.