| Microsoft Excel 2003 for Statistics Tutorials Online |
 |
|
Description Microsoft Excel 2003 for Statistics
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. |
| Sample - Preview the First 3 chapters of Microsoft Excel 2003 for Statistics video free. Free learning Microsoft Excel 2003 for Statistics online. |
01 Introduction
0101 Instructors & Overview of Course
0102 Values & Variables - Important Terms
02 Data Validation
0201 Preparing to Enter Data
0202 Number / Date / Custom Error Messages
0203 Validating List Data
0204 Using Custom Warnings
03 Statistical Distributions
0301 Terms & Concepts
0302 The Normal Distribution
0303 The Binomial Distribution pt. 1
0304 The Binomial Distribution pt. 2
0305 The Poisson Distribution
04 Generating Random Data
0401 Patterns / Dates / Uniform Distribution
0402 Binary / Bernoulli / Normal Distribution
0403 Poisson & Custom Distributions
05 Probability
0501 Probability Terms & Definitions pt. 1
0502 Probability Terms & Definitions pt. 2
0503 The Laws of Probability
0504 Computing Independent Probabilities pt. 1
0505 Computing Independent Probabilities pt. 2
0506 Computing Dependent Probabilities
0507 Selecting a Random Sample: Set Up
0508 Selecting a Random Sample: Execution
0509 Sampling from a List pt. 1
0510 Sampling from a List pt. 2
0511 Sampling an Existing Database pt. 1
0512 Sampling an Existing Database pt. 2
0513 Adding Data to an Existing Database
06 Descriptive Statistics
0601 The Default Histogram
0602 Improving the Histogram with Custom Bins
0603 Creating Descriptive Statistics
0604 Using Inline Functions
0605 A Histogram of 2006 Restaurant Bills
0606 Unconfounding The Data pt. 1
0607 Unconfounding The Data pt. 2
0608 The Pareto Chart pt. 1
0609 The Pareto Chart pt. 2
07 Computing Probabilities w/ Distributions
0701 Using the Binomial pt. 1
0702 Using the Binomial pt. 2
0703 Using Compliments
0704 Using the Poisson
0705 Building a Histogram
0706 When to Use the Normal Distribution
0707 Computing Probabilities with Normdist()
0708 Norminv() / Normal vs. Poisson
08 Relationships
0801 Relationships in Anscombe's Data
0802 The Types of Graphs in Excel
0803 Pivot Tables & Pivot Charts
0804 Scatter Diagrams
0805 Pivot Tables with Multiple Variables
0806 Pivot Tables & Pivot Charts pt. 1
0807 Pivot Tables & Pivot Charts pt. 2
0808 Chi-Squared: Getting Ready
0809 Chi-Squared: How Chi-Squared Works
0810 Chi-Squared: Expected Values
0811 Chi-Squared: Computing Expected Values
0812 Chi-Squared: Summarizing the Data
0813 A 2nd Chi-Squared Test pt. 1
0814 A 2nd Chi-Squared Test pt. 2
0815 Finishing Our 2nd Chi-Squared Test
0816 Intro to Correlation
0817 Your First Correlation In Date & Bill
0818 Computing More Correlations
09 Graphical analysis
0901 Improving Our Histogram
0902 Reformatting Our Scatter Chart
0903 Formatting Axes & Finishing Touches
0904 Other Chart Options
0905 Graphing Multiple Variables
0906 Multiple Variables: The Plot Area
0907 Multiple Variables: Lines & Ordering
0908 Multiple Variables: Axes & Titles
10 Inferential Statistics - Regression
1001 The Trend Line
1002 R-Squared & the Regression Equation
1003 Regression: R-Squared & Significance
1004 Coefficients & Residuals
1005 Residual & Line Fit Plots
1006 Making Predictions
1007 Identifying Data Sets for Regression
1008 The Pivot Table pt. 1
1009 The Pivot Table pt. 2
1010 Regression by Total Bill
1011 Regression by Average Bill pt. 1
1012 Regression by Average Bill pt. 2
1013 Regression by Type
1014 Banquet Estimates
1015 Estimating Our Error
1016 Buffet Estimates
11 Inferential Statistics in ANOVA
1101 t-Test: Setting Up the t-Test
1102 t-Test: Consulting Our Pivot Table
1103 t-Test: Running the t-Test
1104 t-Test: Interpreting the Results
1105 ANOVA: Introduction
1106 ANOVA: Preparing the Data
1107 ANOVA: Running ANOVA & Checking Variances
1108 ANOVA: Interpreting the Results
1109 ANOVA: Understanding the Statistics
1110 Graphing the Confidence Intervals
1111 Computing the Confidence Intervals
12 Wrap-up & Review
1201 Data Classes / Validation / Distributions
1202 Generating Data & Probability Concepts
1203 Histograms & Descriptive Statistics
1204 Pivot Tables / Chi-Squared / Correlation
1205 Improving Graphs & Linear Regression
1206 t-Test & ANOVA
13 Credits
1301 About the Authors
sku |
|
