Title Language  : 

Find a Course... Try for Free!

 

Microsoft Excel 2003 for Statistics Tutorials

Course Content
Microsoft Excel is the world's best-selling mathematical application, one that is installed on nearly every business computer out there. Although not a statistical application, Excel can perform many basic statistical tasks, from computing simple descriptive statistics such as mean and standard deviation, to complex regression analyses, chi-squared and t tests, and Analysis of Variance (ANOVAs). Join Mark and Beth Clarkson as they introduce you to the basics of statistics, statistical analysis, and statistical graphing with Microsoft Excel. Each step along the way is illustrated with real-world situations. You can start learning right now by clicking one of the movie topics below.
QT To view the Free Tutorials listed below, you must have QuickTime installed. Please note that the online free samples have been compressed for quicker downloads. Purchased CDs have higher sound and video quality.
Monitor resolution needs to be set to at least 1024 by 768 to view the entire movie.

лл Hide This
Introduction
Instructors & Overview of Course (04:50)
Values & Variables - Important Terms (06:12)
Data Validation
Preparing to Enter Data (03:51)
Number / Date / Custom Error Messages (04:19)
Validating List Data (05:11)
Using Custom Warnings (03:22)
Statistical Distributions
Terms & Concepts (03:39)
The Normal Distribution (06:21)
The Binomial Distribution pt. 1 (03:47)
The Binomial Distribution pt. 2 (03:30)
The Poisson Distribution (02:55)
Generating Random Data
Patterns / Dates / Uniform Distribution (06:36)
Binary / Bernoulli / Normal Distribution (05:31)
Poisson & Custom Distributions (05:46)
Probability
Probability Terms & Definitions pt. 1 (06:55)
Probability Terms & Definitions pt. 2 (00:43)
The Laws of Probability (04:45)
Computing Independent Probabilities pt. 1 (03:27)
Computing Independent Probabilities pt. 2 (03:05)
Computing Dependent Probabilities (05:36)
Selecting a Random Sample: Set Up (04:23)
Selecting a Random Sample: Execution (04:12)
Sampling from a List pt. 1 (04:02)
Sampling from a List pt. 2 (06:19)
Sampling an Existing Database pt. 1 (03:23)
Sampling an Existing Database pt. 2 (05:31)
Adding Data to an Existing Database (03:26)
Descriptive Statistics
The Default Histogram (03:58)
Improving the Histogram with Custom Bins (03:24)
Creating Descriptive Statistics (06:35)
Using Inline Functions (03:53)
A Histogram of 2006 Restaurant Bills (03:27)
Unconfounding The Data pt. 1 (06:18)
Unconfounding The Data pt. 2 (02:20)
The Pareto Chart pt. 1 (04:31)
The Pareto Chart pt. 2 (03:51)
Computing Probabilities w/ Distributions
Using the Binomial pt. 1 (03:27)
Using the Binomial pt. 2 (04:27)
Using Compliments (03:37)
Using the Poisson (04:01)
Building a Histogram (05:00)
When to Use the Normal Distribution (03:47)
Computing Probabilities with Normdist() (03:57)
Norminv() / Normal vs. Poisson (04:51)
Relationships
Relationships in Anscombe's Data (04:34)
The Types of Graphs in Excel (03:26)
Pivot Tables & Pivot Charts (07:16)
Scatter Diagrams (06:00)
Pivot Tables with Multiple Variables (06:58)
Pivot Tables & Pivot Charts pt. 1 (02:51)
Pivot Tables & Pivot Charts pt. 2 (05:06)
Chi-Squared: Getting Ready (03:47)
Chi-Squared: How Chi-Squared Works (05:31)
Chi-Squared: Expected Values (06:54)
Chi-Squared: Computing Expected Values (05:06)
Chi-Squared: Summarizing the Data (07:32)
A 2nd Chi-Squared Test pt. 1 (04:52)
A 2nd Chi-Squared Test pt. 2 (07:01)
Finishing Our 2nd Chi-Squared Test (07:27)
Intro to Correlation (07:48)
Your First Correlation In Date & Bill (05:21)
Computing More Correlations (05:50)
Graphical analysis
Improving Our Histogram (06:16)
Reformatting Our Scatter Chart (05:45)
Formatting Axes & Finishing Touches (07:31)
Other Chart Options (05:44)
Graphing Multiple Variables (03:39)
Multiple Variables: The Plot Area (04:48)
Multiple Variables: Lines & Ordering (05:53)
Multiple Variables: Axes & Titles (04:20)
Inferential Statistics - Regression
The Trend Line (06:39)
R-Squared & the Regression Equation (06:39)
Regression: R-Squared & Significance (04:28)
Coefficients & Residuals (05:32)
Residual & Line Fit Plots (04:33)
Making Predictions (02:29)
Identifying Data Sets for Regression (06:38)
The Pivot Table pt. 1 (04:01)
The Pivot Table pt. 2 (02:49)
Regression by Total Bill (03:25)
Regression by Average Bill pt. 1 (02:44)
Regression by Average Bill pt. 2 (02:42)
Regression by Type (07:06)
Banquet Estimates (02:00)
Estimating Our Error (05:05)
Buffet Estimates (04:00)
Inferential Statistics in ANOVA
t-Test: Setting Up the t-Test (05:08)
t-Test: Consulting Our Pivot Table (04:42)
t-Test: Running the t-Test (06:08)
t-Test: Interpreting the Results (03:56)
ANOVA: Introduction (02:45)
ANOVA: Preparing the Data (03:34)
ANOVA: Running ANOVA & Checking Variances (04:11)
ANOVA: Interpreting the Results (02:57)
ANOVA: Understanding the Statistics (06:11)
Graphing the Confidence Intervals (03:27)
Computing the Confidence Intervals (05:54)
Wrap-up & Review
Data Classes / Validation / Distributions (04:16)
Generating Data & Probability Concepts (03:38)
Histograms & Descriptive Statistics (03:32)
Pivot Tables / Chi-Squared / Correlation (03:48)
Improving Graphs & Linear Regression (04:02)
t-Test & ANOVA (02:28)
Credits
About the Authors (00:57)

Email this Page     Send us Feedback
Tutorial Information / Pricing
Title: Microsoft Excel 2003 for Statistics
Author: Mark and Elizabeth Clarkson
SKU: 33751
ISBN: 1-933736-73-9
Duration: 8.5 hrs / 104 Lessons
Compatibility: Win XP, 2000, 98, NT, Mac OS X, OS 9

Online University Access all our Training for only 30
The Online University provides unlimited 24/7 access to ALL of VTC's incredible training content for the low fixed price of just $30/month (USD)
SIGNUP LEARN MORE »

Get this title on CD
Single User: US$ 99.95 - Purchase CD / Add to Cart

Multi User (10): US$ 500.00 - Purchase CD / Add to Cart

Select Bandwidth
Click "High Bandwidth" if you want to view movies at the highest quality available. Click "Low Bandwidth" if on a slow dial-up connection (28 Kbps and such). The low bandwidth movies are slightly more compressed and smaller in file size, allowing for faster streaming.

Select:

Select Category

Special Groups

Publisher or Products