This Statistical Analysis Fundamentals Using Excel course teaches you the skills you need to embark on your career as a business intelligence (BI) analyst or data analyst.

You will learn:

Job-ready skills in 5 weeks, plus you’ll get practical experience employers look for on a resume and an industry-recognized credential
The fundamental concepts of statistics and their application in business and data analytics settings
Data collection, analysis, and interpretation techniques to derive actionable insights for making informed business decisions
Descriptive and inferential analysis methods to derive insights and actionable recommendations from data
Hypothesis testing, regression analysis, and forecasting to support business decision-making processes

Course Overview

In this course, you’ll be familiar with the data and business professionals with the basic concepts of statistical analysis and methods used for data-driven decision-making.

You’ll explore descriptive and inferential analysis methods and apply them. You’ll also use data visualization methods to communicate data, apply concepts of probability in real-life scenarios, and apply regression techniques to predict trends.

The hands-on labs in this course use examples to illustrate the concepts to help you gain the foundational knowledge of statistical techniques needed to solve them.

The peer review project in this course will provide 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 aspiring students or professionals who want to develop their careers in the BI or data analytics fields by equipping them with crucial skills and knowledge in statistical analysis.

If you’re keen to take your project manager career to the next level and boost your resume with in-demand skills that catch an employer’s eye, ENROLL today and have job-ready skills you can use immediately within five weeks!

Course Syllabus

Module 0: Welcome

· Video: Course Introduction

· Reading: General Information

· Reading: Learning Objectives and Syllabus

· Reading: Grading Scheme

· Reading: Helpful Tips for Course Completion

Module 1: Introduction and Descriptive Statistics

· Reading: Module 1 Introduction and Learning objective

· Video: Welcome to Statistics!

· Video: Types of Data

· Video: Measure of Central Tendency

· Video: Measures of Dispersion

· Reading: Measures of Dispersion

· Lab: Getting Started with Excel Online

· Lab: Measure of Dispersion

· Lab: Descriptive Statistics

· Reading: Summary and Highlights: Introduction and Descriptive Statistics

· Practice Quiz: Introduction to Descriptive Statistics

· Graded Quiz: Introduction to Descriptive Statistics

· Reading: Module 1 Glossary: Introduction and Descriptive Statistics

Module 2: Data Visualization

· Reading: Module 2 Introduction and Learning objective

· Video: Visualization Fundamentals

· Lab: Data Visualization Using Statistical Charts

· Video: Statistics by Groups

· Video: Statistical Charts

· Video: Introducing the teacher's rating data

· Lab: Data Visualization Using Pivot Chart

· Reading: Summary and Highlights: Data Visualization

· Practice Quiz: Data Visualization

· Graded Quiz: Data Visualization

· Reading: Module 2 Glossary: Data Visualization

Module 3: Introduction to Probability Distributions

· Reading: Module 3 Introduction and Learning objective

· Video: Random Numbers and Probability Distributions

· Video: State your hypothesis

· Reading: Alpha (α) and P-value

· Video: Normal Distribution

· Lab: Standard Normal Distribution

· Video: T-Distribution

· Video: Probability of Getting a High or Low Teaching Evaluation

· Lab: Probability Distribution

· Reading: Standard Normal Table

· Reading: Summary and Highlights

· Practice Quiz: Introduction to Probability Distribution

· Graded Quiz: Introduction to Probability Distribution

· Reading: Module 3 Glossary: Introduction to Probability Distributions

Module 4: Regression Analysis and Forecasting

· Reading: Module 4 Introduction and Learning objective

· Video: Overview of Regression Analysis

· Video: Simple Linear Regression

· Video: Building and Interpreting Simple Linear Regression Models

· Lab: Simple Linear Regression Analysis

· Video: Multiple Linear Regression

· Video: Building and Interpreting Multiple Linear Regression Models

· Lab: Multiple Linear Regression Analysis

· Reading: Difference between Simple and Multiple Linear Regression

· Video: (Optional) Assumption and Diagnosis in Regression Analysis

· Video: Forecasting with Regression

· Video: Applying Regression Techniques for Forecasting

· Reading: Summary and Highlights

· Practice Quiz: Regression Analysis and Forecasting

· Graded Quiz: Regression Analysis and Forecasting

· Reading: Module 4 Glossary: Regression Analysis and Forecasting

Module 5: Analysing Sales Performance and Forecasting

· Reading: Module 5 Introduction and Learning objective

· Reading: About the Course Projects

· Reading: Practice Project Overview

· Lab: Practice Project Guide

· Reading: Course Glossary: Statistics Fundamentals using Excel

· Reading: Final Project Overview and Tasks

· Final Project: Submit Your Work and Peer Review

· Reading: Instructions for the Final Exam

· Final Exam (Statistics Fundamentals Using Excel)

· Reading: Re-take exam

Module : Course Wrap-up

· Reading: Congratulations and Next Step

· Reading: Team and Acknowledgments

· Reading: Copyrights and Trademarks

Course Rating & Feedback

· Reading: Feedback

Badge

· Reading: How to claim your certificate

· Reading: Claim your badge here

Recommended Skills Prior to Taking this Course

Before starting this course, learners are expected to be familiar with Excel/Spreadsheet basics and high school mathematics.

Statistics Fundamentals with Excel

Language

Topic

Skills You Will Learn

Offered By

Estimated Effort

Platform

Last Update