Excel Statistical Analysis - Build Discrete Probability Distributions with Worksheet Formulas
Offered By: ExcelIsFun via YouTube
Course Description
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
Related Courses
Introduction to Operations ManagementWharton School of the University of Pennsylvania via Coursera Computational Molecular Evolution
Technical University of Denmark (DTU) via Coursera Structural Equation Model and its Applications | 结构方程模型及其应用 (普通话)
The Chinese University of Hong Kong via Coursera Fundamentals of Clinical Trials
Harvard University via edX Curso Práctico de Bioestadística con R
Universidad San Pablo CEU via Miríadax