Microsoft Excel 2003 Advanced Training - FREE Tutorials

Data Validation
Preparing to Enter Data
Number / Date / Custom Error Messages
Validating List Data
Using Custom Warnings

Statistical Distributions
Terms & Concepts
The Normal Distribution
The Binomial Distribution - Tuition 1
The Binomial Distribution - Tuition 2
The Poisson Distribution

We hope you enjoyed the free lessons above. To view the complete contents including the chapters below, please purchase the CD. Alternatively you can sign up to the Online University and gain full, instant access to this, and all 450+ tutorials for only $30/£15 per month by clicking here
CLICK HERE TO BUY THIS TUTORIAL ON CD

Generating Random Data
Patterns / Dates / Uniform Distribution
Binary / Bernoulli / Normal Distribution
Poisson & Custom Distributions

Probability
Probability Terms & Definitions - Tuition 1
Probability Terms & Definitions - Tuition 2
The Laws of Probability
Computing Independent Probabilities - Tuition 1
Computing Independent Probabilities - Tuition 2
Computing Dependent Probabilities
Selecting a Random Sample: Set Up
Selecting a Random Sample: Execution
Sampling from a List - Tuition 1
Sampling from a List - Tuition 2
Sampling an Existing Database - Tuition 1
Sampling an Existing Database - Tuition 2
Adding Data to an Existing Database

Descriptive Statistics
The Default Histogram
Improving the Histogram with Custom Bins
Creating Descriptive Statistics
Using Inline Functions
A Histogram of 2006 Restaurant Bills
Unconfounding The Data - Tuition 1
Unconfounding The Data - Tuition 2
The Pareto Chart - Tuition 1
The Pareto Chart - Tuition 2

Computing Probabilities w/ Distributions
Using the Binomial - Tuition 1
Using the Binomial - Tuition 2
Using Compliments
Using the Poisson
Building a Histogram
When to Use the Normal Distribution
Computing Probabilities with Normdist()
Norminv() / Normal vs. Poisson

Relationships
Relationships in Anscombe's Data
The Types of Graphs in Excel
Pivot Tables & Pivot Charts
Scatter Diagrams
Pivot Tables with Multiple Variables
Pivot Tables & Pivot Charts - Tuition 1
Pivot Tables & Pivot Charts - Tuition 2
Chi-Squared: Getting Ready
Chi-Squared: How Chi-Squared Works
Chi-Squared: Expected Values
Chi-Squared: Computing Expected Values
Chi-Squared: Summarizing the Data
A 2nd Chi-Squared Test - Tuition 1
A 2nd Chi-Squared Test - Tuition 2
Finishing Our 2nd Chi-Squared Test
Intro to Correlation
Your First Correlation In Date & Bill
Computing More Correlations

Graphical analysis
Improving Our Histogram
Reformatting Our Scatter Chart
Formatting Axes & Finishing Touches
Other Chart Options
Graphing Multiple Variables
Multiple Variables: The Plot Area
Multiple Variables: Lines & Ordering
Multiple Variables: Axes & Titles

Inferential Statistics - Regression
The Trend Line
R-Squared & the Regression Equation
Regression: R-Squared & Significance
Coefficients & Residuals
Residual & Line Fit Plots
Making Predictions
Identifying Data Sets for Regression
The Pivot Table - Tuition 1
The Pivot Table - Tuition 2
Regression by Total Bill
Regression by Average Bill - Tuition 1
Regression by Average Bill - Tuition 2
Regression by Type
Banquet Estimates
Estimating Our Error
Buffet Estimates

Inferential Statistics in ANOVA
t-Test: Setting Up the t-Test
t-Test: Consulting Our Pivot Table
t-Test: Running the t-Test
t-Test: Interpreting the Results
ANOVA: Introduction
ANOVA: Preparing the Data
ANOVA: Running ANOVA & Checking Variances
ANOVA: Interpreting the Results
ANOVA: Understanding the Statistics
Graphing the Confidence Intervals
Computing the Confidence Intervals

Wrap-up & Review
Data Classes / Validation / Distributions
Generating Data & Probability Concepts
Histograms & Descriptive Statistics
Pivot Tables / Chi-Squared / Correlation
Improving Graphs & Linear Regression
t-Test & ANOVA

Credits
About the Authors

CLICK HERE TO BUY THIS TUTORIAL ON CD