->

Statistics with Excel Part One

Duration: 3hr 19m | Video: h264, yuv420p, 1280x720 30fps | Audio: aac, 44100 Hz, 2 ch | 513 MB
Genre: eLearning | Language: English

 

Understanding statistics is more important than ever. Statistical operations are the basis for decision making in fields from business to academia. However, many statistics courses are taught in cookbook fashion, with an emphasis on a bewildering array of tests, techniques, and software applications. In this course, part one of a series, Joseph Schmuller teaches the fundamental concepts of descriptive statistics and shows you how to apply them using Microsoft Excel.


He explains how to organize and present data and how to draw conclusions from data using Excel's functions, calculations, and charts, as well as the free and powerful Excel Analysis ToolPak. The objective is for the learner to fully understand and apply statistical concepts—not to just blindly use a specific statistical test for a particular type of data set. Joseph uses Excel as a teaching tool to illustrate the concepts and increase understanding, but all you need is a basic understanding of algebra to follow along.

 

Topics include:
  • Understanding data types and variables
  • Calculating probability
  • Understanding mean, median, and mode
  • Calculating variability
  • Organizing and graphing distributions
  • Sampling distributions
  • Making estimations
  • Testing hypothesis: mean testing, z- and t-testing, and more
  • Analyzing variance
  • Performing repeated measure testing
  • Understanding correlation and regression

 

 

Statistics with Excel Part One
------------------------------------------------------------------------------------------
Statistics with Excel Part One
 


 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