Introducing One Variable Statistics with Excel 2016
4.3 (4 ratings)
8 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Introducing One Variable Statistics with Excel 2016 to your Wishlist.

# Introducing One Variable Statistics with Excel 2016

Learn statistics without math!
4.3 (4 ratings)
8 students enrolled
Last updated 5/2017
English
Current price: \$10 Original price: \$20 Discount: 50% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
• 3 hours on-demand video
• 1 Article
• Access on mobile and TV
• Certificate of Completion
What Will I Learn?
• Describe the difference between rows and columns
• Generate patterns for week days
• Generate whole random numbers
• Generate random numbers with decimals
• Understand the difference between automatic calculations and manual calculations
• Sum the values in a column using quick analysis
• Average the values in a column using the average function
• Understand the difference between fixed cell references and changing cell references
• Explain in detail how to create running totals and how to use them in calculations
• Use cell and formula highlighting to explain how cells are used in calculations
• Explain how to format cells using currency symbols
• Understand how to find and interpret the mean, median and mode
• Explain the difference between the mean and median
• Explain how to find and interpret the mean absolute deviation
• Explain how to find and interpret the standard deviation
• Understand how the outliers can impact measures of variability
• Learn how to calculate absolute error
• Learn how to calculate and interpret percent error
• Learn how to use the sumproduct function
• Learn how to find the total cost of grouped items
• Learn how to calculate weighted averages
• Learn how to build graphs of data
• Learn how to do box plots
• Create and interpret frequency graphs
• Create and interpret relative frequency graphs
• Create and interpret cumulative frequency graphs
• Create and interpret cumulative relative frequency plots
• Understand nominal, ordinal, ratio and interval level of measurement
• Understand the difference between discrete and continuous variables
• Understand nominal variables
• Understand ordinal variables
• Understand interval variables
• Understand ratio variables
• Describe the meaning of the coefficient of variation
• Describe the meaning of the standard error of the mean
View Curriculum
Requirements
• This course is designed to work with Microsoft Excel 2016
Description

Statistics is a powerful tool we can use to help us understand the world. This course is for those who are interested in learning about simple, one variable statistics using Microsoft Excel 2016. Each lesson is an HD video with questions for you to answer as you watch the videos. This course assumes you already have Excel 2016 installed on your computer. This course is designed for beginners in statistics, and the examples are relatively simple, involving only a few values. The emphasis is on using Excel to grow your understanding.  You don't need separate data files to complete this course or math skills. Let's get learning!

Who is the target audience?
• People who want to deepen their understanding of statistics and Excel
Compare to Other Excel Courses
Curriculum For This Course
30 Lectures
03:05:27
+
Course Overview
1 Lecture 01:20

Objective: Understand what is covered in this course

Preview 01:20
+
Analyzing One Quantity
28 Lectures 03:04:01

Objective: Learn how to generate random numbers in Excel

Preview 07:57

Objective: Learn how to sum the values in a column and how to use the average function

Sum and average values in a single column
08:46

Objective: Understand the concept of a relative and fixed cell reference

Preview 05:47

Objective: Understand how to make use of running totals

Create and use cumulative totals
07:10

Objective: Understand how to find percents for individual values

Create and use individual percents
06:33

Objective:Learn how to find cumulative percents

Create and use cumulative percents
03:07

Objective: Understand how to find the mode and median

Find and interpret the median and mode
07:45

Objective: Understand the difference between the median and average

Compare the mean and median
04:07

Objective: Understand how to find and interpret the mean absolute deviation

Find and interpret the average absolute deviation
06:07

Objective: Understand how to find and interpret the standard deviation

Find and interpret the standard deviation
07:18

Objective: Understand how to calculate and interpret percent errors

Calculate percent error
08:57

Calculate the total money spent when making purchases
05:29

Objective: Understand how to calculate a weighted average

Calculate a weighted average
07:34

Objective: Build basic plots in excel

Construct graphs of data
09:05

Objective: Understand how to create and interpret box plots

Create and interpret box plots
09:19

Objective: Construct and interpret a frequency graph

Discrete frequency graphs
07:33

Objective: Learn how to construct and interpret a cumulative frequency graph

Create and interpret cumulative frequency graphs
07:51

Objective: Understand how to construct and interpret a relative frequency graph

Discrete relative frequency graphs
07:08

Objective: Understand how to construct and interpret a cumulative relative frequency chart

Create and interpret cumulative relative frequency graphs
07:02

Objective: Create and interpret histograms

Create and interpret histograms
09:42

Objective: Learn how to make a frequency list from a list of values

Create a frequency table and chart from a list of observations
04:05

Objective: Understand the difference between continuous and discrete variables

Understand continuous and discrete variables
07:45

Objective:Understand nominal levels of measurements

Nominal levels of measurements
04:12

Objective: Understand ordinal levels of measurements

Ordinal levels of measurement
04:06

Objective: Understand interval levels of measurement

Interval levels of measurement
04:20

Objective: Understand ratio levels of measurement

Ratio levels of measurement
02:35

Objective: Understand how the coefficient of variation allows us to make comparisons between two data sets

Coefficient of variation
05:32

Objective: Understand how to find and interpret the standard error of the mean

Standard error of the mean
07:09
+
Wrap Up
1 Lecture 00:06
Summary
00:06
 4.4 Average rating 1,657 Reviews 17,733 Students 19 Courses
Web, Math, Stats., and Physics Expert
• I have nine years experience as a teacher of mathematics, physics, statistics, and programming. I worked for five years as a database programmer using various technologies such as .NET, Clipper, SQL, SQL Server, SAS, Excel, and others. I'm the publisher of one of the most successful programming courses on udemy, called "Learn C# With Visual Studio 2013". Currently, I work as a mathematics and computer science teacher at a college in NY.
• Related Education:
• Master of Science in Applied Statistical Computing, Kennesaw State University
• Bachelor of Arts, Pure Mathematics, Queens College
• Associates of Science in Computer Programming
• Creator of more than 1620 math, physics, statistics and programming videos
• Programmer of more than 500 educational simulations

 4.1 Average rating 54 Reviews 345 Students 4 Courses

My principal interests lie in the automation of scientific instrumentation and analysis of collected data, along with the integration of disparate systems.  Recently developed some expertise in customising a major CRM deployment and developed a bunch of custom database queries to derive critical management information and user dashboards.
Qualified in Computer Studies, Electronic Engineering and Chemistry, I work in the support of significant scientific computer applications.  I have lectured in Computer Studies at a community college in the United Kingdom.