Essential Statistics for Data Analysis using Excel

Provided by:
6/10 stars
based on  7 reviews
Provided by:
Cost FREE , Add a Verified Certificate for $99
Start Date Upcoming
Essential Statistics for Data Analysis using Excel

Course Details

Cost

FREE,
Add a Verified Certificate for $99

Upcoming Schedule

  • Upcoming

Course Provider

edX online courses
Harvard University, the Massachusetts Institute of Technology, and the University of California, Berkeley, are just some of the schools that you have at your fingertips with edX. Through massive open online courses (MOOCs) from the world's best universities, you can develop your knowledge in literature, math, history, food and nutrition, and more. These online classes are taught by highly-regarded experts in the field. If you take a class on computer science through Harvard, you may be tau...
Harvard University, the Massachusetts Institute of Technology, and the University of California, Berkeley, are just some of the schools that you have at your fingertips with edX. Through massive open online courses (MOOCs) from the world's best universities, you can develop your knowledge in literature, math, history, food and nutrition, and more. These online classes are taught by highly-regarded experts in the field. If you take a class on computer science through Harvard, you may be taught by David J. Malan, a senior lecturer on computer science at Harvard University for the School of Engineering and Applied Sciences. But there's not just one professor - you have access to the entire teaching staff, allowing you to receive feedback on assignments straight from the experts. Pursue a Verified Certificate to document your achievements and use your coursework for job and school applications, promotions, and more. EdX also works with top universities to conduct research, allowing them to learn more about learning. Using their findings, edX is able to provide students with the best and most effective courses, constantly enhancing the student experience.

Provider Subject Specialization
Sciences & Technology
Business & Management
23710 reviews

Course Description

This course is part of the Microsoft Professional Program Certificate in Data Science.

If you’re considering a career as a data analyst, you need to know about histograms, Pareto charts, Boxplots, Bayes’ theorem, and much more. In this applied statistics course, the second in our Microsoft Excel Data Analyst XSeries, use the powerful tools built into Excel, and explore the core principles of statistics and basic probability—from both the conceptual and applied perspectives. Learn about descriptive statistics, basic probability, random variables, sampling and confidence intervals, and hypothesis testing. And see how to apply these concepts and principles using the environment, functions, and visualizations of Excel.

As a data science pro, the ability to analyze data helps you to make better decisions, and a solid foundation in statistics and basic probability helps you to better understand your data. Using real-world concepts ap...

This course is part of the Microsoft Professional Program Certificate in Data Science.

If you’re considering a career as a data analyst, you need to know about histograms, Pareto charts, Boxplots, Bayes’ theorem, and much more. In this applied statistics course, the second in our Microsoft Excel Data Analyst XSeries, use the powerful tools built into Excel, and explore the core principles of statistics and basic probability—from both the conceptual and applied perspectives. Learn about descriptive statistics, basic probability, random variables, sampling and confidence intervals, and hypothesis testing. And see how to apply these concepts and principles using the environment, functions, and visualizations of Excel.

As a data science pro, the ability to analyze data helps you to make better decisions, and a solid foundation in statistics and basic probability helps you to better understand your data. Using real-world concepts applicable to many industries, including medical, business, sports, insurance, and much more, learn from leading experts why Excel is one of the top tools for data analysis and how its built-in features make Excel a great way to learn essential skills.

Before taking this course, you should be familiar with organizing and summarizing data using Excel analytic tools, such as tables, pivot tables, and pivot charts. You should also be comfortable (or willing to try) creating complex formulas and visualizations. Want to start with the basics? Check out DAT205x: Introduction to Data Analysis using Excel. As you learn these concepts and get more experience with this powerful tool that can be extremely helpful in your journey as a data analyst or data scientist, you may want to also take the third course in our series, DAT206x Analyzing and Visualizing Data with Excel. This course includes excerpts from Microsoft Excel 2016: Data Analysis and Business Modeling from Microsoft Press and authored by course instructor Wayne Winston.

This course is also part of the Microsoft Excel for the Data Analyst XSeries.

Reviews 6/10 stars
7 Reviews for Essential Statistics for Data Analysis using Excel

Ratings details

  • 5 stars
  • 4 stars
  • 3 stars
  • 2 stars
  • 1 stars
  • 5 stars
  • 4 stars
  • 3 stars
  • 2 stars
  • 1 stars
  • 5 stars
  • 4 stars
  • 3 stars
  • 2 stars
  • 1 stars

Rankings are based on a provider's overall CourseTalk score, which takes into account both average rating and number of ratings. Stars round to the nearest half.

Sort By
student profile image
student profile image

student

4/10 starsCompleted
2 years, 7 months ago
In the context of the "Microsoft Professional Program for Data Science", this course is somewhat a waste of time. The whole cours is centered around excel, which doesn´t make much sense in the above context in my opinion. This course could be usefull, if they would teach it in R or Python and maybe use excel for some calculations or visualizations. The theory videos of the first 2-3 modules are ok, then they are getting pretty fast and drift away from the data science context. I´m doint BI/Data Science for a couple years now and never had to organize a survey, why do I need to know the problems which can occure by "randomly" picking people for it?! One could probably skip all theory videos and just watch the excel cases of Mr. Winston, because the examples are much better in those. If you´re doing the "Microsoft Professional Program for Data Science", I reccomend to do the course "DAT203.1x - Modul2" before this one. There you get... In the context of the "Microsoft Professional Program for Data Science", this course is somewhat a waste of time. The whole cours is centered around excel, which doesn´t make much sense in the above context in my opinion. This course could be usefull, if they would teach it in R or Python and maybe use excel for some calculations or visualizations. The theory videos of the first 2-3 modules are ok, then they are getting pretty fast and drift away from the data science context. I´m doint BI/Data Science for a couple years now and never had to organize a survey, why do I need to know the problems which can occure by "randomly" picking people for it?! One could probably skip all theory videos and just watch the excel cases of Mr. Winston, because the examples are much better in those. If you´re doing the "Microsoft Professional Program for Data Science", I reccomend to do the course "DAT203.1x - Modul2" before this one. There you get the real statistics basics you need to know with good examples.
Was this review helpful? Yes0
 Flag
