When will I have access to the lectures and assignments?

To access the course materials, assignments and to earn a Certificate, you will need to purchase the Certificate experience when you enroll in a course. You can try a Free Trial instead, or apply for Financial Aid. The course may offer 'Full Course, No Certificate' instead. This option lets you see all course materials, submit required assessments, and get a final grade. This also means that you will not be able to purchase a Certificate experience.

What will I get if I subscribe to this Specialization?

When you enroll in the course, you get access to all of the courses in the Specialization, and you earn a certificate when you complete the work. Your electronic Certificate will be added to your Accomplishments page - from there, you can print your Certificate or add it to your LinkedIn profile.

Is financial aid available?

Yes. In select learning programs, you can apply for financial aid or a scholarship if you can’t afford the enrollment fee. If fin aid or scholarship is available for your learning program selection, you’ll find a link to apply on the description page.

Statistics and Data Analysis with Excel: Intermediate

Sparen Sie mit 40% Rabatt auf 3 Monate Coursera Plus bei den Fähigkeiten, die Sie zum Strahlen bringen. Jetzt sparen

kurs ist nicht verfügbar in Deutsch (Deutschland)

Wir übersetzen es in weitere Sprachen. Sehen Sie sich die Sprachen an, die wir anbieten.

Statistics and Data Analysis with Excel: Intermediate

Dieser Kurs ist Teil von Spezialisierung „Statistics and Data Analysis with Excel“

Unterrichtet in Deutsch (KI-Synchronisation)

Dozent: Assoc Prof Prashan S. M. Karunaratne

3.925 bereits angemeldet

Bei enthalten

Mehr erfahren

5 Module

Verschaffen Sie sich einen Einblick in ein Thema und lernen Sie die Grundlagen.

21 Bewertungen

Stufe Mittel

Empfohlene Erfahrung

1 Woche zu vervollständigen

unter 10 Stunden pro Woche

Flexibler Zeitplan

In Ihrem eigenen Lerntempo lernen

5 Module

Verschaffen Sie sich einen Einblick in ein Thema und lernen Sie die Grundlagen.

21 Bewertungen

Stufe Mittel

Empfohlene Erfahrung

1 Woche zu vervollständigen

unter 10 Stunden pro Woche

Flexibler Zeitplan

In Ihrem eigenen Lerntempo lernen

Was Sie lernen werden

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.

Kompetenzen, die Sie erwerben

Kategorie: Statistical Analysis
Kategorie: Statistics
Kategorie: Data Literacy
Kategorie: Statistical Methods
Kategorie: Data Analysis
Kategorie: Pivot Tables And Charts
Kategorie: Regression Analysis
Kategorie: Spreadsheet Software
Kategorie: Statistical Inference
Kategorie: Statistical Hypothesis Testing
Kategorie: Data Presentation
Kategorie: Data Visualization Software
Kategorie: Excel Formulas
Kategorie: Correlation Analysis
Kategorie: Interactive Data Visualization
Kategorie: Data Visualization
Kategorie: Sampling (Statistics)
Kategorie: Probability & Statistics

Werkzeuge, die Sie lernen werden

Kategorie: Statistical Software
Kategorie: Microsoft Excel

Wichtige Details

Zertifikat zur Vorlage

Zu Ihrem LinkedIn-Profil hinzufügen

Bewertungen

9 Aufgaben

Unterrichtet in Deutsch (KI-Synchronisation)

91%

of learners achieved a positive career outcome

Erfahren Sie, wie Mitarbeiter führender Unternehmen gefragte Kompetenzen erwerben.

Weitere Informationen zu Coursera für Unternehmen

Logos von Petrobras, TATA, Danone, Capgemini, P&G und L'Oreal

Erweitern Sie Ihre Fachkenntnisse

Dieser Kurs ist Teil der Spezialisierung Spezialisierung „Statistics and Data Analysis with Excel“

Wenn Sie sich für diesen Kurs anmelden, werden Sie auch für diese Spezialisierung angemeldet.

Lernen Sie neue Konzepte von Branchenexperten
Gewinnen Sie ein Grundverständnis bestimmter Themen oder Tools
Erwerben Sie berufsrelevante Kompetenzen durch praktische Projekte
Erwerben Sie ein Berufszertifikat zur Vorlage

In diesem Kurs gibt es 5 Module

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.

