1) Download files:
Excel File that goes with Videos:
Section01-ESA.xlsx
CSV File that goes along with video #04:
Section01-ESA-AutoData.csv
Excel Homework for Section 1: Section01-HW.xlsx
(practice for test: do not hand in)
CSV File that goes along with homework #3:
Section01-HW-AutoData.csv
Pdf Notes for Section 1: Section01-Notes.pdf (click to view, right-click and Save As to download)
2) Click below links to watch class videos at YouTube:
First watch: How To Access Excel F Keys on Laptop Computer
Excel Statistical Analysis 01: Data & Statistics (22:55 min)
Excel Statistical Analysis 02: Structure of Excel files (19:56 min)
Excel Statistical Analysis 03: Excel Worksheet Formulas (43:19 min)
Excel Statistical Analysis 04: PivotTable & Power Query to Build Frequency Distributions (36:20 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.