YUNFEI DUAN profile image
YUNFEI DUAN profile image

YUNFEI DUAN

10/10 starsCompleted
2 years, 7 months ago
Microsoft should give Wayne a medal for his great work on demonstrating complicated theory using demos in Excel.He is the one who did the dirty work and get complaints while Liberty is the voice which encouraged people and make problems seem easier. This course is a bit hard, quiz is a bit difficult, and exam questions are just endless. But, it worth to study.
Was this review helpful? Yes0
 Flag
student profile image
student profile image

student

8/10 starsTaking Now
2 years, 8 months ago
i see many comment of people who want to be successful without having what it really requires in order to be one..yes you have to learn statistics !!! if you can't dont blame the instructors for your incapability ..and to the woman that comments about the course not being free..knowledge is free the certificate costs..it very simple!
Was this review helpful? Yes0
 Flag
Nick Wienholt profile image
Nick Wienholt profile image

Nick Wienholt

3/10 starsCompleted
2 years, 8 months ago
The content is pretty good, and the passion Liberty and Wayne have in the presentation is admirable. HOWEVER, the pre-course exam is hopeless - by the end I was just clicking out of annoyance and frustration. As another reviewer noted, there needs to be a "I don't know option". The course was very long, especially Week 6, and the final exam was a tedious drudge. Repeated question after repeated question with tiny difference in the parameters. Why? Also, Wayne's distracted clicking between empty cells as he is explaining a topic should have been picked up and stopped by the production team. The major criticism is the use of Excel - its really a relic, and has no place in modern data science. The course should be revised and added after the Python/ R courses and be done in Jupyter
Was this review helpful? Yes0
 Flag
Maja Djordjevic profile image
Maja Djordjevic profile image

Maja Djordjevic

2/10 starsDropped
2 years, 8 months ago
There is some contradictory statements like course of FREE but you have to PAY if you want certificate it means course is not FREE.
Was this review helpful? Yes0
 Flag
Ryan Armstrong profile image
Ryan Armstrong profile image

Ryan Armstrong

4/10 starsCompleted
2 years, 9 months ago
This review is written from the perspective of the course within the Microsoft Data Science Certification program and by a practicing researcher and BI professional. There is no doubt that statistics are a fundamental part of work as an analyst and researcher. From that perspective, there were a few pleasant moments of review in the course, and even a couple of "ah-ha!" moments. But in general, I view it as cruel and unusual punishment to have to take this class as a part of the Data Science certification because 1) many Analysts and/or (aspiring) data scientists will already be familiar with these concepts and 2) the text book suggested for the course is written around Excel functions and not around problems. I haven't looked for books on Excel 2016 but there are marvelous books for 2010 and 2013 that center exclusively on problems that an analyst might come across (i.e. answers "What do you need to do?" before trying to answer "H... This review is written from the perspective of the course within the Microsoft Data Science Certification program and by a practicing researcher and BI professional. There is no doubt that statistics are a fundamental part of work as an analyst and researcher. From that perspective, there were a few pleasant moments of review in the course, and even a couple of "ah-ha!" moments. But in general, I view it as cruel and unusual punishment to have to take this class as a part of the Data Science certification because 1) many Analysts and/or (aspiring) data scientists will already be familiar with these concepts and 2) the text book suggested for the course is written around Excel functions and not around problems. I haven't looked for books on Excel 2016 but there are marvelous books for 2010 and 2013 that center exclusively on problems that an analyst might come across (i.e. answers "What do you need to do?" before trying to answer "How do you do it"? If my goal were to learn statistics, I would look elsewhere. It needs more supplemental readings--the book is next to useless for covering statistical concepts. All in all, it reminded me of everything I hated about my undergraduate statistics course: little discussion of how to deal with real-world situations, over-simplified examples, quiz questions requiring an understanding of basketball, etc. Couple that with time pressure and a lack of depth and it made for frustrating study. For me it was a hoop to jump through and I'm glad it's over. Others might get a lot out of it. I would not buy the textbook.
Was this review helpful? Yes0
 Flag
Medhat Salem profile image
Medhat Salem profile image

Medhat Salem

10/10 starsCompleted
2 years, 10 months ago
Excellent statistics course. Pros: Content is better than expected, and mostly about real world problems. Cons: 1- Quizzes are a bit difficult, and correct answers are not shown after answering quiz's question, (only shown after homeworks). 2- Few quiz questions require excel 2016.
Was this review helpful? Yes0
 Flag

Rating Details


  • 5 stars
  • 4 stars
  • 3 stars
  • 2 stars
  • 1 stars
  • 5 stars
  • 4 stars
  • 3 stars
  • 2 stars
  • 1 stars
  • 5 stars
  • 4 stars
  • 3 stars
  • 2 stars
  • 1 stars

Rankings are based on a provider's overall CourseTalk score, which takes into account both average rating and number of ratings. Stars round to the nearest half.