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