Windows 7 » Разное » Lynda - Statistics with Excel Part One.2016 TUTORiAL

Lynda - Statistics with Excel Part One.2016 TUTORiAL

Автор: mitsumi » 13 августа 2016
Lynda - Statistics with Excel Part One.2016 TUTORiAL

Lynda - Statistics with Excel Part One 2016 TUTORiAL | 576 MB

Understanding statistics is more important than ever. Statistical operations are the basis for decision making in fields from business to academia. However, many statistics courses are taught in cookbook fashion, with an emphasis on a bewildering array of tests, techniques, and software applications. In this course, part one of a series, Joseph Schmuller teaches the fundamental concepts of descriptive and inferential statistics and shows you how to apply them using Microsoft Excel.

He explains how to organize and present data and how to draw conclusions from data using Excel's functions, calculations, and charts, as well as the free and powerful Excel Analysis ToolPak. The objective is for the learner to fully understand and apply statistical concepts-not to just blindly use a specific statistical test for a particular type of data set. Joseph uses Excel as a teaching tool to illustrate the concepts and increase understanding, but all you need is a basic understanding of algebra to follow along.

Introduction
Welcome
Using exercise files
1. Excel Statistics Essentials
Excel functions
Excel statistical functions
Excel graphics
Excel Analysis ToolPak
2. Understanding Data
Types of data
Independent and dependent variables
3. Probability
Probability definitions
Calculating probability
Counting rules and probability
Conditional probability
Bayesian probability
4. Central Tendency
Mean and its properties
Median
Mode
5. Variability
Variance
Standard deviation
6. Distributions
What is a distribution?
Organize and graph a distribution
Graph frequency polygons
Properties of distributions
Probability distributions
7. Normal Distributions
The normal distribution family
The standard normal distribution
Standard normal distribution probability
Normal distribution graph
8. Sampling Distributions
Sampling distribution overview
Central limit theorem
Meet the t-distribution
9. Estimation
Confidence in estimation
Calculating confidence intervals
10. Hypothesis Testing
The logic of hypothesis testing
Type I errors and type II errors
11. Mean Hypothesis Testing
Applying the central limit theorem
The z-test and the t-test
12. Variance Hypothesis Testing
Chi-square distribution
13. z and t Hypothesis Testing
Understanding independent samples
Distributions for independent samples
The z-test for independent samples
The t-test for independent samples
14. Matched Sample Hypothesis Testing
Matched samples
Distributions for matched samples
The t-test for matched samples
15. F-Test Hypothesis Testing
F-test overview
16. Analysis of Variance
More than two parameters
ANOVA
Applying ANOVA
17. After the Analysis of Variance
Types of post-ANOVA testing
Post-ANOVA planned comparisons
18. Repeated Measures Testing
What is repeated measures?
Perform repeated measures ANOVA
19. Hypothesis Testing with Two Factors
Statistical interactions
Two-factor ANOVA
Perform two-factor ANOVA
20. Regression
Regression line overview
Variation around the regression line
Analysis of variance for regression
Multiple regression analysis
21. Correlation
Up next
Correlation coefficient
Correlation and regression
Hypothesis testing with correlation
Conclusion
Up next

Download link:



Links are Interchangeable - No Password - Single Extraction




Перед тем как скачать Lynda - Statistics with Excel Part One.2016 TUTORiAL бесплатно, без смс, регистрации, на халяву, через торрент, рекомендуем прочитать отзывыо Lynda - Statistics with Excel Part One.2016 TUTORiAL.

Другие новости по теме:
  • Building Information Modeling For Dummies
    [center] Stefan Mordue, Paul Swaddle, David Philp, "Building Information Modeling For Dummies" English | ISBN: 1119060052 | 2015 | EPUB | 408 pages | 3,1 MB
  • Lynda - R for Excel Users.2016 TUTORiAL
    Lynda - R for Excel Users 2016 TUTORiAL | 193 MBData scientists who use Excel realize that R is emerging as the new standard for statistical wrangling (especially for larger data sets). This course
  • Apple Keynote 6.5.2 Multilingual Mac OSX 160812
    Apple Keynote 6.5.2 Multilingual Mac OSX 160812 [center]Apple Keynote 6.5.2 Multilingual Mac OSX | 422 MBLanguages: English, Arabic, Catalan, Chinese, Croatian, Czech, Danish, Dutch, Finnish, French,
  • Linear Programming Problem
    Linear Programming Problem MP4 | Video: AVC 1280x720 | Audio: AAC 44KHz 2ch | Duration: 2 Hours | Lec: 8 | 320 MBGenre: eLearning | Language: English
  • Building Information Modeling BIM in Current and Future Practice
    [center]Building Information Modeling: BIM in Current and Future Practice by Karen Kensek, Douglas Noble2014 | ISBN: 111876630X | English | 432 pages | PDF | 77 MB