1) Download files:
Excel File that goes with Videos: Ch04-ESA.xlsm
PDF Notes that go along with Videos:
Ch04-ESA.pdf
CSV Fie that goes along with video #16:
BasicRetrofitRecords.csv
Data Set For Ch 04 Homework File #Case 2 page 215: MarketBasket.csv
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
Excel Statistical Analysis 17: AND, OR, and NOT Logical Tests for COUNTIFS &
FILTER Functions
Excel Statistical Analysis 18: Addition Law of Probability, OR Logical Test:
Formulas & PivotTables
Excel Statistical Analysis 19: Conditional Probability 5 Examples :
Excel Statistical Analysis 20: Joint Probability Table: Dynamic Spilled Array or
PivotTable? :
Excel Statistical Analysis 21: Multiplication Law of Probability, AND Logical
Test, Probability Tree :
Excel Statistical Analysis 22: Bayes’ Theorem, Tabular Method, Probability Tree,
SUMPRODUCT function :
3) When you are done studying the videos, then you download homework templates from Canvas, read the textbook, and complete textbook homework problems for practice.
4) After you are done studying the above videos and textbook work, download the Test #4 file and the test csv file to the Busn 210 class folder you created in video #1.
Here are the
files:
Test04
csv file
for test
After you have completed your test, then upload to the Home Area of Canvas.