Self Study, Tutorial Video on CD - DVD. Tutor Mark Clarkson guides you using step-by-step examples. Learn directly from your own desk high quality training videos at an affordable price. It works on both PC and Mac, this course is ideal for Beginners and Advanced users
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.. Watch our free Excel for Statistics Tutorial Videos by clicking the blue lesson links below.
Excel for Statistics Tutorial CD / DVD
Create the best self-paced learning environmentright on your own desktop.
Professionally created, comprehensive video based training that's easy to follow. At an unbelievable price.
Learn 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.
Problems Playing the Demos?
Benefits
- Professional Tuition from an Expert
- Free Certificate with Each Tutorial
- Works on PC or Mac
Just Released This Week
Logic Pro 9 Tutorial Video »
Topics Covered on this Training Video Include:
Introduction Data Validation
Introduction Data Validation
- Preparing to Enter Data
- Number / Date / Custom Error Messages
- Validating List Data
- Using Custom Warnings
- Terms & Concepts
- The Normal Distribution
- The Binomial Distribution Lesson 1
- The Binomial Distribution Lesson 2
- The Poisson Distribution
We hope you enjoyed the free videos above. To watch all this course including the
chapters below please purchase the CD.
Generating Random Data
$149.95
- Patterns / Dates / Uniform Distribution
- Binary / Bernoulli / Normal Distribution
- Poisson & Custom Distributions
- 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
- 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
- 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 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
- 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
- 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
- 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
- Data Classes / Validation / Distributions
- Generating Data & Probability Concepts
- Histograms & Descriptive Statistics
- Pivot Tables / Chi-Squared / Correlation
- Improving Graphs & Linear Regression
- t-Test & ANOVA
- 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 |
| Delivery time: | Only 3 working days |
| Compatibility: | Vista, 2000, XP, Windows 7, Mac OS, OSX |
| Released | 2007 |
| Work files | Yes |
| Price Australia / New Zealand & Asia | AUD $149.95 (+ $10.00 Shipping ) |
107 In Stock
Purchase Orders from Schools, Colleges, Government and Military Accepted
Multi User Network Version Available
This training is also available in Multi User format for Schools and Corporate users.
10 Multi User $695
10 Multi User $695 Why use this method of video training?
- Learn Excel for Statistics from an accredited expert in days.
- Ideal for beginners, these easy to follow videos offer visual clarity.
- Master a full application from basics to advanced 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.
- It's cost effective tuition from leading expert tutors.
- Learn at your own pace; training can be stopped, rewound or fast forwarded as required.
- These High Quality Tutorial Videos are on CD / DVD or Online and PC / Mac Compatible. It's Simply the best tuition at an affordable price
Want to hear what our customers say about our products?
Associated Tutorials:
Microsoft Project Tutorial | Microsoft Excel 2007 | Microsoft Access 2007 | Microsoft Project 2003 | QuickBooks 2008 | Crystal Reports | MCAS | Microsoft Excel Automation | Beginners MS Word 2010
Excel for Statistics Related Training Videos:
Free Certificate. Prove Your Credentials
We now offer all customers a free certificate to verify they have undertaken a training course, the unique certification number allows third parties to check the authenticity of your certificate online. After your purchase you can download your free certificate without delay.
Instant Online Access all the Training Videos for only $30.00
Unlimited Accesss to 60,000 Training Video only $30.
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.
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, and no commitment on your part.
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 learn as much as you like.
When you're finished, cancelling is easy. Just click the cancel button - that's it, no questions - you're in total control.