Moduldetails

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.

Das ist alles enthalten

8 Videos7 Lektüren2 Aufgaben

8 VideosInsgesamt 35 Minuten

Welcome to Statistics and Data Analysis with Excel: Intermediate2 Minuten
Introduction to Pivot Tables and Pivot Charts1 Minute
PivotTables - Part 15 Minuten
PivotTables - Part 26 Minuten
Customising Pivot Tables - Part 15 Minuten
Customising Pivot Tables - Part 26 Minuten
Pivot Charts - Part 14 Minuten
Pivot Charts - Part 27 Minuten

7 LektürenInsgesamt 70 Minuten

Course Overview10 Minuten
Your Learning Path - How the course is structured10 Minuten
Download the workbooks on Pivot Tables and Pivot Charts10 Minuten
Toolbox Summary - Pivot Tables & Pivot Charts Part 110 Minuten
Toolbox Summary - Pivot Tables & Pivot Charts Part 210 Minuten
Why the Practice Assignment is after the Graded Assignment10 Minuten
Optional Reading - Pivot Tables and Pivot Charts10 Minuten

2 AufgabenInsgesamt 60 Minuten

Test Yourself: Pivot Tables and Pivot Charts30 Minuten
Pivot Tables and Pivot Charts - Practice for the Final Assignment of the Course30 Minuten

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.

Das ist alles enthalten

3 Videos4 Lektüren2 Aufgaben

3 VideosInsgesamt 14 Minuten

Categorical Data and Goodness-of-Fit3 Minuten
Goodness-of-Fit7 Minuten
The Chi-Square Test4 Minuten

4 LektürenInsgesamt 40 Minuten

Download the workbook on Categorical Data and Goodness-of-Fit10 Minuten
Toolbox Summary - Categorical Data and Chi Square Tests10 Minuten
Why the Practice Assignment is after the Graded Assignment10 Minuten
Optional Reading - Categorical Data and Goodness-of-Fit10 Minuten

2 AufgabenInsgesamt 60 Minuten

Test Yourself: Categorical Data and Goodness-of-Fit30 Minuten
Categorical Data and Goodness-of-Fit - Practice for the Final Assignment of the Course30 Minuten

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

Das ist alles enthalten

4 Videos5 Lektüren2 Aufgaben

4 VideosInsgesamt 14 Minuten

Two sample tests3 Minuten
Two Sample t-test for Means4 Minuten
Paired t-test3 Minuten
Two Sample F-test for Variances4 Minuten

5 LektürenInsgesamt 50 Minuten

Download the workbook on Two Sample Tests10 Minuten
Toolbox Summary - Two Sample t Tests10 Minuten
Toolbox Summary - Paired t Tests10 Minuten
Why the Practice Assignment is after the Graded Assignment10 Minuten
Optional Reading - Two Sample Tests10 Minuten

2 AufgabenInsgesamt 60 Minuten

Test Yourself: Two Sample Tests30 Minuten
Two Sample Tests - Practice for the Final Assignment of the Course30 Minuten

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.

Das ist alles enthalten

9 Videos6 Lektüren3 Aufgaben

9 VideosInsgesamt 44 Minuten

Correlation and Simple Regression Part 14 Minuten
Correlation and Simple Regression Part 23 Minuten
Correlation5 Minuten
Simple Regression - Part 17 Minuten
Simple Regression - Part 25 Minuten
Simple Regression - Forecasting Part 16 Minuten
Simple Regression - Forecasting Part 24 Minuten
Simple Regression - Tests Part 15 Minuten
Simple Regression - Tests Part 27 Minuten

6 LektürenInsgesamt 60 Minuten

Download the workbooks on Correlation and Simple Regression10 Minuten
Toolbox Summary - Correlation and Regression10 Minuten
Toolbox Summary - Simple Regression10 Minuten
Why the Practice Assignment is after the Graded Assignment10 Minuten
Optional Reading - Correlation and Simple Regression10 Minuten
Summary of Course and Next Steps10 Minuten

3 AufgabenInsgesamt 90 Minuten

Test Yourself: Correlation and Simple Regression30 Minuten
Final Assignment: Excel Skills for Statistics and Data Analysis: Intermediate30 Minuten
Correlation and Simple Regression - Practice for the Final Assignment of the Course30 Minuten

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