Buy Now AED 274.99 + VAT

Monthly Subscription Starting at AED 99 + VAT

Exploring and Producing Data for Business Decision Making
  • Level Foundation
  • المدة 23 ساعات hours
  • الطبع بواسطة University of Illinois Urbana-Champaign
  • Offered by

عن

This course provides an analytical framework to help you evaluate key problems in a structured fashion and will equip you with tools to better manage the uncertainties that pervade and complicate business processes. Specifically, you will learn how to summarize data and learn concepts of frequency, normal distribution, statistical studies, sampling, and confidence intervals. While you will be introduced to some of the science of what is being taught, the focus will be on applying the methodologies. This will be accomplished through the use of Excel and data sets from different disciplines, allowing you to see the use of statistics in a range of settings. The course will focus not only on explaining these concepts, but also understanding and interpreting the results obtained. You will be able to: - Summarize large data sets in graphical, tabular, and numerical forms - Understand the significance of proper sampling and why one can rely on sample information - Understand why normal distribution can be used in a wide range of settings - Use sample information to make inferences about the population with a certain level of confidence about the accuracy of the estimations - Use Excel for statistical analysis This course is part of Gies College of Business' suite of online programs, including the iMBA and iMSM.

الوحدات

About the Course

    • 2 Videos
    • 5 Readings
    • 1 Quiz
Show info about module content

2 Videos

  • Welcome to Exploring and Producing Data for Business Decision Making!
  • Learn on Your Terms

5 Readings

  • Syllabus
  • ePub
  • About the Discussion Forums
  • Glossary
  • Online Education at Gies College of Business

1 Quiz

  • Orientation Quiz

About Excel

    • 1 Videos
    • 1 Readings
Show info about module content

1 Videos

  • Excel Data Analysis Toolpak

1 Readings

  • Using Excel for this Course

About Your Classmates

    • 1 Readings
    • 1 Discussion
Show info about module content

1 Discussions

  • Getting to Know Your Classmates

1 Readings

  • Updating Your Profile

Module 1 Information

    • 2 Readings
Show info about module content

2 Readings

  • Module 1 Overview
  • Module 1 Readings

Lesson 1-1: Introduction to Business Statistics

    • 1 Videos
    • 1 Quiz
Show info about module content

1 Videos

  • 1-1.1. Basic Terminology

1 Quiz

  • Lesson 1-1 Practice Quiz

Lesson 1-2: Descriptive Statistics: Frequency Tables

    • 4 Videos
    • 1 Quiz
Show info about module content

4 Videos

  • 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

1 Quiz

  • Lesson 1-2 Practice Quiz

Lesson 1-3: Descriptive Statistics: Histograms

    • 2 Videos
    • 1 Quiz
Show info about module content

2 Videos

  • 1-3.1. Summarizing Data: Histograms
  • 1-3.2. Histograms in Excel

1 Quiz

  • Lesson 1-3 Practice Quiz

Lesson 1-4: Descriptive Statistics: Pie Charts

    • 2 Videos
    • 1 Quiz
Show info about module content

2 Videos

  • 1-4.1. Summarizing Data: Pie Charts
  • 1-4.2. Pie Charts in Excel

1 Quiz

  • Lesson 1-4 Practice Quiz

Lesson 1-5: Descriptive Statistics: Scatter Plots

    • 2 Videos
    • 1 Quiz
Show info about module content

2 Videos

  • 1-5.1. Summarizing Data: Scatter Plots
  • 1-5.2. Scatter Plots in Excel

1 Quiz

  • Lesson 1-5 Practice Quiz

Module 1 Graded Activities

    • 1 Quiz
Show info about module content

1 Quiz

  • Module 1 Quiz

Module 2 Information

    • 2 Readings
Show info about module content

2 Readings

  • Module 2 Overview
  • Module 2 Readings

Lesson 2-1: Measures of Central Tendencies

    • 2 Videos
    • 1 Quiz
Show info about module content

2 Videos

  • 2-1.1. Measures of Central Tendencies
  • 2-1.2. Mean and Median in Excel

1 Quiz

  • Lesson 2-1 Practice Quiz

Lesson 2-2: Measures of Dispersion

    • 2 Videos
    • 1 Quiz
Show info about module content

2 Videos

  • 2-2.1. Measures of Dispersion
  • 2-2.2. Standard Deviation in Excel

1 Quiz

  • Lesson 2-2 Practice Quiz

Lesson 2-3: Percentiles and Z-Score

    • 2 Videos
    • 1 Quiz
Show info about module content

2 Videos

  • 2-3.1. Percentiles and Z-Score
  • 2-3.2. Z-Score in Excel

1 Quiz

  • Lesson 2-3 Practice Quiz

Lesson 2-4: Discrete and Continuous Random Variables

    • 2 Videos
    • 1 Quiz
Show info about module content

2 Videos

  • 2-4.1. Discrete and Continuous Random Variables
  • 2-4.2. Expected Value in Excel

