Microsoft Excel 2003 for Statistics |
 |
| Author: | |
| Language:english | |
| Category:Other | |
| Lessons:0 | 0 hrs | |
| Buy Now or get more information about Microsoft Excel 2003 for Statistics | |
First 3 Lessons Free Online (Press the links below to open up the free lessons. The lessons will open in a popup window from this screen and play in Quicktime):
Microsoft Excel 2003 for Statistics
Introduction
Instructors & Overview of CourseValues & Variables - Important Terms
Data Validation
Preparing to Enter DataNumber / Date / Custom Error Messages
Validating List Data
Using Custom Warnings
Statistical Distributions
Terms & ConceptsThe Normal Distribution
The Binomial Distribution pt. 1
The Binomial Distribution pt. 2
The Poisson Distribution
Generating Random Data
Patterns / Dates / Uniform DistributionBinary / Bernoulli / Normal Distribution
Poisson & Custom Distributions
Probability
Probability Terms & Definitions pt. 1Probability 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 HistogramImproving 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. 1Using 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 DataThe 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 HistogramReformatting 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 LineR-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-Testt-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 / DistributionsGenerating Data & Probability Concepts
Histograms & Descriptive Statistics
Pivot Tables / Chi-Squared / Correlation
Improving Graphs & Linear Regression
t-Test & ANOVA
