Microsoft Excel 2003 for Statistics Tutorials
Online Contents For This Course
We have made some of the video tutorials for
Microsoft Excel 2003 for Statistics
freely available to help you evaluate our training. Click on any of the linked lesson listings below to preview FREE!
Course Description
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.
Choose your media type:
|
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) | ||
Course Information
| Course: | Microsoft Excel 2003 for Statistics |
| Author: | Mark and Elizabeth Clarkson |
| SKU: | 33751 |
| ISBN: | 1-933736-73-9 |
| Release Date: | 2007-04-11 |
| Duration: | 8.5 hrs / 104 tutorials |
| Work Files: |
Yes |
| Captions: | No |
Subscription / Purchase Information
This course is just part of the entire VTC collection of over 782 courses, 81,350 video tutorials (20,800+ free), available to you for just $30 a month.
View All Courses Subscribe Learn More
United States
Email this Page
Send us Feedback