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.
LEVEL – Beginner
COURSE TOPICS:
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
READ MORE
LEARN THIS COURSE FOR FREE *10 days of free unlimited access to “Data-Analysis Fundamentals with Excel”
Instructor’s Welcome Note:
– Hi, I’m Curt Frye. Welcome to Data-Analysis Fundamentals with Excel. I’ll start with an overview of data-analysis, describing how to calculate common measures, introducing the central limit theorem, and offering advice for minimizing error. Next I’ll show you how to visualize your data using histograms, identify relationships among data by creating XY scatter charts, and forecast future results based on existing data. Then I’ll show you how to formulate null and alternative hypotheses, interpret the results of your analysis, and use the normal, binomial, and poisson distributions to model your data.
Finally I’ll show you how to analyze relationships between data sets using covariance, identify the strength of those relationships through correlation, and introduce Bayesian analysis. I’m sure you’ll find that your time studying data-analysis fundamentals with Excel will be time well spent. Dive right in.
Get 10 days of FREE unlimited access to Lynda.com.
Data-Analysis Fundamentals with Excel
Business Intelligence T
Curt Frye tutorials
Lynda review
from Course reviews, freebies, coupons http://www.coursetag.com/free-data-analysis-fundamentals-with-excel-it-excel/
No comments:
Post a Comment