Introduction
Welcome
()
Using the exercise files
()
1. Introducing Statistics
Introducing statistical analysis
()
Understanding statistical terms
()
Using statistics
()
2. Learning Useful Excel Techniques
Creating and using an Excel table
()
Installing the Analysis ToolPak
()
Auditing formulas step by step
()
3. Summarizing Data Using Tables and Graphics
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
()
4. Describing Data Using Numerical Methods
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
()
5. Using Probability Distributions
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
()
6. Sampling Values from a Population
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
()
7. Testing Hypotheses
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
()
8. Using Linear and Multiple Regression
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
()
Conclusion
Additional Resources
()
Ex_Files_Ex07_Bus_Stats.zip
(604 KB)