Self Study, 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.

Associated Tutorials: Microsoft Excel 2007 Tutorial | Crystal Reports | MCAS | Microsoft Excel Automation | Beginners MS Word 2010 | Microsoft Excel 2010 | Microsoft Access 2010 | Microsoft Project 2010 Tutorial | Crystal Reports 2011

Excel for Statistics Tutorial CD / DVD

When you order this Excel for Statistics Video Tutorial CD You'll Receive...
Over 8.5 hours of high quality video-based training that walks you through the program in easy to follow stages.

A training video that focuses on real life examples and teaches you
real life skills. These tutorials are structured to increase not only your skills but also your earning potential.

With this Training Video you will...
Learn Excel for Statistics from a leading expert and quickly master the skills required to work in a commercial environment.

Learn how to simplify your workflow and increase your productivity using tips and techniques of the pros. Ideal training for Beginners and Advanced users alike

Customer Comments
" Working on my own it's been a cutthroat business to get ahead, and your tutorials have allowed me to offer more skills to established clients and branch out to bring more in. "Robert Knowles, Minnesota

Excel for Statistics Tutorial CD / DVD

Create the best self-paced learning environment right on your own desktop.
Professionally created, comprehensive video based training that's easy to follow. At an unbelievable price.

Topics Covered on this Training Course

This Training is 8.5 Hours in Duration and Covers 104 Lessons.
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 Lesson 1
  • Probability Terms & Definitions Lesson 2
  • The Laws of Probability
  • Computing Independent Probabilities Lesson 1
  • Computing Independent Probabilities Lesson 2
  • Computing Dependent Probabilities
  • Selecting a Random Sample: Set Up
  • Selecting a Random Sample: Execution
  • Sampling from a List Lesson 1
  • Sampling from a List Lesson 2
  • Sampling an Existing Database Lesson 1
  • Sampling an Existing Database Lesson 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 Lesson 1
  • Unconfounding The Data Lesson 2
  • The Pareto Chart Lesson 1
  • The Pareto Chart Lesson 2
Computing Probabilities w/ Distributions
  • Using the Binomial Lesson 1
  • Using the Binomial Lesson 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 Lesson 1
  • Pivot Tables & Pivot Charts Lesson 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 Lesson 1
  • A 2nd Chi-Squared Test Lesson 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 Lesson 1
  • The Pivot Table Lesson 2
  • Regression by Total Bill
  • Regression by Average Bill Lesson 1
  • Regression by Average Bill Lesson 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

Select Playback Format for the Free Demos:

Quicktime
Flash

Did You Know ?

We offer more than 700 video-based courses, and you can watch the first three chapters of every listed course for FREE with no obligation to buy.

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
Compatibility Vista, XP, Windows 7, Mac OSX
Released 2007
Work files Yes
Availability Immediate Dispatch
Price US / Canadian Sales Only $99.95
Closed Captions Closed Captions are not Enabled on this title
102 in stock
Purchase Orders from Schools, Colleges, Government and Military Accepted

Mutli User Training Options

This training video is also available in Multi-user format, ideal for Schools, Universities, or Corporate users where training multiple delegates is the most cost effective way of training.

10 Multi User $500

Not Sure Which Titles to Buy? Unlimited Access to all -$30

Need to learn more than one topic? Get Unlimited Access to all the courses listed on this site for just $30!
Unlimited Access to over 70,000+ Training Videos

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.
No commitment on your part.

Within minutes you'll have instant, unlimited access to over 700 courses covering over 6000+ hours of training, all from the comfort of your own desk.

Need to learn from more than one location? Not a problem, you're free to access the training from anywhere you wish. It's highly cost effective learning with no limits. We also offer Multi User accounts for companies and schools who need to train multiple users.
Online Learning with No Limits

Why Is This Training Format So Effective?

  • Learn Excel for Statistics from an accredited expert in days.

Want to hear what our customers say about our products?

Related Training Videos

Microsoft Project Tutorial | FileMaker Tutorials | Excel Tutorial Videos| Online Excel for Statistics Training Courses

Prove your Knowledge - Free Certificate

Prove Your Credentials!
Free Certificate.