Excel Statistical Analysis - Build Discrete Probability Distributions with Worksheet Formulas
ExcelIsFun via YouTube
Overview
Syllabus
) Introduction.
) Look at Data Sets from Video #6 and PivotTable Method to create Probability Distributions.
) Example #1: Isaac’s Italian Restaurant Baquet Rooms. Use same data sets from Video #6, but use Formulas to build Discrete Probability Distribution.
) Why use Formulas to build Discrete Probability Distribution?.
) Define Random Discrete Variable: Number of Banquet Rooms Used For Day..
) Use SEQUENCE function to create and spill an array of random variables..
) Use COUNTIFS to calculate and spill frequencies for random variables..
) Create and spill a formula to calculate probabilities..
) Verify two requirements for a Discrete Probability Distribution..
) Make conclusions or business decisions based on Discrete Probability Distribution..
) Build Column Chart for Discrete Probability Distribution.
) Add Random Variable to Horizontal Axis in Chart with Select Data dialog box..
) Calculate Expected Value (Mean) from a Discrete Probability Distribution.
) Step-by-step method: Calculate Variance and Standard Deviation from a Discrete Probability Distribution..
) Single cell method for variance and standard deviation..
) Calculate probability for various events from the Discrete Probability Distribution..
) Add new data and see that formulas update instantly..
) How Formulas can be an advantage over PivotTable..
) Example #2: Dick’s Hamburgers Customer Arrivals during Lunchtime Example. See everything in this quickly paced example: Probability Distribution, Expected Value, Standard Deviation, Charting and calculating probabilities and helping to make business decisions..
) Mention of Poisson Distribution..
) Summary of video and next video.
) Closing and Video Links.
Taught by
ExcelIsFun