Lynda - Data Analysis Fundamentals with Excel (Size: 267.62 MB)
| | | 006 Analyzing data using variance and standard deviation.mp4 | 14.05 MB |
| | | 001 Welcome.mp4 | 5.07 MB |
| | | 002 What you should know.mp4 | 2.31 MB |
| | | 003 Using the exercise files.mp4 | 1.64 MB |
| | | 004 Calculating mean and median values.mp4 | 11.61 MB |
| | | 005 Measuring maximums, minimums, and other data characteristics.mp4 | 9.36 MB |
| | | 007 Introducing the central limit theorem.mp4 | 2.12 MB |
| | | 008 Analyzing a population using data samples.mp4 | 9.01 MB |
| | | 009 Identifying and minimizing sources of error.mp4 | 3.67 MB |
| | | 010 Grouping data using histograms.mp4 | 9.25 MB |
| | | 011 Identifying relationships using XY scatter charts.mp4 | 3.94 MB |
| | | 012 Visualizing data using logarithmic scales.mp4 | 8.08 MB |
| | | 013 Adding trendlines to charts.mp4 | 5.94 MB |
| | | 014 Forecasting future results.mp4 | 10.82 MB |
| | | 015 Calculating running averages.mp4 | 9.98 MB |
| | | 016 Formulating a hypothesis.mp4 | 6.37 MB |
| | | 017 Interpreting the results of your analysis.mp4 | 3.02 MB |
| | | 018 Considering the limits of hypothesis testing.mp4 | 3.88 MB |
| | | 019 Using the normal distribution.mp4 | 12.83 MB |
| | | 020 Using the exponential distribution.mp4 | 12.23 MB |
| | | 021 Using a uniform distribution.mp4 | 11.86 MB |
| | | 022 Using the binomial distribution.mp4 | 10.01 MB |
| | | 023 Using the Poisson distribution.mp4 | 9.29 MB |
| | | 024 Visualizing what covariance means.mp4 | 6.49 MB |
| | | 025 Calculating covariance between two columns of data.mp4 | 9.23 MB |
| | | 026 Calculating covariance among multiple pairs of columns.mp4 | 7.98 MB |
| | | 027 Visualizing what correlation means.mp4 | 10.24 MB |
| | | 028 Calculating correlation between two columns of data.mp4 | 4.49 MB |
| | | 029 Calculating correlation among multiple pairs of columns.mp4 | 9.17 MB |
| | | 030 Introducing Bayesian analysis.mp4 | 4.32 MB |
Description
Data-Analysis Fundamentals with Excel with Curt Frye
Released: Mar 03, 2015
Difficulty: Beginner
Duration : 2h 24m
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.
This course qualifies for 2.25 Category A professional development units (PDUs) through lynda.com, PMI Registered Education Provider #4101.
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
Sharing Widget