▄▄▄ ▄▄▄
█████▄ ▄▄▄ ▄█████
▄▄▄▄ ▀█████ ▄▄█▓█████▄▄ █████ ▄▄▄ ▄▄▄▄
▄██████████▄████▓ █████████████ ████ ▄█████ ██████
███▓▀▀▀▀█████▓████ █████▀ ▀████▓ ▓███ ▄██▄ █████▓ ▓██████
░▓███▄ ▄████ ████ █████▓ ▓█████▓███ ████ ██████▄ ▄██████▓
████████████▀ ████ █████ █████████ ████▄██▄███████▄███▀████▓
▀███▄ ▄▄▄ ▄████▀ ▓████ █████████ ████████▓███ ▀██▓▀ ████
▀███▄████▄█████ ██████ ████▓█████▄▓████ ▀▀ ████ ▀ ████
▄████▄ ▀▀████████▓ ███████ ▓▓██▀███▀ ▀██████▄██▄ ███ ████
█████████ ▀█▓▀ █████▄▄ ░▓███████▄▄▄████▄██▓ ▀████████████ ████
██████████▄ ▄▄ ▀▀█████▄▄▓████▀███████▀▄███ ▄▄ ████████████ ▓▄▄▄▄ ████▓░
▓█████████████▓▓█▄▄ ▀▀▓▓█████▓░ ▀▀▀ ▄ ▀████▄ ▀██ ████████████ ████▀ ▄███▓
▀███▓▓▓█████████████▄▄▄ ▀▀███▀ ▄███████▄ ▀▀███▄ ▓ ███▓███▓████ ▓█▀ ▄███▀▀
▀▀▀ ▀▀▀▓▓███▄▄▄▄▄███████▀▀▀▀▓ ▀▀ ███▓ ▀▀ ████ ▀ ▀▓▓█▄▄
▀▀▀▀▀▀ ▀▀ ▀██▀ ▀▀▀▀▀
RELEASE NAME....: Lynda.com.Statistics.with.Excel.Part.One.UPDATED.COURSE-ELOHiM
RELEASE DATE....: 2016-06-02
RELEASE SIZE....: 38x15Mb
FORMAT..........: Bookware
LANGUAGE........: English
URL.............: http://www.lynda.com
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.
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
Subjects: Business Intelligence, Big Data, IT, Data Analysis, Excel
Author: Joseph Schmuller
Level: Appropriate for all
Duration: 3h 18m
Released: 12/23/2015
Updated: 6/2/2016