I’m teaching this course during the summer semester at Seneca College. The course outline can be found here:

https://apps.senecacollege.ca/ssos/findOutline.do?subjectCode=BAB210

We are into our second half of the semester now and being able to use Excel is an important part for the successful completion of it. I made several short videos explaining how to use certain built-in functions in Excel. More will be coming up as our course progresses.

1. How to draw a bar chart for categorical data:

2. How to build frequency distribution table and draw histogram:

3. How to do cross tabulation:

4. How to use descriptive states tool in Excel:

5. Excel functions to find mean, median, mode,variance and standard deviation:

6. How to find covariance and correlation for two sets of data:

7. How to draw a box plot:

8. How to draw comparative box plot:

9. Continuous Probability Distributions part I:

10. Continuous Probability Distribution II:

11. how to select random samples

12. How to construct confidence interval for a population mean with population known:

13. How to construct confidence interval for a population mean with population unknown:

14. How to construct confidence interval for a population proportion:

15. Hypothesis Testing of population mean with known: : two-tail test

16. Hypothesis Testing of population mean with unknown: : upper tail test

17. Hypothesis Testing of population proportion: : upper tail test

18. Regression Analysis: 