->

Data-Analysis Fundamentals with Excel
Data-Analysis Fundamentals with Excel
Duration: 2hr 24m | Video: h264, yuv420p, 1280x720 30fps | Audio: aac, 44100 Hz, 2ch | 267 MB
Genre: eLearning | Language: English

 

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

 

Data-Analysis Fundamentals with Excel
------------------------------------------------------------------------------------------
Data-Analysis Fundamentals with Excel
 


 TO MAC USERS: If RAR password doesn't work, use this archive program: 

RAR Expander 0.8.5 Beta 4  and extract password protected files without error.


 TO WIN USERS: If RAR password doesn't work, use this archive program: 

Latest Winrar  and extract password protected files without error.


 Gamystyle   |  

Information
Members of Guests cannot leave comments.




rss