Über diesen Kurs
39,571

100 % online

Beginnen Sie sofort und lernen Sie in Ihrem eigenen Tempo.

Flexible Fristen

Setzen Sie Fristen gemäß Ihrem Zeitplan zurück.

Stufe „Anfänger“

Ca. 22 Stunden zum Abschließen

Empfohlen: 4 weeks of study, 4-6 hours/week...

Englisch

Untertitel: Englisch, Arabischer Raum

Kompetenzen, die Sie erwerben

Data AnalysisMicrosoft ExcelStatistical AnalysisNormal Distribution

100 % online

Beginnen Sie sofort und lernen Sie in Ihrem eigenen Tempo.

Flexible Fristen

Setzen Sie Fristen gemäß Ihrem Zeitplan zurück.

Stufe „Anfänger“

Ca. 22 Stunden zum Abschließen

Empfohlen: 4 weeks of study, 4-6 hours/week...

Englisch

Untertitel: Englisch, Arabischer Raum

Lehrplan - Was Sie in diesem Kurs lernen werden

Woche
1
1 Stunde zum Abschließen

Course Orientation

You will become familiar with the course, your classmates, and our learning environment. The orientation will also help you obtain the technical skills required for the course....
2 Videos (Gesamt 7 min), 6 Lektüren, 1 Quiz
6 Lektüren
Syllabus10m
About the Discussion Forums4m
Glossary5m
Using Excel for this Course10m
Updating Your Profile10m
Social Media4m
1 praktische Übung
Orientation Quiz10m
3 Stunden zum Abschließen

Module 1: Introduction and Summarizing Data

Data is all around you, but what is the data telling you? The first step in making better decisions and taking action is to get a good understanding of information you have gathered. In this module we will learn about some of the tools in statistics that help us achieve this....
11 Videos (Gesamt 63 min), 2 Lektüren, 6 Quiz
11 Videos
1-2.1. Summarizing Data: Frequency Tables7m
1-2.2. Frequency Tables in Excel: Quantitative Data6m
1-2.3. Frequency Tables in Excel: Qualitative Data6m
1-2.4. Presenting Frequency Tables as a Bar Graph in Excel2m
1-3.1. Summarizing Data: Histograms5m
1-3.2. Histograms in Excel7m
1-4.1. Summarizing Data: Pie Charts4m
1-4.2. Pie Charts in Excel5m
1-5.1. Summarizing Data: Scatter Plots4m
1-5.2. Scatter Plots in Excel4m
2 Lektüren
Module 1 Overview3m
Module 1 Readings45m
6 praktische Übungen
Lesson 1-1 Practice Quiz6m
Lesson 1-2 Practice Quiz10m
Lesson 1-3 Practice Quiz8m
Lesson 1-4 Practice Quiz8m
Lesson 1-5 Practice Quiz8m
Module 1 Quiz38m
Woche
2
4 Stunden zum Abschließen

Module 2: Descriptive Statistics and Probability Distributions

We all have heard the phrase that a "picture is worth a thousand words," but you certainly don’t want one of those to be "what exactly am I looking at?" So, now that you know to use "pictures" to summarize your data, let’s make those pictures easier to understand....
16 Videos (Gesamt 107 min), 2 Lektüren, 7 Quiz
16 Videos
2-1.2. Mean and Median in Excel3m
2-2.1. Measures of Dispersion9m
2-2.2. Standard Deviation in Excel2m
2-3.1. Percentiles and Z-Score13m
2-3.2. Z-Score in Excel5m
2-4.1. Discrete and Continuous Random Variables11m
2-4.2. Expected Value in Excel6m
2-5.1. Normal Distribution10m
2-5.2. Normal Distribution in Excel5m
2-5.3. Standard Normal Distribution in Excel4m
2-5.4. "Less Than" in Excel1m
2-5.5. "Greater Than" in Excel1m
2-5.6. "Between Values" in Excel1m
2-5.7. Finding Z for a Given Probability (INV) in Excel3m
2-6.1. Standard Normal Distribution Table14m
2 Lektüren
Module 2 Overview3m
Module 2 Readings15m
7 praktische Übungen
Lesson 2-1 Practice Quiz6m
Lesson 2-2 Practice Quiz8m
Lesson 2-3 Practice Quiz6m
Lesson 2-4 Practice Quiz6m
Lesson 2-5 Practice Quiz6m
Lesson 2-6 Practice Quiz6m
Module 2 Quiz30m
Woche
3
5 Stunden zum Abschließen

Module 3: Sampling and Central Limit Theorem

You are charged with analyzing a market segment for your company. You and your team have figured out what variables you need to understand; you also have an idea what factors might be influencing these variables of interest. Now you are ready to do your analysis. But, wait! Where is the data? How do you begin to get the data? In this module we will review the means by which you can begin to produce data – the concepts of sampling and Central Limit Theorem – and will help you understand how to produce "good" sample data and why sample data will work....
7 Videos (Gesamt 63 min), 2 Lektüren, 6 Quiz
7 Videos
3-2.1. Sampling14m
3-2.2 Sampling Function in Excel6m
3-3.1. Central Limit Theorem and Sampling Means9m
3-3.2. Animating the Central Limit Theorem6m
3-3.3. Sampling Distribution and Empirical Rule in Excel11m
3-4.1. Central Limit Theorem – Sampling Proportion5m
2 Lektüren
Module 3 Overview3m
Module 3 Readings30m
5 praktische Übungen
Lesson 3-1 Practice Quiz8m
Lesson 3-2 Practice Quiz8m
Lesson 3-3 Practice Quiz6m
Lesson 3-4 Practice Quiz6m
Module 3 Quiz44m
Woche
4
3 Stunden zum Abschließen

