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

Category:

Education

Tags:

• Excel
• 2007
• Hypothesis
• Testing
• Tests
• Critical
• Value
• and
• p-value
• NORMSINV
• critical
• value
• NORSDIST
• Statistics
• Mike
• Gel
• excelisfun
• Girvin
• Highline
• community
• College

[joeslickback]

Thanks, took me a long time until now on how to find a critical value on excel.

[ExcelIsFun]

@joeslickback , you are welcome!

[17nblacktornado]

You are so amazing!!!Your videos help me a lotT^T

Thank you very much!!!!!!

[ExcelIsFun]

@17nblacktornado , you are welcome!

[vjradnus1]

where do you get the 88595 to calculate test statistic. We had to find out if realtors earned more than 8500 with a significance level of 5% right?

[ExcelIsFun]

@vjradnus1 , 88,595 is the mean we got from our sample.

[ExcelIsFun]

You are welcome!

[lahiruram3]

Thanks alot

[ExcelIsFun]

You are welcome!