Business and Management Statistics Using Excel

Learn data analysis, hypothesis testing, ANOVA, and regression analysis intuitively using many examples.

Created by: Bahram Adrangi, PhD
Learning Statistics Hands-On Using MS EXCL

What Will I Learn?

• Be able to analyze data graphically and quantitatively
• Be able to derive population information from samples
• Understand probability distributions and perform tests of hypotheses about the population based on sample information.
• Be able to formulate, estimate regressions using sample data, and perform tests of hypotheses about the population

Requirements

• College or high school algebra and basic familiarity with MS Excel
• You only need high school algebra. The functions of Excel are covered in lecture videos and Excel lecture notes available to you.

Target audience

• Undergraduates in schools of business and economics departments, engineering, political science, psychology, sociology, as well as MBA students.
• Every undergraduate student business, economics, engineering, psychology, sociology, and political science is required to take a statistics course. This course offers a solid foundation for all undergraduates and MBA students.
• For instance ANOVA, regression analysis, hypothesis testing, descriptive statistics such as means, medians, modes, variance, covariance, and correlation coefficient are widely used concepts.