Excel Statistical Analysis - Introduction to Probability, Power Query & Pivot Table Example

Excel Statistical Analysis - Introduction to Probability, Power Query & Pivot Table Example

ExcelIsFun via YouTube Direct link

) Excel Table formulas to create sample points and sum of project hours in business record data set

26 of 33

26 of 33

) Excel Table formulas to create sample points and sum of project hours in business record data set

Class Central Classrooms beta

YouTube videos curated by Class Central.

Classroom Contents

Excel Statistical Analysis - Introduction to Probability, Power Query & Pivot Table Example

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

  1. 1 ) Introduction
  2. 2 ) Examples of Probability
  3. 3 ) What is Probability? Define Probability.
  4. 4 ) Types of Probabilities
  5. 5 ) Define Random Experiment
  6. 6 ) Define Sample Points
  7. 7 ) Define Sample Space
  8. 8 ) Tree Diagrams to list all Sample Points in Sample Space
  9. 9 ) Table Diagram to list all Sample Points in Sample Space
  10. 10 ) Array Formula to create Sample Space for Rolling Dice Experiment. Learn about the SEQUENCE Array Function. See a Spilled Array Formulas that spills 36 answers.
  11. 11 ) Calculate Probability by counting Sample Points.
  12. 12 ) Counting Rule to count all Experimental Outcomes or Sample Points
  13. 13 ) Difference between Combinations and Permutations
  14. 14 ) Example of when to use Combinations
  15. 15 ) Combinations and the COMBIN function
  16. 16 ) Permutations and the PERMUT function
  17. 17 ) Basic Requirements for Probability
  18. 18 ) Define Events
  19. 19 ) Define Probability of Events. Three Examples.
  20. 20 ) Isaac’s Italian Restaurant Example of Samples Points, Events and Probabilities – done from a data set of business records. This example shows the relationship between a data set, Sample Points and …
  21. 21 ) Comprehensive Business Example of using data to useful information for business decision making based on Probability for the Sonic Home Earthquake Retrofit Company.
  22. 22 ) Excel Smart Art Horizontal Hierarchy to create Tree Diagram with all Samples Points
  23. 23 ) Consider goal of project: Calculate the Probability that a project will take 1 month or less. Classical Probability is not appropriate. We know this based on past data. We use a data set with compa…
  24. 24 ) Look at data set
  25. 25 ) Power Query to import CSV data
  26. 26 ) Excel Table formulas to create sample points and sum of project hours in business record data set
  27. 27 ) PivotTable to create Relative Frequency Distribution based on sample points
  28. 28 ) Calculate Probability based on Sample Point Frequency Distribution.
  29. 29 ) PivotTable to create Relative Frequency Distribution based on random variable “Total Weeks For Project”
  30. 30 ) Calculate Probability based on the Variable “Total Weeks for Project” Frequency Distribution.
  31. 31 ) Summary of business example
  32. 32 ) Summary of video
  33. 33 ) Closing 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.