1 Quiz

  • Lesson 2-4 Practice Quiz

Lesson 2-5: Normal Distribution

    • 7 Videos
    • 1 Quiz
Show info about module content

7 Videos

  • 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

1 Quiz

  • Lesson 2-5 Practice Quiz

Lesson 2-6: Standard Normal Distribution Table

    • 1 Videos
    • 1 Quiz
Show info about module content

1 Videos

  • 2-6.1. Standard Normal Distribution Table

1 Quiz

  • Lesson 2-6 Practice Quiz

Module 2 Graded Activities

    • 1 Quiz
Show info about module content

1 Quiz

  • Module 2 Quiz

Module 3 Information

    • 2 Readings
Show info about module content

2 Readings

  • Module 3 Overview
  • Module 3 Readings

Lesson 3-1: Producing Data

    • 1 Videos
    • 1 Quiz
Show info about module content

1 Videos

  • 3-1.1. Producing Data

1 Quiz

  • Lesson 3-1 Practice Quiz

Lesson 3-2: Sampling

    • 2 Videos
    • 1 Quiz
Show info about module content

2 Videos

  • 3-2.1. Sampling
  • 3-2.2 Sampling Function in Excel

1 Quiz

  • Lesson 3-2 Practice Quiz

Lesson 3-3: Central Limit Theorem and Sampling Means

    • 3 Videos
    • 1 Quiz
Show info about module content

3 Videos

  • 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

1 Quiz

  • Lesson 3-3 Practice Quiz

Lesson 3-4: Central Limit Theorem – Sampling Population

    • 1 Videos
    • 1 Quiz
Show info about module content

1 Videos

  • 3-4.1. Central Limit Theorem – Sampling Proportion

1 Quiz

  • Lesson 3-4 Practice Quiz

Module 3 Graded Activities

    • 1 Quiz
    • 1 PeerReview
Show info about module content

1 Peer Review

  • Exploring and Producing Data Peer Review Assignment

1 Quiz

  • Module 3 Quiz

Module 4 Information

    • 2 Readings
Show info about module content

2 Readings

  • Module 4 Overview
  • Module 4 Readings

Lesson 4-1: Confidence Interval Basics

    • 1 Videos
    • 1 Quiz
Show info about module content

1 Videos

  • 4-1.1. Confidence Interval Basics

1 Quiz

  • Lesson 4-1 Practice Quiz

Lesson 4-2: Confidence Interval for Means

    • 3 Videos
    • 1 Quiz
Show info about module content

3 Videos

  • 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

1 Quiz

  • Lesson 4-2 Practice Quiz

Lesson 4-3: Confidence Interval for Population Proportion

    • 4 Videos
    • 1 Quiz
Show info about module content

4 Videos

  • 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

1 Quiz

  • Lesson 4-3 Practice Quiz

Lesson 4-4: Sample Size

    • 4 Videos
    • 1 Quiz
Show info about module content

4 Videos

  • 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

1 Quiz

  • Lesson 4-4 Practice Quiz

Module 4 Graded Activities

    • 2 Readings
    • 1 Quiz
    • 1 Plugin
Show info about module content

2 Readings

  • Congratulations on completing the course!
  • Get Your Course Certificate

1 Quiz

  • Module 4 Quiz

Auto Summary

Unlock the power of data with "Exploring and Producing Data for Business Decision Making," a foundational course in the realm of Data Science & AI offered by Coursera. This comprehensive program, designed by the Gies College of Business, equips you with essential analytical frameworks to tackle complex business problems with confidence. Dive into the world of data analysis and gain proficiency in summarizing data, understanding statistical concepts such as frequency, normal distribution, and confidence intervals, and mastering the art of sampling. Emphasizing practical application, the course leverages Excel and diverse data sets to demonstrate statistical methodologies in various real-world scenarios. Key takeaways from this course include the ability to: - Graphically, tabularly, and numerically summarize large data sets - Grasp the importance of proper sampling techniques - Utilize normal distribution across different settings - Make informed inferences about populations using sample data with a specified level of confidence - Perform statistical analysis using Excel With a total duration of 1380 minutes, this course is suitable for learners at the foundational level. Subscription options include Starter, Professional, and Paid plans, catering to different learning needs and budgets. Whether you're a business professional looking to enhance your decision-making capabilities or an aspiring data scientist, this course provides valuable skills that can be leveraged towards advanced degrees like the iMBA and iMSM. Embark on your data-driven journey today and explore how your Coursera achievements can pave the way for further academic pursuits with the Gies College of Business. For more details on admission and leveraging your coursework, visit [Gies Business iDegrees](https://degrees.giesbusiness.illinois.edu/idegrees/).

Fataneh Taghaboni-Dutta, Ph.D., PMP, CSM, CSPO
Instructor

Fataneh Taghaboni-Dutta, Ph.D., PMP, CSM, CSPO