Statistics can be used in business to support better decision-making. In the Business Statistics with Excel course, we focus on simple statistical analyses that can be conducted with Microsoft Excel, and show the situations in which these analyses can be used. The topics covered include data sampling, covariance and correlation, regression analysis, probability theory, nonprobability sampling, the confidence interval, and sales forecasting.
Learning Objectives
Upon successful completion of this course, participants will be able to:
Identify the components needed for a statistical analysis.
Specify the characteristics of the various charts used to describe data.
Identify the characteristics of the coefficient of variation.
Specify the characteristics of a binomial distribution.
Identify the characteristics of a confidence interval, and describe how it is calculated.
Recall how to calculate the different types of forecast options in Excel.
Specify components of an Excel regression analysis report.
Major Topics
Data Analysis
Covariance and Correlation
Variable Forecasting Options
Probability Theory
Sampling Techniques
The Central Limit Theorem
