Similar Content
Run a Macro at Set Intervals in Excel
Tutorial: Run a macro every 30 seconds, 1 minute, 10 minutes, 1 hour, etc.; this method allows you t...
Do Something Every so Many Rows with a Macro in Excel
Tutorial: How to have a macro do something on a set interval of rows; for instance, input a value ev...
Countdown Timer in Excel
Tutorial: How to create a countdown timer in Excel. This allows you to display a timer in whatever c...

# Excel Statistics 88: Confidence Interval & Hypothesis Tests

See the Excel functions NORMSINV for critical value and NORSDIST for p-value. Compare building Confidence Intervals with Hypothesis Testing to see that they are similar. See an introduction to the steps necessary to conduct a Hypothesis Test about a Population Mean.

1.Confidence Intervals For Hypothesis Testing (Test)
2.Hypothesis Testing Test
3.Null Hypothesis
4.Alternative Hypothesis
5.Alpha Type 1 Error
6.Beta Type 2 Error
7.Tests Statistic z
8.Test Statistic z
9.Critical Value and p-value
10.Hypothesis Testing Test About a Population Mean Sigma Known (z Distribution)