Here are some files from Professor Annie Ngo (Business). They are based around using Excel and are saved as Excel files. To access, click this link and then click to download the file you're looking for: Link to google drive for downloads.

She welcomes comments or questions from faculty, staff, or students if there are any issues or concerns. ango@miracosta.edu

Professor Ngo has created a YouTube account as well for her videos and explanations for the course: https://www.youtube.com/c/ProfessorNgo

Contains course content and tutorials for BUS147 Personal Finance and BUS204 Business Statistics

2.1 Excel Tutorial Frequency Histograms (Excel 2016 and Pivot Tables)

https://youtu.be/dlW9CLHpnVk

2.2 Excel Tutorial Bar Charts and Pie Charts

https://youtu.be/DQAlcDZuZag

2.3 Excel Tutorial Line Chart and Scatter Diagram

https://youtu.be/V1SH9EFAbDI

Chapter 3 Excel Tutorial: Mean, Median, Mode, Standard Deviation, z-values

https://youtu.be/XSiEv65ShWo

Ch. 5 Excel Tutorial on Binomial Distribution

https://youtu.be/a7bqCdHBg2c

Ch. 5 Excel Tutorial on Poisson Distribution

https://youtu.be/qNkdqfFb3kU

Ch. 6 Normal Distribution Excel Tutorial

https://youtu.be/LUmmGpuPxII

Ch. 6 Exponential Distribution Excel Tutorial

https://youtu.be/hmH__rehEIM

Ch. 7 Excel Tutorial on Sampling Distributions

https://youtu.be/rA2R5bG3DQ4

Ch. 8 Excel Tutorial Critical Values and Margin of Error

https://youtu.be/gnHNC1P2BBQ

Ch. 9 Excel Tutorial for Critical Values and P-Values

https://youtu.be/2FndZ3emyp0

Chapter 10 Excel Tutorial on Hypothesis Testing of Two Populations

https://youtu.be/ghFp4pB6d_E

14.1 Scatterplots and Correlation

Note: video lecture with embedded Excel tutorials

https://youtu.be/WGKInqOAuV0

Scatterplot demo begins at 7 min

Correlation Coefficient demo begins at 8 min and 15 seconds

14.2 Simple Linear Regression

Note: video lecture with embedded Excel tutorials

https://youtu.be/mc8lUKBSYg4

Linear Regression demo begins at 5 min and 30 seconds

Pivot Tables Tutorial

https://youtu.be/iBhu1I4R53s