Lynda - Data-Analysis Fundamentals with Excel with Curt Frye [StarDiwa]

seeders: 22
leechers: 8
Added on March 4, 2015 by StarDiwain Other > Tutorials
Torrent verified.



Lynda - Data-Analysis Fundamentals with Excel with Curt Frye [StarDiwa] (Size: 180.14 MB)
 Exercise Files.zip165.04 KB
 about.txt1.45 KB
 01 Welcome.mp45.36 MB
 02 What you should know.mp41.47 MB
 03 Using the exercise files.mp4958.82 KB
 03 Analyzing Data Using Variance And Standard Deviation.mp49.37 MB
 01 Calculating Mean And Median Values.mp47.68 MB
 02 Measuring Maximums, Minimums, And Other Data Characteristics.mp46.34 MB
 05 Analyzing A Population Using Data Samples.mp45.79 MB
 06 Identifying And Minimizing Sources Of Error.mp42.33 MB
 04 Introducing The Central Limit Theorem.mp41.55 MB
 05 Forecasting Future Results.mp47.4 MB
 06 Calculating Running Averages.mp46.63 MB
 01 Grouping Data Using Histograms.mp46.31 MB
 03 Visualizing Data Using Logarithmic Scales.mp45.31 MB
 04 Adding Trendlines To Charts.mp43.96 MB
 02 Identifying Relationships Using XY Scatter Charts.mp42.7 MB
 01 Formulating A Hypothesis.mp44.06 MB
 03 Considering The Limits Of Hypothesis Testing.mp42.45 MB
 02 Interpreting The Results Of Your Analysis.mp41.97 MB
 01 Using The Normal Distribution.mp48.53 MB
 02 Using The Exponential Distribution.mp48.38 MB
 03 Using A Uniform Distribution.mp47.9 MB
 04 Using The Binomial Distribution.mp46.68 MB
 05 Using The Poisson Distribution.mp46.17 MB
 04 Visualizing What Correlation Means.mp46.72 MB
 02 Calculating Covariance Between Two Columns Of Data.mp46.14 MB
 06 Calculating Correlation Among Multiple Pairs Of Columns.mp46.13 MB
 03 Calculating Covariance Among Multiple Pairs Of Columns.mp45.4 MB
 01 Visualizing What Covariance Means.mp44.25 MB
 05 Calculating Correlation Between Two Columns Of Data.mp43.09 MB
 04 Calculating Bayesian Probabilities In Excel.mp48.72 MB
 03 Creating A Classification Matrix.mp45.21 MB
 02 Analyzing A Sample Problem - Kahneman's Cabs.mp44.94 MB
 05 Updating Your Bayesian Analysis.mp44.81 MB
 01 Introducing Bayesian Analysis.mp42.88 MB
 01 Further Resources.mp42.42 MB


Description

Lynda - Data-Analysis Fundamentals with Excel with Curt Frye

image image

Author: Curt Frye


Description:

Microsoft Excel is an important tool for information workers that design and perform data analysis. This course provides an overview of the fundamentals, from performing common calculations to conducting Bayesian analysis with Excel. Author Curt Frye starts with the foundational concepts, including an introduction to the central limit theorem, and then shows how to visualize data, relationships, and future results with Excel's histograms, graphs, and charts. He also covers testing hypotheses, modeling different data distributions, and calculating the covariance and correlation between data sets. The course closes with a look at calculating Bayesian probabilities in Excel.

Topics include:

-Calculating mean and median values
-Analyzing data using variance and standard deviation
-Minimizing errors
-Visualizing data with histograms, charts, and more
-Testing hypotheses
-Measuring covariance and correlation
-Performing Bayesian analysis

Duration: 2h 24m

Level: Beginner

Date: Mar 03, 2015


Subject: IT

Software: Excel

image




Sharing Widget


Download torrent
180.14 MB
seeders:22
leechers:8
Lynda - Data-Analysis Fundamentals with Excel with Curt Frye [StarDiwa]