Statistical Analysis Fundamentals using Excel

Instructor: Murtaza Haider , IBM Skills Network Team

Intermediate Level • 1 week to complete at 10 hours a week • Flexible Schedule

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.

Skills You'll Gain

Statistical Methods
Predictive Analytics
Statistical Analysis
Probability
Data analysis
Microsoft Excel
Probability Distribution
Forecasting
Spreadsheet Software
Business Analytics
Regression Analysis
Statistics
Descriptive Statistics

Shareable Certificate

Earn a shareable certificate to add to your LinkedIn profile

Outcomes

  • Learn new concepts from industry experts
  • Gain a foundational understanding of a subject or tool
  • Develop job-relevant skills with hands-on projects
  • Earn a shareable career certificate from IBM

There are 5 modules in this course

This module introduces descriptive statistics and its role in summarizing and describing data. You will learn about the significance of statistics in making informed decisions and its relevance to professions like Data Analyst, BI Analyst, and Data Scientist. The module covers key measures of central tendency, including mean, median, and mode, and their applications in different scenarios. Additionally, you will evaluate the importance of measures of dispersion, such as variance and standard deviation, in assessing data variability.

This module focuses on data visualization and its role in effectively communicating information. You will learn to identify different types of visualizations suitable for various types of data and information. The module covers the calculation and interpretation of measures and graphs used in data visualization. You will also apply principles and guidelines to select appropriate visualizations based on data characteristics and communication goals. Additionally, you will learn data visualization techniques to present and communicate information clearly and intuitively. The module emphasizes the analysis and evaluation of visualizations to derive insights and effectively convey the intended message.

In this module, students will apply fundamental concepts of probability to real-world scenarios. They will differentiate between various probability distributions, including the normal distribution and the T-distribution, and calculate probabilities to make informed decisions. The significance of hypothesis testing, alpha levels, and p-values in statistical analysis will be explored. Students will apply probability distribution concepts and techniques to solve practical problems and analyze real-world data.

This module focuses on regression analysis and its significance in business analytics. You will develop a comprehensive understanding of regression analysis and its applications in examining variable relationships and making predictions. The module covers building regression models and evaluating their assumptions, diagnosing problems, and identifying potential remedies. Additionally, you will develop forecasting skills by applying regression techniques to predict future trends and outcomes, supporting informed decision-making.

The project focuses on analysing sales performance using data visualization and making simple forecasts for future sales based on historical data.