Excel Forum
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)
11.Conclusions about Statements about whether they are reasonable or not
12.NORMSDIST
13.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.