Excel Statistical Analysis - Hypothesis Testing - P-Value & Critical Value Methods - 1 Tail Upper

Excel Statistical Analysis - Hypothesis Testing - P-Value & Critical Value Methods - 1 Tail Upper

ExcelIsFun via YouTube Direct link

) Step 2: Determine Alpha, Type 1 Error Risk. What is Type 1, Alpha, Risk?

7 of 12

7 of 12

) Step 2: Determine Alpha, Type 1 Error Risk. What is Type 1, Alpha, Risk?

Class Central Classrooms beta

YouTube videos curated by Class Central.

Classroom Contents

Excel Statistical Analysis - Hypothesis Testing - P-Value & Critical Value Methods - 1 Tail Upper

Automatically move to the next video in the Classroom when playback concludes

  1. 1 ) Introduction
  2. 2 ) What is a Hypothesis and what is Hypothesis testing?
  3. 3 ) 5 steps in Hypothesis Testing
  4. 4 ) Variables for Hypothesis Testing
  5. 5 ) One Tail Upper (Right) Example for Mean Salary of Realtors
  6. 6 ) Step 1: Null and Alternative Hypothesis
  7. 7 ) Step 2: Determine Alpha, Type 1 Error Risk. What is Type 1, Alpha, Risk?
  8. 8 ) Step 3: Collect Data, Compute Test Statistic
  9. 9 ) Step 4: Use P-value (NORM.S.DIST function) , or 2) Critical Value (NORM.S.INV function) Methods to determine if Test Statistic is past Hurdle
  10. 10 ) Step 5: Write Conclusion
  11. 11 ) Summary of video
  12. 12 ) Closing, Next Video and Video Links

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.