Back To Busn 210 Home Page

1) Download files:

Excel File that goes with Videos: Section04-ESA.xlsx
CSV File that goes along with video #16: BasicRetrofitRecords.csv

Excel Homework for Section 4: Section04-HW.xlsx (file has practice problems and solutions)

Pdf Notes for Section 3: Section04-ESA.pdf (click to view, right-click and Save As to download)

2) Click below links to watch class videos at YouTube:

Watch this video before the others to see how to change a PivotTable Setting in Excel: Turn Off GETPIVOTDATA Function - EMT 1774 (1:34 minutes)

Excel Statistical Analysis 16: Introduction to Probability. Power Query & Pivot Table Example too (43:43 min)

Excel Statistical Analysis 17: AND, OR, and NOT Logical Tests for COUNTIFS & FILTER Functions  (28:43 min)

Excel Statistical Analysis 18: Addition Law of Probability, OR Logical Test: Formulas & PivotTables    (17:22 min)

Excel Statistical Analysis 19: Conditional Probability 5 Examples :   (15:19 min)

Excel Statistical Analysis 20: Joint Probability Table: Dynamic Spilled Array or PivotTable? :   (9 min)

Excel Statistical Analysis 21: Multiplication Law of Probability, AND Logical Test, Probability Tree :   (11:25 min)

Excel Statistical Analysis 22: Bayes’ Theorem, Tabular Method, Probability Tree, SUMPRODUCT function :   (21:48 min)

3) When you are done studying the videos and completing the examples from the video for practice, then you download homework Excel File and complete homework problems for practice.