IBM - Statistics Fundamentals using Excel
- Offered byCoursera
Statistics Fundamentals using Excel at Coursera Overview
Duration | 12 hours |
Start from | Start Now |
Total fee | Free |
Mode of learning | Online |
Official Website | Explore Free Course  |
Credential | Certificate |
Statistics Fundamentals using Excel at Coursera Highlights
- Earn a certificate of completion
- Add to your LinkedIn profile
- 6 quizzes, 3 assignments
Statistics Fundamentals using Excel at Coursera Course details
- What you'll learn
- Describe the fundamental concepts of statistics and apply them to business and data analytics settings.
- Apply data collection, analysis, and interpretation techniques to derive actionable insights for making informed business decisions.
- Apply descriptive and inferential analysis methods to derive insights and actionable recommendations from data.
- Apply hypothesis testing, regression analysis, and forecasting to support business decision-making processes.
- This course is aimed at familiarizing Data and Business professionals with the basic concepts of statistical analysis and methods used for data-driven decision-making.
- After completing this course, you will be able to apply descriptive and inferential analysis methods, use data visualization methods to communicate data, apply concepts of probability in real-life scenarios, and apply regression techniques to predict trends. The course takes a hands-on approach to statistical analysis using Microsoft Excel and uses examples to illustrate the concepts to help you gain the foundational knowledge of statistical techniques needed to solve business intelligence (BI) problems. A hands-on project will provide you an opportunity to apply the concepts to a real-life scenario involving data-driven decision-making and an understanding of basic statistical thinking and reasoning. This course is suitable for professionals or students who aspire to embark on a career in the BI or Data Analytics fields by equipping them with the crucial skills and knowledge in statistical analysis. It is expected that learners be familiar with Excel/spreadsheet basics and high school mathematics prior to starting this course.
Statistics Fundamentals using Excel at Coursera Curriculum
Introduction and Descriptive Statistics
New Video
Welcome to Statistics!
Types of Data
New Video
New Video
Course Overview
Helpful Tips for Course Completion
Summary and Highlights: Introduction and Descriptive Statistics
Practice Quiz: Introduction to Descriptive Statistics
Graded Quiz: Introduction to Descriptive Statistics
Hands-on Lab: Getting Started with Excel Online
Lab: Measure of Dispersion
Lab: Descriptive Statistics
Module 1 Glossary: Introduction and Descriptive Statistics
Data Visualization
Visualization Fundamentals
New Video
Statistical Charts
Introducing the teacher's rating data
Summary and Highlights: Data Visualization
Practice Quiz: Data Visualization
Graded Quiz: Data Visualization
Lab: Data Visualization using Statistical Charts
Lab: Data Visualization using Pivot Charts
Module 2 Glossary: Data Visualization
Introduction to Probability Distributions
Random Numbers and Probability Distributions
State your hypothesis
New Video
New Video
New Video
Alpha (?) and P-value
Standard Normal Table
Summary and Highlights
Practice Quiz: Introduction to Probability Distribution
Graded Quiz: Introduction to Probability Distribution
Lab: Standard Normal Distribution
Lab: Probability Distribution
Module 3 Glossary: Introduction to Probability Distributions
Regression Analysis and Forecasting
Overview of Regression Analysis
New Video
New Video
New Video
New Video
New Video
Forecasting with Regression
New Video
Summary and Highlights
Practice Quiz: Introduction to Regression Analysis Assessments
Graded Quiz: Introduction to Regression Analysis Assessments
Lab: Simple Linear Regression Analysis
Lab: Multiple Linear Regression Analysis
Reading: Difference between Simple and Multiple Linear Regression
Module 4 Glossary: Regression Analysis and Forecasting
Analysing Sales Performance and Forecasting
Statistics Fundamentals using Excel at Coursera Admission Process
Important Dates
Other courses offered by Coursera
Student Forum
Anything you would want to ask experts?