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.
Instructors & Overview of Course
Values & Variables - Important Terms
Number / Date / Custom Error Messages
The Binomial Distribution pt. 1
The Binomial Distribution pt. 2
Patterns / Dates / Uniform Distribution
Binary / Bernoulli / Normal Distribution
Poisson & Custom Distributions
Probability Terms & Definitions pt. 1
Probability Terms & Definitions pt. 2
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 an Existing Database pt. 1
Sampling an Existing Database pt. 2
Adding Data to an Existing Database
Improving the Histogram with Custom Bins
Creating Descriptive Statistics
A Histogram of 2006 Restaurant Bills
When to Use the Normal Distribution
Computing Probabilities with Normdist()
Norminv() / Normal vs. Poisson
Relationships in Anscombe's Data
Pivot Tables with Multiple Variables
Pivot Tables & Pivot Charts pt. 1
Pivot Tables & Pivot Charts pt. 2
Chi-Squared: How Chi-Squared Works
Chi-Squared: Computing Expected Values
Chi-Squared: Summarizing the Data
Finishing Our 2nd Chi-Squared Test
Your First Correlation In Date & Bill
Reformatting Our Scatter Chart
Formatting Axes & Finishing Touches
Multiple Variables: The Plot Area
Multiple Variables: Lines & Ordering
Multiple Variables: Axes & Titles
R-Squared & the Regression Equation
Regression: R-Squared & Significance
Identifying Data Sets for Regression
Regression by Average Bill pt. 1
Regression by Average Bill pt. 2
t-Test: Consulting Our Pivot Table
t-Test: Interpreting the Results
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
Every course on the vtc.com website contains free movies that let you assess the quality of our tutorials before you subscribe - just click on the blue links to watch them. Become a member today to access over 100,000 instructional videos!
Sign Up NowIf you are already an active vtc.com member, please log in to access the tutorials.