1) Download files:
Excel File that goes with Videos:
Ch01-ESA.xlsm
CSV Fie that goes along with video #04:
Ch01-ESA-AutoData.csv
Data Set For Ch 01 Homework File #25: AutoData.csv
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, 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 #1 file and the test csv file to the Busn 210 class folder you created in video #1.
Here are the
files to download:
Test01
csv file
for test
After you have completed your test, then upload to the Home Area of Canvas.