Completed
) 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 ) 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