Excel 2003 for Statistics

Easy-to-undestand video tutorials

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.

Durée 8h5
Avec : Mark and Elizabeth Clarkson
Formation téléchargeable
FORMATION TÉLÉCHARGÉABLE
Formation téléchargeable
VISIONNAGE ILLIMITÉ
Formation téléchargeable
DISPONIBLE SUR USB

Nos clients ont également vu :

  • Generating Random Data

    • (06:36) Patterns / Dates / Uniform Distribution
    • (05:31) Binary / Bernoulli / Normal Distribution
    • (05:46) Poisson & Custom Distributions
  • Probability

    • (06:55) Probability Terms & Definitions pt. 1
    • (00:43) Probability Terms & Definitions pt. 2
    • (04:45) The Laws of Probability
    • (03:27) Computing Independent Probabilities pt. 1
    • (03:05) Computing Independent Probabilities pt. 2
    • (05:36) Computing Dependent Probabilities
    • (04:23) Selecting a Random Sample: Set Up
    • (04:12) Selecting a Random Sample: Execution
    • (04:02) Sampling from a List pt. 1
    • (06:19) Sampling from a List pt. 2
    • (03:23) Sampling an Existing Database pt. 1
    • (05:31) Sampling an Existing Database pt. 2
    • (03:26) Adding Data to an Existing Database
  • Descriptive Statistics

    • (03:58) The Default Histogram
    • (03:24) Improving the Histogram with Custom Bins
    • (06:35) Creating Descriptive Statistics
    • (03:53) Using Inline Functions
    • (03:27) A Histogram of 2006 Restaurant Bills
    • (06:18) Unconfounding The Data pt. 1
    • (02:20) Unconfounding The Data pt. 2
    • (04:31) The Pareto Chart pt. 1
    • (03:51) The Pareto Chart pt. 2
  • Computing Probabilities w/ Distributions

    • (03:27) Using the Binomial pt. 1
    • (04:27) Using the Binomial pt. 2
    • (03:37) Using Compliments
    • (04:01) Using the Poisson
    • (05:00) Building a Histogram
    • (03:47) When to Use the Normal Distribution
    • (03:57) Computing Probabilities with Normdist()
    • (04:51) Norminv() / Normal vs. Poisson
  • Relationships

    • (04:34) Relationships in Anscombe's Data
    • (03:26) The Types of Graphs in Excel
    • (07:16) Pivot Tables & Pivot Charts
    • (06:00) Scatter Diagrams
    • (06:58) Pivot Tables with Multiple Variables
    • (02:51) Pivot Tables & Pivot Charts pt. 1
    • (05:06) Pivot Tables & Pivot Charts pt. 2
    • (03:47) Chi-Squared: Getting Ready
    • (05:31) Chi-Squared: How Chi-Squared Works
    • (06:54) Chi-Squared: Expected Values
    • (05:06) Chi-Squared: Computing Expected Values
    • (07:32) Chi-Squared: Summarizing the Data
    • (04:52) A 2nd Chi-Squared Test pt. 1
    • (07:01) A 2nd Chi-Squared Test pt. 2
    • (07:27) Finishing Our 2nd Chi-Squared Test
    • (07:48) Intro to Correlation
    • (05:21) Your First Correlation In Date & Bill
    • (05:50) Computing More Correlations
  • Graphical analysis

    • (06:16) Improving Our Histogram
    • (05:45) Reformatting Our Scatter Chart
    • (07:31) Formatting Axes & Finishing Touches
    • (05:44) Other Chart Options
    • (03:39) Graphing Multiple Variables
    • (04:48) Multiple Variables: The Plot Area
    • (05:53) Multiple Variables: Lines & Ordering
    • (04:20) Multiple Variables: Axes & Titles
  • Inferential Statistics - Regression

    • (06:39) The Trend Line
    • (06:39) R-Squared & the Regression Equation
    • (04:28) Regression: R-Squared & Significance
    • (05:32) Coefficients & Residuals
    • (04:33) Residual & Line Fit Plots
    • (02:29) Making Predictions
    • (06:38) Identifying Data Sets for Regression
    • (04:01) The Pivot Table pt. 1
    • (02:49) The Pivot Table pt. 2
    • (03:25) Regression by Total Bill
    • (02:44) Regression by Average Bill pt. 1
    • (02:42) Regression by Average Bill pt. 2
    • (07:06) Regression by Type
    • (02:00) Banquet Estimates
    • (05:05) Estimating Our Error
    • (04:00) Buffet Estimates
  • Inferential Statistics in ANOVA

    • (05:08) t-Test: Setting Up the t-Test
    • (04:42) t-Test: Consulting Our Pivot Table
    • (06:08) t-Test: Running the t-Test
    • (03:56) t-Test: Interpreting the Results
    • (02:45) ANOVA: Introduction
    • (03:34) ANOVA: Preparing the Data
    • (04:11) ANOVA: Running ANOVA & Checking Variances
    • (02:57) ANOVA: Interpreting the Results
    • (06:11) ANOVA: Understanding the Statistics
    • (03:27) Graphing the Confidence Intervals
    • (05:54) Computing the Confidence Intervals
  • Wrap-up & Review

    • (04:16) Data Classes / Validation / Distributions
    • (03:38) Generating Data & Probability Concepts
    • (03:32) Histograms & Descriptive Statistics
    • (03:48) Pivot Tables / Chi-Squared / Correlation
    • (04:02) Improving Graphs & Linear Regression
    • (02:28) t-Test & ANOVA
  • Credits

    • (00:57) About the Authors
Formateur : Mark and Elizabeth Clarkson
Langue : Anglais
Durée : 8h5
Nombre de séquences vidéo : 104
SKU : 33751
Réf :
ISBN : 1-933736-73-9
Date de publication : 2007-04-11
Compatibilité : Apple Mac OS X (PPC & Intel) | Windows XP, Vista, 7, 8
Formations compatibles iPad en VOD et via l'application TutoShop sur l'AppStore.

Descriptif :




Mark and Elizabeth Clarkson

+ 10 000 TUTOS EN VIDÉO
FORMEZ-VOUS EN ILLIMITÉ
SUR
VOD.TUTOROM.FR

A partir de 19€/mois seulement
Abonnez-vous