#FREE Statistics with Excel Part One #IT #Joseph Schmuller

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 and inferential 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.

LEVEL –  Appropriate for all

COURSE TOPICS:

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

READ MORE

LEARN THIS COURSE FOR FREE *10 days of free unlimited access to “Statistics with Excel Part One”

Instructor’s Welcome Note:

– Hi, I’m Joseph Schmuller. Welcome to Statistics with Excel Part One. In this course, we’ll look at the building block concepts of statistics and use Excel as a tool to explore them. For example, one important fundamental concept is called the sampling distribution. Understanding sampling distributions will take you a long way toward understanding statistics. Excel will be for us, a teaching tool. Early on, you’ll learn how to use Excel’s built in statistical functions.
You’ll also learn some useful Excel graphing capabilities that will start you on the road to creating data visualizations. And you’ll learn how to install Excel’s Analysis Tool Pack, an extensive and free set of statistical analysis tools. We’ll use the tool pack for analysis of variance, repeated measures analysis of variance, multiple regression analysis and more. Now before we get to those advanced concepts, you’ll get a firm grounding in the elements of descriptive statistics, and in the elements of inferential statistics.
For this course, all you really need to know is basic algebra. Now let’s get started with Statistics with Excel Part One.

 

 

Get 10 days of FREE unlimited access to Lynda.com.

Statistics with Excel Part One
Big Data Tutorials
tutorials
Lynda review

from Course reviews, freebies, coupons http://www.coursetag.com/free-statistics-with-excel-part-one-it-joseph-schmuller/