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 environmenton 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.

- Professional Tuition by expert
- Free Certificate with each Tutorial
- Works on PC or Mac
Introduction
Data Validation
- Preparing to Enter Data

- Number / Date / Custom Error Messages

- Validating List Data

- Using Custom Warnings

Statistical Distributions
- Terms & Concepts

- The Normal Distribution

- The Binomial Distribution pt. 1

- The Binomial Distribution pt. 2

- The Poisson Distribution

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

- 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?
Microsoft Project 2007 | Word 2007 | Microsoft Excel 2007 | Microsoft Access 2007 | Microsoft Project 2003 | QuickBooks 2008 | Crystal Reports | MCAS | Microsoft Excel Automation
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.
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.