Module 4: Inference

You have sample data and have done the analysis – you think you can say something about the population based on your sample study. But, do you have a sense of what are the chances of you being right or wrong? How can you be surer? What else should you have considered? In this module, you will learn how to find the answers to these questions....
12 Videos (Gesamt 97 min), 2 Lektüren, 5 Quiz
12 Videos
4-2.1. Confidence Interval for Means9m
4-2.2. Confidence Interval for Mean in Excel8m
4-2.3. Impact of Confidence Level Illustrated in Excel4m
4-3.1. Confidence Interval for Population Proportion10m
4-3.2. Confidence Interval for Population Proportion in Excel8m
4-3.3. Confidence Interval Animation in Excel5m
4-3.4. Starting Salary Example in Excel7m
4-4.1. Sample Size9m
4-4.2. Sample Size Proportion in Excel3m
4-4.3. Sample Size Mean in Excel7m
4-4.4. Sample Size Effect in Excel5m
2 Lektüren
Module 4 Overview3m
Module 4 Readings20m
5 praktische Übungen
Lesson 4-1 Practice Quiz6m
Lesson 4-2 Practice Quiz6m
Lesson 4-3 Practice Quiz6m
Lesson 4-4 Practice Quiz8m
Module 4 Quiz20m
4.8
70 BewertungenChevron Right

50%

ziehen Sie für Ihren Beruf greifbaren Nutzen aus diesem Kurs

50%

erhalten Sie eine Gehaltserhöhung oder Beförderung

Top-Bewertungen

von DAMay 15th 2018

The separation of the concepts and Excel skills made the lessons very easy to navigate. Although I knew the concepts from a previous statistics course, the Excel skills made everything feel like new!

von EWApr 19th 2019

This professor does an exceptional job of breaking down complex concepts and calculations without diluting the material. The statistical examples are highly relevant and interesting.

Dozent

Avatar

Fataneh Taghaboni-Dutta

Clinical Professor of Business Administration
University of Illinois, Urbana-Champaign College of Business Department of Business Administration

Beginnen Sie damit, auf Ihren Master-Abschluss hinzuarbeiten.

This Kurs is part of the 100% online Master of Business Administration (iMBA) from University of Illinois at Urbana-Champaign. If you are admitted to the full program, your courses count towards your degree learning.

Über University of Illinois at Urbana-Champaign

The University of Illinois at Urbana-Champaign is a world leader in research, teaching and public engagement, distinguished by the breadth of its programs, broad academic excellence, and internationally renowned faculty and alumni. Illinois serves the world by creating knowledge, preparing students for lives of impact, and finding solutions to critical societal needs. ...

Über die Spezialisierung Managerial Economics and Business Analysis

In order to effectively manage and operate a business, managers and leaders need to understand the market characteristics and economic environment they operate in. In this Specialization, you will build a solid understanding of the operation of markets and the macro-economic environment with real-world examples. You will be able to identify firm and country-level economic factors that impact business decisions, develop an analytical framework using statistical tools, and apply economic theory and data in the analysis of business environment and trends to make effective business decisions. The capstone project involves an in-depth analysis of an actual business situation in which you will examine the global economic environment of a business. The final project will be a business plan that uses statistical tools and economic theory to create a comprehensive analysis of the microeconomic and macroeconomic environment in which the focal company operates. This Specialization is part of the University of Illinois Masters of Business Administration degree program, the iMBA. Learn more about the admission into the program here and how your Coursera work can be leveraged if accepted into the program. You can also start with for-credit courses within the Illinois iMBA degree program....
Managerial Economics and Business Analysis

Häufig gestellte Fragen

  • Sobald Sie sich für ein Zertifikat angemeldet haben, haben Sie Zugriff auf alle Videos, Quizspiele und Programmieraufgaben (falls zutreffend). Aufgaben, die von anderen Kursteilnehmern bewertet werden, können erst dann eingereicht und überprüft werden, wenn Ihr Unterricht begonnen hat. Wenn Sie sich den Kurs anschauen möchten, ohne ihn zu kaufen, können Sie womöglich auf bestimmte Aufgaben nicht zugreifen.

  • Wenn Sie sich für den Kurs anmelden, erhalten Sie Zugriff auf alle Kurse der Spezialisierung und Sie erhalten nach Abschluss aller Arbeiten ein Zertifikat. Ihr elektronisches Zertifikat wird zu Ihrer Seite „Errungenschaften“ hinzugefügt – von dort können Sie Ihr Zertifikat ausdrucken oder es zu Ihrem LinkedIn Profil hinzufügen. Wenn Sie nur lesen und den Inhalt des Kurses anzeigen möchten, können Sie kostenlos als Gast an dem Kurs teilnehmen.

Haben Sie weitere Fragen? Besuchen Sie das Hilfe-Center für Teiln..