Excel for Statistics Tutorial - Video Training CD / DVD

Self Study, Excel for Statistics Tutorial Video on CD - DVD. The tutor guides you using step-by-step examples. Learn directly from your own desk high quality training videos at an affordable price. Works on both PC and Mac.

These Microsoft Excel 2003 statistics tutorials are not designed for users with little or no knowledge of Microsoft Excel, these tutorials however are aimed towards the user that already has a basic understanding of the application and wishes to expand their knowledge into the area of Statistics. Using working examples in conjunction with the narrated QuickTime videos you can expect to learn how to accomplish professional results quickly, you should also get an ideal of the kind of problems and solutions that would be needed to work with Excel in the creation of Statistics in a commercial environment, this training course also comes with practical exercise files which can be used to follow along with the author, if you so wish. Overall an excellent tutorial for users of an intermediate level, beginners should consider the Microsoft Excel Fundamentals first..

Excel for Statistics Tutorial CD / DVD

Creates the perfect self-paced learning environment
on your own desktop.

Professionally created, comprehensive video based training that's easy to follow. At an unbelievable price.

Try for FREE - NOW. To help you evaluate this training CD / DVD the first 3 chapters are available for free, click on any of the links below for a FREE DEMO.

Problems Playing the Demos?

Benefits

Professional Tuition by expert
Free Certificate with each Tutorial
Works on PC or Mac

Topics Covered on this Training Video Include:

Introduction

Data Validation

Statistical Distributions

We hope you enjoyed the free videos above. To watch all this course including the chapters below please purchase the CD.

$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

About this Excel for Statistics Training CD

Title :	Excel for Statistics
Tutor :	Mark Clarkson Other tutorials by Mark Clarkson
Videos :	104 Lessons- Video run time: 8.5 Hours
Availability :	Immediate Dispatch
Compatibility:	Vista, 98, 2000, NT, XP, Mac OS, OSX
Released	2007-04-14
Work files	Yes
Price US / Canadian Sales	$99.95

107 In Stock

Purchase Orders: from Schools, Colleges, Government and Military accepted

Multi User Network Version Available

This training is also available in Multi User format for Schools and Corporate users.

10 Multi User $500

Why use this method of video training ?

Learn Excel for Statistics from an accredited expert in days.
Ideal for beginners, easy to follow videos that offer visual clarity.
Master a full application for a fraction of the cost of classroom based training, and faster than with a manual.
Unique teaching method that offers accelerated learning and high retention.
Used by many large companies, schools, universities,
click to see some of our customers.
Learn from your own desk at a speed that suits you
Cost effective tuition from leading expert tutors
You control the pace, training can be stopped, rewound or fast forwarded as required.
High Quality Tutorial Videos on CD / DVD or Online. PC / Mac Compatible. Great tuition at an affordable price

Want to hear what our customers say about our products?

Associated Tutorials:

Excel for Statistics Related Training Videos:

Free Certificate. Prove Your Credentials

We now offer all customers a free certificate to verify they have undertaken a Excel for Statistics training course, the unique certification number allows third parties to check the authenticity of your certificate online. After your purchase you can download your Excel for Statistics certificate without delay.

Instant Online Access all the Training Videos for only $30.00

Unlimited Accesss to 60,000 Training Video only $30.
Not sure which training CD titles to purchase ? Why not join our Online University and have unlimited access to all our tutorial videos for one low price of $30 per month.

No contract , No minimum period, and no commitment on your part.

You can have access to every title we list on this site for just $30 per month. When you sign up you get instant access with absolutely no restrictions or limits. Log on from any location and watch as much as you like.

When your finished cancelling is easy, just click the cancel button, that's it, no questions, your in total control.