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

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

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

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

Statistical Analysis Fundamentals using Excel

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

О курсе

This course is aimed at familiarizing Data and Business professionals with the basic concepts of statistical analysis and methods used for data-driven decision-making. After completing this course, you will be able to apply descriptive and inferential analysis methods, use data visualization methods to communicate data, apply concepts of probability in real-life scenarios, and apply regression techniques to predict trends. The course takes a hands-on approach to statistical analysis using Microsoft Excel and uses examples to illustrate the concepts to help you gain the foundational knowledge of statistical techniques needed to solve business intelligence (BI) problems. A hands-on project will provide you 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 professionals or students who aspire to embark on a career in the BI or Data Analytics fields by equipping them with the crucial skills and knowledge in statistical analysis. It is expected that learners be familiar with Excel/spreadsheet basics and high school mathematics prior to starting this course.

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

ForecastingProbability DistributionRegression AnalysisData AnalysisStatistical AnalysisDescriptive StatisticsData Visualization SoftwarePredictive ModelingStatistical VisualizationData VisualizationPredictive AnalyticsDescriptive AnalyticsData PresentationBusiness AnalyticsStatistical MethodsStatistical Hypothesis TestingStatisticsSpreadsheet SoftwareMicrosoft ExcelProbability & Statistics

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

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

01Introduction and Descriptive Statistics15 материалов

Welcome

Course IntroductionВидеоCourse OverviewЧтениеHelpful Tips for Course CompletionЧтение

Understanding the Basics of Descriptive Statistics

Welcome to Statistics!Видео

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

Murtaza Haider

Professor of Data science & Real Estate Management

IBM Skills Network Team

Преподаватель курса

Statistical Analysis Fundamentals using Excel
В каталоге вашей программы

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

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

Начать на Coursera

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

Обучение на Coursera

≈ 13.9 ч

5 модулей

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

Субтитры: Арабский, Французский, Узбекский, Украинский, Китайский (Китай), Греческий, Итальянский, Бразильский португальский, Вьетнамский, Нидерландский, Корейский, Немецкий, Пушту, Русский, Тайский, Индонезийский, Шведский, Турецкий, Азербайджанский, Испанский, Дари, Хинди, Японский, Казахский, Венгерский, Польский

Часть программы вашего университета
Types of DataВидео
Measure of Central TendencyВидео
Measures of DispersionВидео
Measures of DispersionЧтение
Hands-on Lab: Getting Started with Excel OnlinePLUGIN
Lab: Measure of DispersionPLUGIN
Lab: Descriptive StatisticsPLUGIN
Summary and Highlights: Introduction and Descriptive StatisticsЧтение

Introduction to Descriptive Statistics labs and assessments

Practice Quiz: Introduction to Descriptive StatisticsЗаданиеGraded Quiz: Introduction to Descriptive StatisticsЗаданиеModule 1 Glossary: Introduction and Descriptive StatisticsPLUGIN
02Data Visualization10 материалов

Charts and Graphs in Statistics

Visualization Fundamentals ВидеоLab: Data Visualization Using Statistical ChartsPLUGINStatistics by GroupsВидеоStatistical ChartsВидеоIntroducing the teacher's rating dataВидеоLab: Data Visualization Using Pivot ChartPLUGINSummary and Highlights: Data VisualizationЧтение

Data Visualization labs and assessments

Practice Quiz: Data VisualizationЗаданиеGraded Quiz: Data VisualizationЗаданиеModule 2 Glossary: Data VisualizationPLUGIN
03Introduction to Probability Distributions13 материалов

Probability Distribution

Random Numbers and Probability DistributionsВидеоState your hypothesisВидеоAlpha (α) and P-valueЧтениеNormal DistributionВидеоLab: Standard Normal DistributionPLUGINT-DistributionВидеоProbability of Getting a High or Low Teaching EvaluationВидеоLab: Probability DistributionPLUGINStandard Normal TableЧтениеSummary and HighlightsЧтение

Introduction to Probability Distribution Labs and Assessments

Practice Quiz: Introduction to Probability DistributionЗаданиеGraded Quiz: Introduction to Probability DistributionЗаданиеModule 3 Glossary: Introduction to Probability DistributionsPLUGIN
04Regression Analysis and Forecasting 15 материалов

Introduction to Regression Analysis

Overview of Regression AnalysisВидеоSimple Linear RegressionВидеоBuilding and Interpreting Simple Linear Regression ModelsВидеоLab: Simple Linear Regression AnalysisPLUGINMultiple Linear RegressionВидеоBuilding and Interpreting Multiple Linear Regression ModelsВидеоLab: Multiple Linear Regression AnalysisPLUGINReading: Difference between Simple and Multiple Linear RegressionPLUGIN(Optional) Assumption and Diagnosis in Regression AnalysisВидеоForecasting with RegressionВидеоApplying Regression Techniques for ForecastingВидеоSummary and HighlightsЧтение

Introduction to Regression Analysis Assessments

Practice Quiz: Introduction to Regression Analysis AssessmentsЗаданиеGraded Quiz: Introduction to Regression Analysis AssessmentsЗаданиеModule 4 Glossary: Regression Analysis and ForecastingPLUGIN
05Analysing Sales Performance and Forecasting 12 материалов

Practice and Final Projects

Reading: About the Course ProjectsPLUGINReading: Practice Project OverviewPLUGINLab: Practice Project GuidePLUGINFinal Project Overview and TasksPLUGINReading: Final Project Submission Guidelines and DeliverablesPLUGINOption 1: AI Graded - Final Project: Submission and EvaluationВнешний инструментOption 2: Peer Graded - Final Project Submission and EvaluationВзаимная проверка

Final Exam

Instructions for the Final ExamЧтениеFinal Exam (Statistics Fundamentals Using Excel)ЗаданиеCourse Glossary: Statistics Fundamentals using ExcelPLUGIN

Course Wrap-up

Congratulations and Next StepЧтениеTeam and AcknowledgmentsЧтение