The Zen of Data - Part I: Stats for Analytics

149 USD
  Curs on-line
Predare in limba: Engleza
Cumpara

You have data. You need insights. The bridge between "data" and actionable "insight" is often statistics.

But to a lot of us, stats are scary, foreboding monsters that remind us of a miserable 8am class sophomore year in college.

It's too bad, really, because learning stats in a vacuum - in a classroom without context - is like watching a sunset on TV. Nice, maybe, but not nearly as memorable or powerful as the real thing.

The real thing is in your data. It's hidden behind a set of deceptively simple concepts, tools and techniques.

So bring that data and let's explore The Zen of Data.

The Zen of Data is "stats for the dataphobic," also known as "stress free stats."

We operate on a few simple principles:

- You have data. And you have a spreadsheet. There's no need to grind out numbers.

- However, it's very important to understand the mathematical principles behind the way your data behaves. Or misbehaves, as the case may be.

- A gentle introduction to concepts + some practical tutorials in data operations (data functions in spreadsheets mainly, at this level) will take you a long way toward overcoming dataphobia.

That's what The Zen of Data is all about. You'll start with a gentle introduction to stats and data, then move right to practical, applied concepts around:

-Averages
-Variance
-Distribution
-Standard Deviation
-Correlation
-Covariance
-ANOVA
-Regression
-Data Location
-Data Modeling
-Data Visualization

Trainer

Todd Wieland

Structura cursului


SECTION 1: Intro to The Zen of Data
Lecture 1: Zen Of Data Part I - Intro (11:54)
Lecture 2: Intro to Stats and Data (13:35)
Text
Lecture 3:
About Your Course Resources

SECTION 2: Averages
Lecture 4: Averages (14:07)
Lecture 5: Mary D on Averages (02:42)

SECTION 3: Resources - Averages
Lecture 6: Mean, Median, Mode and More in Excel (11:14)
Lecture 7: A Musical Interlude: Mean Median and Mode Song (01:33)

SECTION 4: Variance
Lecture 8: Variance (09:58)
Lecture 9: Mary D on Variability (02:14)

SECTION 5: Resources - Variance
Lecture 10: Variability Measures Excel - Ways to Determine Dispersion or Spread (07:25)

SECTION 6: Distribution
Lecture 11: Distribution - Part 1 (09:10)
Lecture 12: Distribution Part 2 (09:45)

SECTION 7: Resources - Distribution
Lecture 13: Grouped Data Distribution in Excel (07:29)
Lecture 14: The Nature of "Normal" in Data Distributions (09:20)

SECTION 8: Standard Deviation
Lecture 15: Standard Deviation (09:33)
Lecture 16: Standard Deviation, Mean and Variability: Tying It All Together (41:35)

SECTION 9: Resources - Standard Deviation
Lecture 17: Using Excel to Find Standard Deviation (02:15)

SECTION 10: Correlation
Lecture 18: Correlation (14:21)
Lecture 19: Mary D on Correlation (02:14)

SECTION 11: Resources - Correlation
Lecture 20: Correlation Tutorial in Excel 2007 (04:19)

SECTION 12: Covariance
Lecture 21: Covariance (05:40)
Lecture 22: Mary D on Covariance (02:02)

SECTION 13: Resources - Covariance
Lecture 23: Correlation and Covariance (09:53)

SECTION 14: ANOVA
Lecture 24: ANOVA Part 1 (07:57)
Lecture 25: ANOVA Part 2 (09:09)
Lecture 26: Mary D on ANOVA (02:10)

SECTION 15: Resources - ANOVA
Lecture 27: Calculate ANOVA with Excel (04:44)
Lecture 28: Single Factor ANOVA in Excel (07:11)
Lecture 29: Two Factor ANOVA in Excel (06:06)

SECTION 16: Regression Analysis
Lecture 30: Regression Analysis (07:39)
Lecture 31: Regression Analysis - Part 2 (09:27)
Lecture 32: Mary D on Regression (01:42)

SECTION 17: Resources - Regression Analysis
Lecture 33: Creating Linear Regression (05:14)
Lecture 34: Linear Regression for Cost Accounting (22:24)
Lecture 35: Interpreting Multiple Regression Analysis (06:32)

SECTION 18: Data Location
Lecture 36: Data Location (06:13)

SECTION 19: Resources - Data Location
Lecture 37: Percentile Rank Function in Excel (08:06)

SECTION 20: Modeling
Lecture 38: Working With Models (10:20)

SECTION 21: Resources - Modeling
Lecture 39: Modeling Using Regression (07:30)

SECTION 22: Data Visualization
Lecture 40: Data Visualization (11:22)

SECTION 23: Resources - Data Visualization
Lecture 41: Simple Bar Graph in Excel (02:45)
Lecture 42: How to Create Data Visualizations in Excel 2007 (04:25)
Lecture 43: Interactive Area Charts in Excel without Programming (06:30)
Video
Cumpara