Completed
) Introduction
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 ) Introduction
- 2 ) Examples of Probability
- 3 ) What is Probability? Define Probability.
- 4 ) Types of Probabilities
- 5 ) Define Random Experiment
- 6 ) Define Sample Points
- 7 ) Define Sample Space
- 8 ) Tree Diagrams to list all Sample Points in Sample Space
- 9 ) Table Diagram to list all Sample Points in Sample Space
- 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 ) Calculate Probability by counting Sample Points.
- 12 ) Counting Rule to count all Experimental Outcomes or Sample Points
- 13 ) Difference between Combinations and Permutations
- 14 ) Example of when to use Combinations
- 15 ) Combinations and the COMBIN function
- 16 ) Permutations and the PERMUT function
- 17 ) Basic Requirements for Probability
- 18 ) Define Events
- 19 ) Define Probability of Events. Three Examples.
- 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 ) Comprehensive Business Example of using data to useful information for business decision making based on Probability for the Sonic Home Earthquake Retrofit Company.
- 22 ) Excel Smart Art Horizontal Hierarchy to create Tree Diagram with all Samples Points
- 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 ) Look at data set
- 25 ) Power Query to import CSV data
- 26 ) Excel Table formulas to create sample points and sum of project hours in business record data set
- 27 ) PivotTable to create Relative Frequency Distribution based on sample points
- 28 ) Calculate Probability based on Sample Point Frequency Distribution.
- 29 ) PivotTable to create Relative Frequency Distribution based on random variable “Total Weeks For Project”
- 30 ) Calculate Probability based on the Variable “Total Weeks for Project” Frequency Distribution.
- 31 ) Summary of business example
- 32 ) Summary of video
- 33 ) Closing and Video Links
