Business 204
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)
2.2 Excel Tutorial Bar Charts and Pie Charts
2.3 Excel Tutorial Line Chart and Scatter Diagram
Chapter 3 Excel Tutorial: Mean, Median, Mode, Standard Deviation, z-values
Ch. 5 Excel Tutorial on Binomial Distribution
Ch. 5 Excel Tutorial on Poisson Distribution
Ch. 6 Normal Distribution Excel Tutorial
Ch. 6 Exponential Distribution Excel Tutorial
Ch. 7 Excel Tutorial on Sampling Distributions
Ch. 8 Excel Tutorial Critical Values and Margin of Error
Ch. 9 Excel Tutorial for Critical Values and P-Values
Chapter 10 Excel Tutorial on Hypothesis Testing of Two Populations
14.1 Scatterplots and Correlation
Note: video lecture with embedded Excel tutorials
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
Linear Regression demo begins at 5 min and 30 seconds