Statistics for Excel Video Tutorial - Training CD

Affordable Training you can depend on. Learn from an Expert from the comfort of your own desk, at a pace that suits you.

Benefits

• Works on PC or Mac
• Professional Tutition by Experts
• Self-Paced Learning Interface
• Builds Practical Skills Quickly
• Rapid Learning - High Retention
• Free Certificate with each Tutorial

Client Testimonials

• 'Bravo I give this product four stars and two thumbs up! Now everything I need to know is just a few mouse clicks away. Using your products is easy and fun - they really bring the information to life! Thanks to you my boring old computer manuals are now collecting dust. I'm thinking of using them to light the barbecue. If VTC training movies ever go to the big screen I'll be sitting front row with a bucket of popcorn, you bet.'
  John Mariani
  San Jose, CA ;

Just Released Training

Just Released this week.
• 
Poser 8 Tutorial Video

Select your PlayBack Preference
QuickTime Flash

Topics covered on this Tutorial Video
are Listed Below:-

Introduction

• Instructors & Overview of Course
• Values & Variables - Important Terms

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 pt. 1
• The Binomial Distribution pt. 2
• The Poisson Distribution

The purchased version of this product contains all the movies listed below as well as all the featured samples above. US$ 99.95

Generating Random Data

• Patterns / Dates / Uniform Distribution
• Binary / Bernoulli / Normal Distribution
• Poisson & Custom Distributions

Probability

• Probability Terms & Definitions pt. 1
• Probability Terms & Definitions pt. 2
• The Laws of Probability
• Computing Independent Probabilities pt. 1
• Computing Independent Probabilities pt. 2
• Computing Dependent Probabilities
• Selecting a Random Sample: Set Up
• Selecting a Random Sample: Execution
• Sampling from a List pt. 1
• Sampling from a List pt. 2
• Sampling an Existing Database pt. 1
• Sampling an Existing Database pt. 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 pt. 1
• Unconfounding The Data pt. 2
• The Pareto Chart pt. 1
• The Pareto Chart pt. 2

Computing Probabilities w/ Distributions

• Using the Binomial pt. 1
• Using the Binomial pt. 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 pt. 1
• Pivot Tables & Pivot Charts pt. 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 pt. 1
• A 2nd Chi-Squared Test pt. 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 pt. 1
• The Pivot Table pt. 2
• Regression by Total Bill
• Regression by Average Bill pt. 1
• Regression by Average Bill pt. 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

An effective training video that teaches using practical based examples and easy to follow instructions.

A self-paced learning interface that simplifies learning and breaks even the most complex topics down into easy to follow step-by-step instructions making it ideal for users of all levels

A proven video training product that's created by professionals and used by companies, schools, government and individuals the World over.

A verifiable Certificate Proving your Skills

Statistics for Excel Training - VIDEO INFO

TitleMicrosoft Excel 2003 for Statistics

TutorMark and Elizabeth Clarkson

Duration8.5 hours - 104 Movies

Price US$ 99.95

OSWin Vista XP, 2000, 98. Mac OS X

Delivery Ground / 2 day / Next Day

Product Code33751