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.”
Offrez à votre carrière le cadeau de Coursera Plus avec $160 de réduction, facturé annuellement. Économisez aujourd’hui.
Statistics and Data Analysis with Excel, Part 1
Instructeur : Charlie Nuttelman
4 234 déjà inscrits
Inclus avec
(21 avis)
Expérience recommandée
Ce que vous apprendrez
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.
Compétences que vous acquerrez
- Catégorie : Probability And Statistics
- Catégorie : Parametric Statistics
- Catégorie : Microsoft Excel
- Catégorie : Statistical Graphics
- Catégorie : Excel Formulas
Détails à connaître
Ajouter à votre profil LinkedIn
15 devoirs
Découvrez comment les employés des entreprises prestigieuses maîtrisent des compétences recherchées
Obtenez un certificat professionnel
Ajoutez cette qualification à votre profil LinkedIn ou à votre CV
Partagez-le sur les réseaux sociaux et dans votre évaluation de performance
Il y a 5 modules dans ce cours
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.
Inclus
3 vidéos6 lectures2 devoirs1 sujet de discussion
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.
Inclus
17 vidéos3 lectures3 devoirs1 sujet de discussion
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.
Inclus
11 vidéos3 lectures3 devoirs1 sujet de discussion
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.
Inclus
13 vidéos4 lectures3 devoirs1 sujet de discussion
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.
Inclus
14 vidéos4 lectures4 devoirs1 sujet de discussion
Instructeur
Offert par
Recommandé si vous êtes intéressé(e) par Probability and Statistics
University of Colorado Boulder
Rice University
IIMA - IIM Ahmedabad
Pour quelles raisons les étudiants sur Coursera nous choisissent-ils pour leur carrière ?
Avis des étudiants
Affichage de 3 sur 21
21 avis
- 5 stars
90,47 %
- 4 stars
4,76 %
- 3 stars
0 %
- 2 stars
0 %
- 1 star
4,76 %
Ouvrez de nouvelles portes avec Coursera Plus
Accès illimité à plus de 7 000 cours de renommée internationale, à des projets pratiques et à des programmes de certificats reconnus sur le marché du travail, tous inclus dans votre abonnement
Faites progresser votre carrière avec un diplôme en ligne
Obtenez un diplôme auprès d’universités de renommée mondiale - 100 % en ligne
Rejoignez plus de 3 400 entreprises mondiales qui ont choisi Coursera pour les affaires
Améliorez les compétences de vos employés pour exceller dans l’économie numérique
Foire Aux Questions
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.