|
|
|
|
|
|
|
|
Microsoft Excel 2003 for Statistics CD Training Course (Prices exclude VAT)
|
|
|
[to previous page]
[other products in "Business / Personal Development"]
|
|
|
| Product: |
Microsoft Excel 2003 for Statistics CD Training Course
8.5 hrs / 104 lessons. For Win Vista, XP, 2000, Mac OS X, OS 9, Linux
|
| Price: |
|
|
|
| Details: |
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) |
|
|
 |
|
From the Best Seller List : A+ 2009 Training - This complete CompTIA A+ Training Package covers the course objectives for the required A+ Essentials exam, aswell as for all three A+ Specialist Exams (one required): IT Technician, Remote/ Helpdesk Support and Depot Technician, which allows you to study the curriculum of your choice.
CBT Training | Distance Learning | LMS (Enterprise) | Online Learning
Best Sellers | Classroom Courses | Special Offers | MCSE Courses
Copyright 2002-2011 RCS Limited. All rights reserved. More
... |
