Introduction to Statistics

Overview

Learn how to apply core statistical concepts to data: describe it, make inferences, and draw conclusions that can have great organizational impact from expert instructors through hands-on exercises. Develop the skills to graphically display data, apply statistical tests to determine validity, reliability, and significance, and identify relationships between variables. You will also learn how to conduct statistical analyses in Excel to help you analyze data more quickly and effectively for your organization.

Who Attends

This course is designed for professionals who seek formal training or a refresher course in statistical analysis using Microsoft Excel. This course covers statistical concepts that are also addressed in Analytics Boot Camp and Data Analysis and Modeling Techniques.

Course Level: Intermediate
CLP: 32 | CPE: 32
Duration: 4 Days

Course Details

FAQs Technology Requirements

For Groups

Volume Discounts (5+ Seats) Private Group Training Icon

Private Group Training

Learning Objectives

Apply the Analytics Process Model to plan and conduct statistical analyses
Describe data using measures of central tendency and variation
Construct a frequency distribution to analyze data
Calculate the likelihood that an event will occur using probability distribution functions
Use sampling to make inferences about a population
Use t-tests to test hypotheses and determine statistical significance
Calculate correlation between variables and make predictions using linear regression

Additional Features

Learn More

Course Activities

Course Topics

Introduction to Analytical Research and Statistics

Why Analyze Data?
Using the Analytics Process Model to Plan and Conduct a Research Study
The Analytics Process Model
Applying Statistics for Data Analysis
Branches of Statistics
Basic Statistical Principles

Measures of Central Tendency

Measures of Central Tendency: The Average
Grouped Data
Exercise: Central Tendency
Visualizing Data: Box Plots
Misleading Statistics
Exercise: Calculating Mean, Median, and Mode

The Frequency Distribution

What is a Frequency Distribution?
Constructing a Simple Frequency Distribution
Dot Plots
Stem and Leaf Plots
Constructing More Complicated Frequency Distributions
Exercise: Frequency Distribution
Probability Distribution
Cumulative Frequency Plots
Identifying Typical Shapes of Frequency Distributions
Creating Histograms with Excel
Creating Pivot Tables and Grouping Data

Measures of Variation

The Concept of Variation
Total Quality Management and Variation
Ways To Measure Variation
Exercise: Interpreting Variation
Exercise: Calculating Variation in Excel
Location of the Mean, Median, and Mode

Basic Probability

Probability in Practice
Counting Outcomes

Binomial Distribution

The Binomial Distribution Formula
Exercise: Binomial Distribution
Binomial Probability Distribution

Normal Distribution

Characteristics of a Normal Distribution
Introduction to the z Statistic
The NORM.DIST Function

Sampling and Inferential Statistics

Population vs. Sample
Why Sample?
Demonstration of Sampling Theory and the Central Limit Theorem
Applications: The 95% Confidence Interval
Exercise: Inferential Statistics

Hypothesis Testing: T-Test

Meaning of Statistically Significant
Hypothesis Testing
The T-Statistic
When to Use the T-Test
T-Test for Difference of Means
T-Test for Dependent Samples (Before-and-After Study)
Exercise: T-Test
Performing a Paired Sample T-Test with the Analysis ToolPak
Exercise: T-Test Paired Sample—Yearly Tornadoes
Performing an Independent Sample T-Test with the Analysis ToolPak
Exercise: T-Test Two Sample—Tornadoes Before or After Lunch
Single Sample T-Test

Correlation and Regression

Simple Linear Regression
Simple Linear Regression Equation
Excel Regression Tool
Regression Statistics
Correlation
Multiple Linear Regression

Related Courses and Products

COURSE

Introduction to Analytics

Evaluate and solve problems using key analytics skills, including a structured six-step Analytics Process Model, which you will apply through guided collaborative scenarios with top-tier facilitators....

COURSE

Data Analysis and Modeling Techniques

Analyze data to help solve your organization’s most complex challenges and requirements. Learn the core techniques used to analyze and model complex data into understandable information. Gather the sk...

COURSE

Data Collection Techniques

Analyze and collect clean data, particularly in the context of your organization’s data management. Learn best practices to combat common obstacles in data collection. Gain strategies for identifying...

COURSE

Data Storytelling for the Federal Government: Numbers to Narratives

Transform your data into a compelling story that drives action. In today’s data-driven landscape, the federal government needs both skilled analysts and effective storytellers that can elevate policy...

Loading Course Details

Introduction to Statistics

Overview

Who Attends

For Groups

Learning Objectives

Additional Features

Credits

This course is part of the following Management Concepts Certificate Programs:

Core Courses

Elective Courses

Prerequisites:

Mandatory

Suggested

Course Activities

Course Topics