Statistics and Data Analysis with Excel: Intermediate

Statistics and Data Analysis with Excel: Intermediate

This course is part of Statistics and Data Analysis with Excel Specialization

Instructor: Assoc Prof Prashan S. M. Karunaratne

Access provided by VodafoneZiggo

3,534 already enrolled

5 modules

Gain insight into a topic and learn the fundamentals.

18 reviews

Intermediate level

Recommended experience

1 week to complete

at 10 hours a week

Flexible schedule

Learn at your own pace

5 modules

Gain insight into a topic and learn the fundamentals.

18 reviews

Intermediate level

Recommended experience

1 week to complete

at 10 hours a week

Flexible schedule

Learn at your own pace

What you'll learn

Analyse and evaluate data using advanced statistical methods.
Synthesise and interpret inferential statistics for predictive analysis.
Design and develop interactive data visualisations.
Integrate Excel functions and Data Analysis ToolPak for professional applications.

Skills you'll gain

Tools you'll learn

Microsoft Excel

Details to know

Shareable certificate

Add to your LinkedIn profile

Assessments

9 assignments

Taught in English

See how employees at top companies are mastering in-demand skills

Learn more about Coursera for Business

logos of Petrobras, TATA, Danone, Capgemini, P&G and L'Oreal

Build your subject-matter expertise

This course is part of the Statistics and Data Analysis with Excel Specialization

When you enroll in this course, you'll also be enrolled in this Specialization.

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

There are 5 modules in this course

In today's data-driven world, the ability to analyse and interpret complex data is crucial for making informed, strategic decisions. This comprehensive online course will empower you with advanced statistical techniques to transform raw data into actionable insights, using Microsoft Excel.

Through hands-on exercises, you will delve into the world of inferential statistics, learning how to draw meaningful conclusions and make accurate predictions based on sample data. Gain proficiency in creating and interpreting pivot tables, pivot charts, and other interactive data visualisations to effectively communicate your findings. Enhance your digital literacy with extensive use of Excel's advanced functions and the Data Analysis ToolPak, streamlining your data analysis workflow. Join over 1 million professionals who have advanced their careers with our highly-rated Excel courses. Whether you’re looking to boost your employability, enhance your current role, or simply elevate your Excel skills, this course will provide you with the knowledge and tools to stand out in the competitive job market. Enrol now and become a data-driven leader, driving strategic decisions with confidence and precision.

In this module, we will cover the Pivot Tables and Pivot Charts. We will be looking at how we can generate useful numerical summaries from large data sets.

What's included

8 videos7 readings2 assignments

8 videos Total 35 minutes

Welcome to Statistics and Data Analysis with Excel: Intermediate 2 minutes
Introduction to Pivot Tables and Pivot Charts 1 minute
PivotTables - Part 1 5 minutes
PivotTables - Part 2 6 minutes
Customising Pivot Tables - Part 1 5 minutes
Customising Pivot Tables - Part 2 6 minutes
Pivot Charts - Part 1 4 minutes
Pivot Charts - Part 2 7 minutes

7 readings Total 70 minutes

Course Overview 10 minutes
Your Learning Path - How the course is structured 10 minutes
Download the workbooks on Pivot Tables and Pivot Charts 10 minutes
Toolbox Summary - Pivot Tables & Pivot Charts Part 1 10 minutes
Toolbox Summary - Pivot Tables & Pivot Charts Part 2 10 minutes
Why the Practice Assignment is after the Graded Assignment 10 minutes
Optional Reading - Pivot Tables and Pivot Charts 10 minutes

2 assignments Total 60 minutes

Test Yourself: Pivot Tables and Pivot Charts 30 minutes
Pivot Tables and Pivot Charts - Practice for the Final Assignment of the Course 30 minutes

In this module, we will be looking at categorical data. We will also explore statistical techniques and tests to infer whether we have any significant patterns in our distributions of categorical variables.

What's included

3 videos4 readings2 assignments

3 videos Total 14 minutes

Categorical Data and Goodness-of-Fit 3 minutes
Goodness-of-Fit 7 minutes
The Chi-Square Test 4 minutes

4 readings Total 40 minutes

Download the workbook on Categorical Data and Goodness-of-Fit 10 minutes
Toolbox Summary - Categorical Data and Chi Square Tests 10 minutes
Why the Practice Assignment is after the Graded Assignment 10 minutes
Optional Reading - Categorical Data and Goodness-of-Fit 10 minutes

2 assignments Total 60 minutes

Test Yourself: Categorical Data and Goodness-of-Fit 30 minutes
Categorical Data and Goodness-of-Fit - Practice for the Final Assignment of the Course 30 minutes

In this module, we will explore the statistical tools and techniques that are available when we are comparing and contrasting two sets of data.

What's included

4 videos5 readings2 assignments

4 videos Total 14 minutes

Two sample tests 3 minutes
Two Sample t-test for Means 4 minutes
Paired t-test 3 minutes
Two Sample F-test for Variances 4 minutes

5 readings Total 50 minutes

Download the workbook on Two Sample Tests 10 minutes
Toolbox Summary - Two Sample t Tests 10 minutes
Toolbox Summary - Paired t Tests 10 minutes
Why the Practice Assignment is after the Graded Assignment 10 minutes
Optional Reading - Two Sample Tests 10 minutes

2 assignments Total 60 minutes

Test Yourself: Two Sample Tests 30 minutes
Two Sample Tests - Practice for the Final Assignment of the Course 30 minutes

In this module, we explore the statistical tools and techniques that are available when we have Correlated data sets and when we have a Cause and Effect relationship between two data sets.

What's included

9 videos6 readings3 assignments

9 videos Total 44 minutes

Correlation and Simple Regression Part 1 4 minutes
Correlation and Simple Regression Part 2 3 minutes
Correlation 5 minutes
Simple Regression - Part 1 7 minutes
Simple Regression - Part 2 5 minutes
Simple Regression - Forecasting Part 1 6 minutes
Simple Regression - Forecasting Part 2 4 minutes
Simple Regression - Tests Part 1 5 minutes
Simple Regression - Tests Part 2 7 minutes

6 readings Total 60 minutes

Download the workbooks on Correlation and Simple Regression 10 minutes
Toolbox Summary - Correlation and Regression 10 minutes
Toolbox Summary - Simple Regression 10 minutes
Why the Practice Assignment is after the Graded Assignment 10 minutes
Optional Reading - Correlation and Simple Regression 10 minutes
Summary of Course and Next Steps 10 minutes

3 assignments Total 90 minutes

Test Yourself: Correlation and Simple Regression 30 minutes
Final Assignment: Excel Skills for Statistics and Data Analysis: Intermediate 30 minutes
Correlation and Simple Regression - Practice for the Final Assignment of the Course 30 minutes

The material in this section consists of a series of Toolboxes. While the material covered in these Toolboxes is not necessarily related to Statistics - these Toolboxes will help you expand your tools and techniques in Microsoft Excel. To further your skills in Microsoft Excel in domains beyond Statistics, you may want to consider our other courses and specializations: Excel Skills for Business. Excel Skills for Data Analytics and Visualization, Excel Skills for Business Forecasting