### Calculating the winning probability of a prize drawing | lynda.com tutorial

This Excel tutorial shows how to use the hypergeometric distribution to calculate the expected value and winning probability of a prize drawing. Watch more at http://www.lynda.com/Excel-2007-tutorials/business-statistics/71213-2.html?utm_medium=viral&utm_source=youtube&utm_campaign=videoupload-71213-0506 This specific tutorial is just a single movie from chapter five of the Excel 2007: Business Statistics course presented by lynda.com author Curt Frye. The complete Excel 2007: Business Statistics course has a total duration of 4 hours and 19 minutes and covers formulas and functions for calculating averages and standard deviations, charts and graphs for summarizing data, and the Analysis ToolPak add-in for even greater insights into data. Excel 2007: Business Statistics table of contents: Introduction 1. Introducing Statistics 2. Learning Useful Excel Techniques 3. Summarizing Data Using Tables and Graphics 4. Describing Data Using Numerical Methods 5. Using Probability Distributions 6. Sampling Values from a Population 7. Testing Hypotheses 8. Using Linear and Multiple Regression Conclusion

Length:
05:54