Excel Statistical Analysis for Business and Economics

Excel Statistical Analysis for Business and Economics

ExcelIsFun via YouTube Direct link

Excel Statistical Analysis 29: HYPGEOM.DIST Function for Conditional Probabilities Across # Trials

33 of 67
Previous
Next

33 of 67

Excel Statistical Analysis 29: HYPGEOM.DIST Function for Conditional Probabilities Across # Trials

Class Central Classrooms beta

YouTube videos curated by Class Central.

Classroom Contents

Excel Statistical Analysis for Business and Economics

Automatically move to the next video in the Classroom when playback concludes
  1. 1 Excel Statistical Analysis 01: Data & Statistics
  2. 2 Excel Statistical Analysis 02: Structure of Excel files, Navigation, Keyboard and more
  3. 3 Excel Statistical Analysis 03: Comprehensive Worksheet Formula & Model Building Video
  4. 4 Excel Statistical Analysis 04: PivotTable & Power Query to Build Frequency Distributions
  5. 5 Excel Statistical Analysis 05: Frequency Distributions & Visualizations for Categorical Data
  6. 6 Excel Statistical Analysis 06: Frequency Distributions, Visualizations & Skew for Quantitative Data
  7. 7 Excel Statistical Analysis 7: Cross Tabulation, Visualizations, AND Logical Tests, Simpson’s Paradox
  8. 8 Excel Statistical Analysis 08: X-Y Scatter Charts for Linear Data: Excel Chart? Analyze Data Button?
  9. 9 Mode for Categorical Data? LET Function to Dynamically List all Modes with Category Labels EMT 1770
  10. 10 Excel Statistical Analysis 09: Location, Mean, Median, Mode, Moving Average, Skew & More!
  11. 11 Excel Statistical Analysis 10: Weighted Mean. Awesome Accounting Example!!
  12. 12 Excel Statistical Analysis 11: Geometric Mean to Calculate Average Compounding Rate per Period
  13. 13 Excel Statistical Analysis 12: Percentile, Quartile, Percentile Rank and Rank Functions & Algorithms
  14. 14 FILTER, LET, TRANSPOSE and Other Excel Functions: Mode Calculation for each Quartile. EMT 1771
  15. 15 Excel Statistical Analysis 13: Range, Variance, Standard Deviation, Coefficient of Variation
  16. 16 Excel Statistical Analysis 14: Z-Score, Empirical Rule , Chebyshev Theorem: # of Standard Deviations
  17. 17 Excel Statistical Analysis 15: 5-Number Summary / Box & Whiskers Chart: Power Query & Array Formulas
  18. 18 Turn Off GETPIVOTDATA Function - EMT 1774
  19. 19 Excel Statistical Analysis 16: Introduction to Probability. Power Query & Pivot Table Example too
  20. 20 Excel Statistical Analysis 17: AND, OR, and NOT Logical Tests for COUNTIFS & FILTER Functions
  21. 21 Excel Statistical Analysis 18: Addition Law of Probability, OR Logical Test: Formulas & PivotTables
  22. 22 Excel Statistical Analysis 19: Conditional Probability 5 Examples
  23. 23 Excel Statistical Analysis 20: Joint Probability Table: Dynamic Spilled Array or PivotTable?
  24. 24 Excel Statistical Analysis 21: Multiplication Law of Probability, AND Logical Test, Probability Tree
  25. 25 Excel Statistical Analysis 22: Bayes’ Theorem, Tabular Method, Probability Tree, SUMPRODUCT function
  26. 26 Excel Statistical Analysis 23: Discrete Probability Distributions: Terms and Definitions
  27. 27 DROP, TAKE & VSTACK: How They Are Useful! Spilled Frequency Distribution with Total Row. EMT 1788
  28. 28 Excel Statistical Analysis 24: Build Discrete Probability Distributions with Worksheet Formulas
  29. 29 Excel Statistical Analysis 25: Import Excel data: Build PivotTable Discrete Probability Distribution
  30. 30 Excel Statistical Analysis 26: Accounting & Finance Discrete Probability Distribution Examples
  31. 31 Excel Statistical Analysis 27: Binomial Probability Distributions. BINOM.DIST.RANGE Function & Chart
  32. 32 Excel Statistical Analysis 28: Poisson Distribution, POISSON.DIST function and Poisson Column Chart
  33. 33 Excel Statistical Analysis 29: HYPGEOM.DIST Function for Conditional Probabilities Across # Trials
  34. 34 Excel Statistical Analysis 30: Introduction to Continuous Probability Distributions
  35. 35 Excel Statistical Analysis 31: Uniform Probability Distribution
  36. 36 Excel Statistical Analysis 32: Bell Curve Functions: NORM.DIST, NORM.S.DIST, NORM.INV, NORM.S.INV
  37. 37 Excel Statistical Analysis 33: Chart Normal (Bell) Probability Distribution in Excel with Area Chart
  38. 38 Excel Statistical Analysis 34: Answering Probability Questions With NORM.DIST Function
  39. 39 Excel Statistical Analysis 35: Exponential Probability Distribution & EXPON.DIST function
  40. 40 Excel Statistical Analysis 36: Sampling & Sampling Distribution of Sample Means (Xbar)
  41. 41 Excel Statistical Analysis 37: Learn Central Limit Theorem by Building Sampling Distribution of Xbar
  42. 42 Excel Statistical Analysis 38: Normal Bell Curve to Estimate Range of Sample Proportions
  43. 43 Excel Statistical Analysis 39: Confidence Intervals: Theory for Estimating Population Parameter
  44. 44 Excel Statistical Analysis 40: Confidence Interval for z Distribution, use when Sigma Known
  45. 45 Excel Statistical Analysis 41: Confidence Interval for t Distribution, use when Sigma NOT Known
  46. 46 Excel Statistical Analysis 42: Confidence Interval for Proportions (Binomial Experiments)
  47. 47 Excel Statistical Analysis 43: Hypothesis Testing: P-value & Critical Value Methods: 1 Tail Upper
  48. 48 Excel Statistical Analysis 44: Hypothesis Testing with Z Distribution, 1 Tail Lower (Left) Test
  49. 49 Excel Statistical Analysis 45: Hypothesis Testing with Z Distribution, Two Tail Test Example
  50. 50 Excel Statistical Analysis 46: Hypothesis Testing with T Distribution, 1 Tail Upper (Right) Test
  51. 51 Excel Statistical Analysis 47: Hypothesis Testing with T Distribution, 1 Tail Lower (Left) Test
  52. 52 Excel Statistical Analysis 48: Hypothesis Testing with T Distribution, Two Tail Example
  53. 53 Excel Statistical Analysis 49: Hypothesis Testing for Proportion (Binominal) using Normal Curve
  54. 54 Linear Regression Made Easy! The Epic Full Story with all Details. Excel Statistical Analysis 50
  55. 55 Excel 2013 Statistical Analysis #63: Sampling Distribution of Xbar1 – Xbar2 & Standard Error
  56. 56 Excel 2013 Statistical Analysis #64: Confidence Interval for Population Differences Sigma Known
  57. 57 Excel 2013 Statistical Analysis #65: Hypothesis Testing for Population Differences Sigma Known
  58. 58 Excel 2013 Statistical Analysis #66: Confidence Interval for Population Differences Sigma NOT Known
  59. 59 Excel 2013 Statistical Analysis #67: Hypothesis Testing for Population Differences Sigma NOT Known
  60. 60 Excel 2013 Statistical Analysis #68: Matched/Paired Samples Population Differences Sigma NOT Known
  61. 61 Excel 2013 Statistical Analysis #69: ANOVA Tables for Comparing More Than 2 Population Means
  62. 62 Excel 2013 Statistical Analysis #70: Sampling Distribution of Pbar1 – Pbar2, Mean & Standard Error
  63. 63 Excel 2013 Statistical Analysis #71: Inference About Difference Between 2 Pop. Proportions Z Method
  64. 64 Excel 2013 Statistical Analysis #72: Chi-Square Test For 2 or More Population Proportions (Formulas)
  65. 65 Excel 2013 Statistical Analysis #73: Chi-Square Test Independence 2 Categorical Var. (PivotTables)
  66. 66 CSV and XLSX Files Look The Same!?!? Here Is How To Fix That!. #Short Excel Trick 38
  67. 67 What is Difference Between Clustered Column & Stack Column Excel Charts? #Short Excel Trick 39

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Sign up for free
Someone learning on their laptop while sitting on the floor.