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.
- 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: