Designed for students with no prior statistics knowledge, this course will provide a foundation for further study in data science, data analytics, or machine learning. Topics include descriptive statistics, probability, and discrete and continuous probability distributions. Assignments are conducted in Microsoft Excel (Windows or Mac versions). Designed to be taken with the follow-up course, “Statistics and Data Analysis with Excel, Part 2.”
Schenken Sie Ihrer Karriere Coursera Plus mit einem Rabatt von $160 , der jährlich abgerechnet wird. Sparen Sie heute.
Statistics and Data Analysis with Excel, Part 1
Dozent: Charlie Nuttelman
4.366 bereits angemeldet
Bei enthalten
(21 Bewertungen)
Empfohlene Erfahrung
Was Sie lernen werden
Calculate descriptive statistics (traditional and robust estimators).
Understand probability and apply probability rules.
Utilize statistical functions in Microsoft Excel.
Visualize univariate and bivariate data in Microsoft Excel.
Kompetenzen, die Sie erwerben
- Kategorie: Probability And Statistics
- Kategorie: Parametric Statistics
- Kategorie: Microsoft Excel
- Kategorie: Statistical Graphics
- Kategorie: Excel Formulas
Wichtige Details
Zu Ihrem LinkedIn-Profil hinzufügen
15 Aufgaben
Erfahren Sie, wie Mitarbeiter führender Unternehmen gefragte Kompetenzen erwerben.
Erwerben Sie ein Karrierezertifikat.
Fügen Sie diese Qualifikation zur Ihrem LinkedIn-Profil oder Ihrem Lebenslauf hinzu.
Teilen Sie es in den sozialen Medien und in Ihrer Leistungsbeurteilung.
In diesem Kurs gibt es 5 Module
Welcome to the course! In this module, you will orient yourself to the course policies and will learn a few of the basics related to statistics.
Das ist alles enthalten
3 Videos6 Lektüren2 Aufgaben1 Diskussionsthema
During Week 2, you will learn how to calculate population and sample statistics as well as quartiles and percentiles. Data visualization is important in the field of statistics - you will learn all about histograms, which are used for presenting univariate data in graphical format, as well as scatter plots and column plots. You will learn how to visualize univariate data in a box plot, which is a nice technique for identifying outliers. Finally, you will learn how to clean and transform data and use robust estimators in data sets that are highly affected by outliers.
Das ist alles enthalten
17 Videos3 Lektüren3 Aufgaben1 Diskussionsthema
In Week 3, you will learn all about probability and counting techniques. A thorough understanding of probability is paramount for the study of statistics. There are several rules and axioms that govern probability, and you will explore these rules in several screencasts. Finally, you will learn about conditional probability, which is the foundation for Bayes' Theorem.
Das ist alles enthalten
11 Videos3 Lektüren3 Aufgaben1 Diskussionsthema
Week 4 focuses on discrete probability distributions, in which the random variable is constrained to discrete values. Discrete probability distributions allow statisticians to make probabilistic predictions related to discrete stochastic models. These distributions include the binomial, geometric, negative binomial, hypergeometric, multinomial, and Poisson distributions.
Das ist alles enthalten
13 Videos4 Lektüren3 Aufgaben1 Diskussionsthema
Building on what you learned about probability distributions in Week 4, you will explore continuous random variables and continuous probability distributions in Week 5. These distributions include the common normal distribution and standard normal distribution, but we'll also delve into the exponential distribution, gamma distribution, and others. These distributions allow us to make probabilistic predictions related to stochastic models.
Das ist alles enthalten
14 Videos4 Lektüren4 Aufgaben1 Diskussionsthema
Dozent
Empfohlen, wenn Sie sich für Probability and Statistics interessieren
Macquarie University
Illinois Tech
Warum entscheiden sich Menschen für Coursera für ihre Karriere?
Bewertungen von Lernenden
Zeigt 3 von 21
21 Bewertungen
- 5 stars
90,47 %
- 4 stars
4,76 %
- 3 stars
0 %
- 2 stars
0 %
- 1 star
4,76 %
Geprüft am 9. Juni 2024
Geprüft am 28. Feb. 2024
Geprüft am 17. Sep. 2024
Neue Karrieremöglichkeiten mit Coursera Plus
Unbegrenzter Zugang zu über 7.000 erstklassigen Kursen, praktischen Projekten und Zertifikatsprogrammen, die Sie auf den Beruf vorbereiten – alles in Ihrem Abonnement enthalten
Bringen Sie Ihre Karriere mit einem Online-Abschluss voran.
Erwerben Sie einen Abschluss von erstklassigen Universitäten – 100 % online
Schließen Sie sich mehr als 3.400 Unternehmen in aller Welt an, die sich für Coursera for Business entschieden haben.
Schulen Sie Ihre Mitarbeiter*innen, um sich in der digitalen Wirtschaft zu behaupten.
Häufig gestellte Fragen
Access to lectures and assignments depends on your type of enrollment. If you take a course in audit mode, you will be able to see most course materials for free. To access graded assignments and to earn a Certificate, you will need to purchase the Certificate experience, during or after your audit. If you don't see the audit option:
The course may not offer an audit option. You can try a Free Trial instead, or apply for Financial Aid.
The course may offer 'Full Course, No Certificate' instead. This option lets you see all course materials, submit required assessments, and get a final grade. This also means that you will not be able to purchase a Certificate experience.
When you enroll in the course, you get access to all of the courses in the Specialization, and you earn a certificate when you complete the work. Your electronic Certificate will be added to your Accomplishments page - from there, you can print your Certificate or add it to your LinkedIn profile. If you only want to read and view the course content, you can audit the course for free.
If you subscribed, you get a 7-day free trial during which you can cancel at no penalty. After that, we don’t give refunds, but you can cancel your subscription at any time. See our full refund policy.