К содержимому
learnspaceYOUR NEXT CHAPTER
ПРОСТРАНСТВО ОБУЧЕНИЯ
ГлавнаяКаталог курсовМоё обучениеCoursera

Знания без границ

Учитесь у лучших университетов и компаний мира.

Открыть Coursera
Интеграция
Пространство университета
Моё пространствоСтраница курса
↵
ЯЛичный кабинетСтудент
© 2026 LearnSpaceКаждый день — возможность узнать больше.Помощь
Statistics and Data Analysis with Excel: Intermediate · LearnSpace
Назад в каталог
courseraАнализ данных

Statistics and Data Analysis with Excel: Intermediate

Курс от Macquarie University
Средний≈ 11.5 чАнглийский
О курсеНавыкиПрограммаПреподаватели

О курсе

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. Each module includes downloadable workbooks, toolbox summaries, applied dialogue activities, and both practice and graded assessments, building to a comprehensive final assignment. Who this is for: Data analysts, business professionals, and researchers who have completed the Essentials course — or equivalent statistics experience — and are ready to apply more advanced analytical methods. 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.

Навыки, которые вы освоите

Statistical Hypothesis TestingPivot Tables And ChartsRegression AnalysisCorrelation AnalysisData AnalysisStatistical AnalysisDescriptive StatisticsExcel FormulasSpreadsheet SoftwareSampling (Statistics)Data VisualizationStatistical MethodsStatisticsData Analysis SoftwareData PresentationVariance AnalysisPredictive ModelingData Visualization SoftwareStatistical InferenceMicrosoft Excel

Программа курса

5 модулей · 64 учебных материалов

01Pivot Tables and Pivot Charts18 материалов

Welcome and Critical Information

Welcome to Statistics and Data Analysis with Excel: IntermediateВидеоCourse OverviewЧтениеYour Learning Path - How the course is structuredЧтение

Pivot Tables and Pivot Charts

Introduction to Pivot Tables and Pivot ChartsВидео

Учитесь у экспертов

Assoc Prof Prashan S. M. Karunaratne

Associate Professor - Teaching & Leadership | SFHEA

Statistics and Data Analysis with Excel: Intermediate
В каталоге вашей программы

Инвестируйте в себя

Новые знания — в удобное для вас время.

Начать на Coursera

Обучение откроется на Coursera
в новой вкладке

Обучение на Coursera

≈ 11.5 ч

5 модулей

Язык: Английский

Субтитры: Арабский, Узбекский, Казахский, Венгерский

Часть программы вашего университета
Download the workbooks on Pivot Tables and Pivot ChartsЧтение
PivotTables - Part 1Видео
PivotTables - Part 2Видео
Customising Pivot Tables - Part 1Видео
Practice: Design PivotTables for Different StakeholdersDIALOGUE
Customising Pivot Tables - Part 2Видео
Pivot Charts - Part 1Видео
Toolbox Summary - Pivot Tables & Pivot Charts Part 1Чтение
Pivot Charts - Part 2Видео
Toolbox Summary - Pivot Tables & Pivot Charts Part 2Чтение
Why the Practice Assignment is after the Graded AssignmentЧтение
Test Yourself: Pivot Tables and Pivot ChartsЗадание
Pivot Tables and Pivot Charts - Practice for the Final Assignment of the CourseЗадание
Optional Reading - Pivot Tables and Pivot ChartsЧтение
02Categorical Data and Goodness-of-Fit9 материалов
Download the workbook on Categorical Data and Goodness-of-FitЧтениеCategorical Data and Goodness-of-FitВидеоGoodness-of-FitВидеоThe Chi-Square TestВидеоToolbox Summary - Categorical Data and Chi Square TestsЧтениеWhy the Practice Assignment is after the Graded AssignmentЧтениеTest Yourself: Categorical Data and Goodness-of-FitЗаданиеCategorical Data and Goodness-of-Fit - Practice for the Final Assignment of the CourseЗаданиеOptional Reading - Categorical Data and Goodness-of-FitЧтение
03Two Sample Tests11 материалов
Two sample testsВидеоDownload the workbook on Two Sample TestsЧтениеTwo Sample t-test for MeansВидеоPaired t-testВидеоTwo Sample F-test for VariancesВидеоToolbox Summary - Two Sample t TestsЧтениеToolbox Summary - Paired t TestsЧтениеWhy the Practice Assignment is after the Graded AssignmentЧтениеTest Yourself: Two Sample TestsЗаданиеTwo Sample Tests - Practice for the Final Assignment of the CourseЗаданиеOptional Reading - Two Sample TestsЧтение
04Correlation and Simple Regression18 материалов

Correlation and Simple Regression

Correlation and Simple Regression Part 1ВидеоCorrelation and Simple Regression Part 2ВидеоDownload the workbooks on Correlation and Simple RegressionЧтениеCorrelationВидеоSimple Regression - Part 1ВидеоSimple Regression - Part 2ВидеоSimple Regression - Forecasting Part 1ВидеоSimple Regression - Forecasting Part 2ВидеоSimple Regression - Tests Part 1ВидеоSimple Regression - Tests Part 2ВидеоToolbox Summary - Correlation and RegressionЧтениеToolbox Summary - Simple RegressionЧтениеWhy the Practice Assignment is after the Graded AssignmentЧтениеTest Yourself: Correlation and Simple RegressionЗаданиеCorrelation and Simple Regression - Practice for the Final Assignment of the CourseЗаданиеOptional Reading - Correlation and Simple RegressionЧтение

Course wrap up - Bringing it all together in one Final Assignment

Final Assignment: Excel Skills for Statistics and Data Analysis: IntermediateЗаданиеSummary of Course and Next StepsЧтение
05Optional - Additional Excel Content to enhance your Excel Skills8 материалов
Optional Material - Excel Skills beyond StatisticsЧтениеChartingЧтениеData CleaningЧтениеVisualisation ToolsЧтениеNamed RangesЧтениеTablesЧтениеLogical and Lookup FunctionsЧтениеDashboardsЧтение