clear-dot.gif
Search for a Title:
AddThis Social Bookmark Button
clear-dot.gif ON NOW: ALL Training CD's on sale for $99.95 CDN!!! clear-dot.gif
clear-dot.gif
   Master Microsoft Excel 2003 for Statistics - Free Tutorials!
clear-dot.gif
clear-dot.gif
clear-dot.gif clear-dot.gif clear-dot.gif
clear-dot.gif clear-dot.gif clear-dot.gif
clear-dot.gif clear-dot.gif clear-dot.gif
clear-dot.gif
This Microsoft Excel 2003 statistics training will show you how to get the most out of your Excel software and be able to use it as a statistical application. These tutorials will introduce you to the basic concepts of statistics, analysis, and graphing with Excel. Authors, Mark and Beth Clarkson provide over 8 hours of video tutorials using practical examples and demonstrations that you can work along with using the exercise files included. Learn how to perform simple to complex statistical functions using Excel, from data validation to computing probabilities. The material covered in the Microsoft Excel 2003 statistics tutorials is of an intermediate level and builds on an existing knowledge of Microsoft Excel, if you are new to Excel we suggest that you start with our fundamentals training title, Microsoft Excel 2003.
Microsoft Excel 2003 for Statistics Training
Access the complete Microsoft Excel 2003 for Statistics Training title online with just your Web browser. Join our Online University and have unlimited access to these tutorials for Microsoft Excel 2003 for Statistics plus all our 400+ other titles for one low price! LEARN MORE or SIGN UP NOW FOR INSTANT ACCESS
OR
Learn Microsoft Excel 2003 for Statistics from our PC and Mac compatible CDRom. The affordable price of $124.95 gives you high quality software training that is easy for anyone to understand and follow. Start training straight away with our Free lesson links on the right or BUY THIS CD NOW!

Are you ready to start your learning RIGHT NOW? You can have immediate access to more than 2500 hours of VTC Training just minutes from now, and for the incredibly low price of $30/month OR LESS!

The VTC Online University provides unlimited 24/7 access to ALL of VTC's incredible training content.

-- More Info / Subscribe Now! --

FREE Updates
VTC adds training for new software every week, and with the VTC Online University, you get immediate access to these new titles, for no additional cost! There are currently over 450 different software titles, and more are added EVERY MONTH!

-- More Info / Subscribe Now! --

No Long Term Committment
With the VTC Online University, you can signup for as little as ONE MONTH only! There is no minimum time committment, and you can cancel your membership at any time.

-- More Info / Subscribe Now! --

Training a Group?
Our Multi-User Online Account makes training groups of people efficient and cost effective. Businesses, Schools (from Elementary through Post Secondary), and Government Departments alike all over the world enjoy the freedom and benefits of our online training and tutorials from office, school, home, and on the go.

-- Multi-User Licensing Info --

Microsoft Excel 2003 for Statistics
- Information About This Title -
Click Here To Purchase
Proper Title: Microsoft Excel 2003 for Statistics
Description: Click here to open / close full description
This Microsoft Excel 2003 statistics training will show you how to get the most out of your Excel software and be able to use it as a statistical application. These tutorials will introduce you to the basic concepts of statistics, analysis, and graphing with Excel. Authors, Mark and Beth Clarkson provide over 8 hours of video tutorials using practical examples and demonstrations that you can work along with using the exercise files included. Learn how to perform simple to complex statistical functions using Excel, from data validation to computing probabilities. The material covered in the Microsoft Excel 2003 statistics tutorials is of an intermediate level and builds on an existing knowledge of Microsoft Excel, if you are new to Excel we suggest that you start with our fundamentals training title, Microsoft Excel 2003.

-Close-
Instructor: Mark and Elizabeth Clarkson (more by this author)
Instruction: 104 Tutorials - Duration: 8.5 hrs
First Release: 2007-04-12
Compatitibility: Vista, XP, NT, 2000, 98, Mac OS9, Mac OS X 10.1+
In Stock? Yes - 2-5 days shipping
Price: $124.95 $99.95 ON SALE!
Click Here To Purchase
Why Learn With VTC?!
  1. Let an expert teach you Microsoft Excel 2003 for Statistics
  2. No classrooms or schedules - you learn on YOUR terms
  3. No books to read - watch instructional video right on your computer
  4. VTC training methods ensure the highest possible retention and fastest learning
  5. Use VTC materials for future reference / refresher
  6. Share CDRom training with others, friends, colleagues
  7. Used by many schools, universities, and big business world wide
  8. The most cost effective training available for Microsoft Excel 2003 for Statistics
 
Below is content list for all of the lessons included with the Microsoft Excel 2003 for Statistics Training. Click on the linked lessons to watch Free. You must have Quicktime installed on your computer - if you are using a recent computer, then chances are you already do.
Free Demo Lessons

Introduction
movie image Instructors & Overview of Course
movie image Values & Variables - Important Terms

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

Statistical Distributions
movie image Terms & Concepts
movie image The Normal Distribution
movie image The Binomial Distribution pt. 1
movie image The Binomial Distribution pt. 2
movie image The Poisson Distribution


... More lessons below ...

Would you like to continue? You can have instant access to the rest of this training for just $30.00 through our Online University, or you can purchase the CDRom version!

. Subscribe Now!
. Online University Info
. Purchase CDRom Now

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
clear-dot
blue dot
clear-dot

Want to be notified of new releases and other product information?
Enter your email address below to signup for our newsletter.

clear-dot
blue dot
clear-dot
Online Learning | Contact Us | Tech Support | XML RSS Feed
clear-dot
blue dot

VTC Canada
sales@vtcCanada.com


©2012 VTC Canada All Rights Reserved.