[BAB210] Business Statistics

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  \sigma known:

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

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

15. Hypothesis Testing of population mean with  \sigma known: H_0: \mu=295, H_a: \mu \neq 295: two-tail test

16. Hypothesis Testing of population mean with  \sigma unknown: H_0: \mu \leq 7, H_a: \mu > 7: upper tail test

17. Hypothesis Testing of population proportion: H_0: p \leq 0.20, H_a: p 0.2 7: upper tail test

18. Regression Analysis:

Leave a Reply

Your email address will not be published. Required fields are marked *

css.php