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

Category:

Education

Tags:

• Excel
• 2007
• Confidence
• Interval
• Hypothesis
• Testing
• Tests
• Statistics
• Mike
• Gel
• excelisfun
• Girvin
• Highline
• Community
• College

[Tytow1]

I wish I took stats from you. Your videos are the only reason I passed. Its amazing how you can explain something my professor is unable to make clear. Thank you!!!!

[ExcelIsFun]

You are welcome!

I wish you took stats with me also. It is always a lot of fun!!

[peteraarontaylor]

You should have your own university.

[ExcelIsFun]

I am glad that you like the videos!

[baronlokimus]

Don't stop making these videos, you're brilliant. These videos are so much better than the current tutor we have at university. THANKS

[ExcelIsFun]

You are welcome!!!

[ExcelIsFun]

This video shows:

Excel Magic Trick 548: Data Validation Drop-Down List In A Cell Same Sheet or Different Sheet

[ExcelIsFun]

You are welcome!

[Bektut]

A very helpful video! thank a lot

[ExcelIsFun]

I am glad that it helps!