### Excel 2010 Statistics 78: Hypothesis Testing Population Mean, P-value & Critical Value, 1 Tail Right

Download file: https://people.highline.edu/mgirvin/ExcelIsFun.htmIn this video we look at the 5 steps for hypothesis testing using the p-value and critical value methods. 1. We look carefully at each step using an example where sigma is known and we use the z Distribution.2. Calculate Standard Error3. Calculate Test Statistic z = # standard deviations above or below hypothesized mean for the Sampling Distribution of Sample Means (X Bar).4. NORM.S.INV for critical vaule5. NORM.S.DIST for p-valueThis is for the Highline Community College Busn 210 Statistical Analysis for Business and Economics taught by Michael GirvinExcel Standardized Normal Bell Curve Functions

Length:
41:22