Overview
-
Shows managers and executives how to assess their organization's data effectively by applying statistical analysis techniques.
Syllabus
-
Introduction
- Welcome
- Using the exercise files
- Introducing statistical analysis
- Understanding statistical terms
- Using statistics
- Creating and using an Excel table
- Installing the Analysis ToolPak
- Auditing formulas step by step
- Creating frequency distributions for qualitative data
- Summarizing data using bar graphs and pie charts
- Creating a frequency distribution using the FREQUENCY function
- Creating a histogram
- Calculating a running total
- Summarizing data using a PivotTable
- Calculating mean, median, and mode
- Calculating a moving average
- Calculating a seasonal forecast
- Calculating percentiles and quartiles
- Calculating variance and standard deviation
- Summarizing data using descriptive statistics
- Summarizing data using z-scores
- Summarizing data using t-scores
- Calculating covariance
- Calculating correlation
- Calculating correlations for more than two data sets
- Calculating and interpreting chi-square values
- Visualizing the normal data distribution
- Generating random values
- Calculating binomial probabilities
- Calculating probabilities using the exponential distribution
- Calculating values using the Poisson distribution
- Calculating dependent trials using the hypergeometric distribution
- Calculating probabilities, permutations, and combinations
- Selecting effective data samples
- Inferring a population mean from a sample mean
- Inferring population distributions based on a proportion of the data set
- Estimating the size of a population given numbered samples
- Calculating a confidence interval for a large sample
- Calculating a confidence interval for a small sample using t-tests
- Calculating a confidence interval given a population proportion
- Calculating sample size required for a given confidence level
- Defining hypotheses and identifying errors
- Performing one-tailed tests on a large sample's mean
- Performing two-tailed tests on a large sample's mean
- Testing a small sample's mean
- Testing the mean of a population proportion
- Estimating the difference between two populations' means
- Testing hypotheses related to population means
- Inferring results from matched samples selected from two populations
- Analyzing variance using an F-test
- Analyzing variance using ANOVA
- Creating a linear regression line for an XY (scatter) chart
- Analyzing and interpreting data from the Regression tool
- Estimating and predicting data using the regression formula
- Developing a multiple regression model
- Additional Resources
