Course Orientation-About the Course
Welcome to Exploring and Producing Data for Business Decision Making!
()
Syllabus
ePub
About the Discussion Forums
Glossary
Online Education at Gies College of Business
Learn on Your Terms
()
Course Orientation-About Excel
Using Excel for this Course
Excel Data Analysis Toolpak
()
Course Orientation-About Your Classmates
Updating Your Profile
Module 1: Introduction and Summarizing Data-Module 1 Information
Module 1 Overview
Module 1 Readings
Module 1: Introduction and Summarizing Data-Lesson 1-1: Introduction to Business Statistics
1-1.1. Basic Terminology
()
Module 1: Introduction and Summarizing Data-Lesson 1-2: Descriptive Statistics: Frequency Tables
1-2.1. Summarizing Data: Frequency Tables
()
1-2.2. Frequency Tables in Excel: Quantitative Data
()
1-2.3. Frequency Tables in Excel: Qualitative Data
()
1-2.4. Presenting Frequency Tables as a Bar Graph in Excel
()
Module 1: Introduction and Summarizing Data-Lesson 1-3: Descriptive Statistics: Histograms
1-3.1. Summarizing Data: Histograms
()
1-3.2. Histograms in Excel
()
Module 1: Introduction and Summarizing Data-Lesson 1-4: Descriptive Statistics: Pie Charts
1-4.1. Summarizing Data: Pie Charts
()
1-4.2. Pie Charts in Excel
()
Module 1: Introduction and Summarizing Data-Lesson 1-5: Descriptive Statistics: Scatter Plots
1-5.1. Summarizing Data: Scatter Plots
()
1-5.2. Scatter Plots in Excel
()
Module 2: Descriptive Statistics and Probability Distributions-Module 2 Information
Module 2 Overview
Module 2 Readings
Module 2: Descriptive Statistics and Probability Distributions-Lesson 2-1: Measures of Central Tendencies
2-1.1. Measures of Central Tendencies
()
2-1.2. Mean and Median in Excel
()
Module 2: Descriptive Statistics and Probability Distributions-Lesson 2-2: Measures of Dispersion
2-2.1. Measures of Dispersion
()
2-2.2. Standard Deviation in Excel
()
Module 2: Descriptive Statistics and Probability Distributions-Lesson 2-3: Percentiles and Z-Score
2-3.1. Percentiles and Z-Score
()
2-3.2. Z-Score in Excel
()
Module 2: Descriptive Statistics and Probability Distributions-Lesson 2-4: Discrete and Continuous Random Variables
2-4.1. Discrete and Continuous Random Variables
()
2-4.2. Expected Value in Excel
()
Module 2: Descriptive Statistics and Probability Distributions-Lesson 2-5: Normal Distribution
2-5.1. Normal Distribution
()
2-5.2. Normal Distribution in Excel
()
2-5.3. Standard Normal Distribution in Excel
()
2-5.4. "Less Than" in Excel
()
2-5.5. "Greater Than" in Excel
()
2-5.6. "Between Values" in Excel
()
2-5.7. Finding Z for a Given Probability (INV) in Excel
()
Module 2: Descriptive Statistics and Probability Distributions-Lesson 2-6: Standard Normal Distribution Table
2-6.1. Standard Normal Distribution Table
()
Module 3: Sampling and Central Limit Theorem-Module 3 Information
Module 3 Overview
Module 3 Readings
Module 3: Sampling and Central Limit Theorem-Lesson 3-1: Producing Data
3-1.1. Producing Data
()
Module 3: Sampling and Central Limit Theorem-Lesson 3-2: Sampling
3-2.1. Sampling
()
3-2.2 Sampling Function in Excel
()
Module 3: Sampling and Central Limit Theorem-Lesson 3-3: Central Limit Theorem and Sampling Means
3-3.1. Central Limit Theorem and Sampling Means
()
3-3.2. Animating the Central Limit Theorem
()
3-3.3. Sampling Distribution and Empirical Rule in Excel
()
Module 3: Sampling and Central Limit Theorem-Lesson 3-4: Central Limit Theorem – Sampling Population
3-4.1. Central Limit Theorem – Sampling Proportion
()
Module 4: Inference-Module 4 Information
Module 4 Overview
Module 4 Readings
Module 4: Inference-Lesson 4-1: Confidence Interval Basics
4-1.1. Confidence Interval Basics
()
Module 4: Inference-Lesson 4-2: Confidence Interval for Means
4-2.1. Confidence Interval for Means
()
4-2.2. Confidence Interval for Mean in Excel
()
4-2.3. Impact of Confidence Level Illustrated in Excel
()
Module 4: Inference-Lesson 4-3: Confidence Interval for Population Proportion
4-3.1. Confidence Interval for Population Proportion
()
4-3.2. Confidence Interval for Population Proportion in Excel
()
4-3.3. Confidence Interval Animation in Excel
()
4-3.4. Starting Salary Example in Excel
()
Module 4: Inference-Lesson 4-4: Sample Size
4-4.1. Sample Size
()
4-4.2. Sample Size Proportion in Excel
()
4-4.3. Sample Size Mean in Excel
()
4-4.4. Sample Size Effect in Excel
()
Module 4: Inference-Module 4 Graded Activities
Congratulations on completing the course!
Get Your Course Certificate