1) Download files:
Excel File that goes with Videos: Ch09-ESA.xlsm
PDF Notes that go along with Videos:
Ch09-ESA.pdf
and
Ch09-ESA-JustFormulas.pdf
2) Click below links to watch class videos at YouTube:
Excel Statistical Analysis 43: Hypothesis Testing: P-value & Critical Value Methods: 1 Tail Upper (32:47 min)
Excel Statistical Analysis 44: Hypothesis Testing with Z Distribution, 1 Tail Lower (Left) Test (10:57 min)
Excel Statistical Analysis 45: Hypothesis Testing with Z Distribution, Two Tail Test Example (09:55 min)
Excel Statistical Analysis 46: Hypothesis Testing with T Distribution, 1 Tail Upper (Right) Test (11:01 min)
Excel Statistical Analysis 47: Hypothesis Testing with T Distribution, 1 Tail Lower (Left) Test (07:47 min)
Excel Statistical Analysis 48: Hypothesis Testing with T Distribution, Two Tail Example (08:53 min)
Excel Statistical Analysis 49: Hypothesis Testing for Proportion (Binominal) using Normal Curve (07:26 min)
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 all videos and textbook work up through chapter 9, download the Test #7 file and the test csv file to the Busn 210 class folder you created in video #1.
Download the Test #7 files :
Test07
csv file
for test Problem04
After you have completed your test, then upload to the Home Area of Canvas.