Business Statistics

Curriculum guideline

Effective Date:
Course
Discontinued
No
Course code
BUSN 2429
Descriptive
Business Statistics
Department
Business
Faculty
Commerce & Business Administration
Credits
3.00
Start date
End term
Not Specified
PLAR
No
Semester length
15 weeks
Max class size
35
Course designation
None
Industry designation
None
Contact hours

Lecture: 3 Hours/week

and

Seminar: 1 Hour/week

Method(s) of instruction
Lecture
Seminar
Learning activities

Lectures and seminars.

Course description
This course will provide students with an introduction to statistics. Students will learn to solve problems using computer spreadsheets. Topics include measures of central tendency and dispersion, probability, sampling, normal and binomial distributions, confidence intervals and hypothesis testing and regression analysis. Students will be required to have basic Excel skills.
Course content
  1. Descriptive Statistics:  frequency distributions, graphical displays, measures of central tendency, measures of dispersion.
  2. Probability:  experiments, counting rules, assigning probabilities, events, complement, exclusion, intersection, union, addition law, conditional probability.
  3. Discrete Probability Distributions:  expected value and variance, binomial distribution.
  4. Continuous Probability Distributions: normal probability distributions.
  5. Sampling Distributions:  random sampling, sampling distribution of sample mean and sample proportion.
  6. Interval Estimation:  means and proportions, small and large samples, determining sample size.
  7. Hypothesis Testing:  formulating and testing a research hypothesis, I and II tailed tests about sample mean and proportion, Type I and II error.
  8. Statistical Inference with Two Populations (independent/dependent samples):  interval estimation and hypothesis tests for difference between two means and between two proportions.
  9. Computer Analysis with Excel Spreadsheets:  creation of spreadsheets, histograms, frequency tables, pivot tables (optional), scatter charts, pie charts, bar charts, box plots, use of probability distribution functions, interval estimates, hypothesis tests, and correlation and regression analysis.
  10. Simple Linear Regression:  least squares, model and assumption, R-squared, prediction.
Learning outcomes

At the end of the course, the successful student should be able to:

  1. collect statistical data using appropriate sampling techniques;
  2. organize statistical data and calculate measures of central tendency and variation;
  3. calculate the probability of events when they are mutually exclusive, independent and dependent;
  4. apply binomial and normal distribution to make probability estimates;
  5. set up confidence intervals for population means and proportions;
  6. test hypotheses and evaluate claims about population parameters using sample data;
  7. perform simple regression analysis to determine significance of relationship between two variables;
  8. use computer spreadsheets such as Excel, PHStat, MegaStat or SPSS to solve statistical problems.

 

Means of assessment

Assessment will be based on course objectives and will be carried out in accordance with the Douglas College Evaluation Policy. An evaluation schedule is presented at the beginning of the course. This is a graded course.

Instructors may use a student’s record of attendance and/or level of active participation in the course as part of the student’s graded performance. Where this occurs, expectations and grade calculations regarding class attendance and participation will be clearly defined in the Instructor Course Outline.

Final Exam           30%
Term Examinations (2-3) 20% - 50%
Assignments (6-12) 15% - 25%
Participation  0% -  5%
     100%
           

Note:  Students must achieve a grade of at least 50% on the combined examination components to pass the course.

Note: At least one assessment must be done using a computer lab.

Students may conduct research as part of their coursework in this class. Instructors for the course are responsible for ensuring that student research projects comply with College policies on ethical conduct for research involving humans, which can require obtaining Informed Consent from participants and getting the approval of the Douglas College Research Ethics Board prior to conducting the research.

Textbook materials

Textbooks and Materials to be Purchased by Students will be chosen from the following list or other textbooks approved by the department:

  1. Donnely, R. Business Statistics (latest edition). Pearson Education; or
  2. Groebner, D., Shannon, P., Fry, P., and Smith, K. Business Statistics: A Decision-Making Approach (latest edition). Pearson Education; or
  3. Sharpe, N., DeVeaux, R.,Velleman, P., and Wright. Business Statistics. (latest edition). Pearson Education.

Students may be required to buy software such as Excel, PHStat, MegaStat, and/or SPSS.

Use of only Commerce and Business Administration faculty-approved calculators.

Prerequisites

FINC 1231 or (Principles of Math 12 with a C or Pre-Calculus 12 with a C or equivalent) OR currently active in one of the following:

PBD Accounting
PBD Advanced Supply Chain Management
PBD Computer and Information Systems
PBD Digital Marketing
PBD Finance
PBD International Supply Chain Management
PBD Project Management
PDD Accounting
PDD Accounting Studies
PDD Data Analytics
PDD Financial Analysis
PDD Supply Chain Management

 

Corequisites

None

Equivalencies

None

Which prerequisite