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

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

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

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

Statistics and Data Analysis with Excel, Part 1

Курс от University of Colorado Boulder
Начальный≈ 16.5 чАнглийский
О курсеНавыкиПрограммаПреподаватели

О курсе

Designed for students with no prior statistics knowledge, this course will provide a foundation for further study in data science, data analytics, or machine learning. Topics include descriptive statistics, probability, and discrete and continuous probability distributions. Assignments are conducted in Microsoft Excel (Windows or Mac versions). Designed to be taken with the follow-up courses, “Statistics and Data Analysis with Excel, Part 2" and "Statistics and Data Analysis with R". All three courses make up the specialization "Statistics and Applied Data Analysis."

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

Probability DistributionProbabilityStatisticsBox PlotsData TransformationDescriptive StatisticsData CleansingHistogramStatistical VisualizationProbability & StatisticsStatistical MethodsData AnalysisMicrosoft ExcelScatter PlotsExcel FormulasBayesian StatisticsSpreadsheet Software

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

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

01WELCOME!12 материалов

Introduction and General Course Information

Course Updates and Accessibility SupportЧтениеWelcome to the Course!ВидеоHow the Course WorksВидеоThe Importance of a Course Certificate and the Future of Higher EducationЧтение

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

Charlie Nuttelman

Teaching Professor

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

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

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

Начать на Coursera

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

Обучение на Coursera

≈ 16.5 ч

5 модулей

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

Субтитры: Арабский, Французский, Узбекский, Итальянский, Бразильский португальский, Корейский, Немецкий, Испанский, Японский, Казахский, Венгерский

Часть программы вашего университета
Do Your Excel Skills Need Work?Чтение
What Version of Excel Do You Need for This Course?Чтение
Is It "Data Are" or "Data Is"?Чтение
What About You?Обсуждение

Statistics and Data Analysis: An Introduction

Introduction to StatisticsВидео

Reinforce Your Learning

Week 1 Graded QuizЗаданиеUnlock Quiz for Week 2 FilesЗаданиеWeek 2 Excel FilesЧтение
02Descriptive Statistics and Graphical Representation of Data24 материалов

Week 2 Cheat Sheet

Week 2 Cheat SheetЧтение

Descriptive Statistics

Difference Between Population and SampleВидеоWhat is the Summation Symbol?ВидеоDescriptive StatisticsВидеоQuartiles and PercentilesВидео

Graphical Presentation of Data

Univariate vs. Bivariate DataВидеоCategorical vs. Numerical DataВидеоHistogramsВидеоScatter Plots in Excel, Part 1ВидеоScatter Plots in Excel, Part 2ВидеоColumn and Pie Charts in ExcelВидеоTime Series PlotsВидеоBox PlotsВидео

Preparing Data, Robust Estimators, and Removing Outliers

Cleaning Data in ExcelВидеоData TransformationsВидеоRobust EstimatorsВидеоRemoving OutliersВидео

Reinforce Your Learning

(OPTIONAL) Week 2 DiscussionОбсуждениеGuided Workshop 2ЧтениеGuided Workshop 2: Creating a Histogram in ExcelВидеоGuided Workshop 2 SubmissionЗаданиеWeek 2 Practice QuizЗаданиеWeek 2 Graded QuizЗаданиеWeek 3 Excel Files
03Probability18 материалов

Week 3 Cheat Sheet

Week 3 Cheat SheetЧтение

Sample Spaces and Counting Techniques

Introduction to Probability: Part 1ВидеоIntroduction to Probability: Part 2ВидеоSample Spaces and EventsВидеоPermutations and CombinationsВидеоHow to Use the PERMUT and COMBIN Functions in ExcelВидео

Conditional Probability

Probability RulesВидеоConditional ProbabilityВидеоMultiplication RuleВидеоTotal Probability RuleВидеоBayes' TheoremВидео

Reinforce Your Learning

(OPTIONAL) Week 3 DiscussionОбсуждениеGuided Workshop 3ЧтениеGuided Workshop 3: Bayes' Theorem and Diagnostic TestingВидеоGuided Workshop 3 SubmissionЗаданиеWeek 3 Practice QuizЗаданиеWeek 3 Graded QuizЗаданиеWeek 4 Excel Files
04Discrete Probability Distributions21 материалов

Week 4 Cheat Sheet

Week 4 Cheat SheetЧтение

Introduction

Introduction to Discrete Probability DistributionsВидеоProbability DistributionsВидеоExcel Functions For Discrete DistributionsЧтение

Bernoulli Processes

The Binomial DistributionВидеоThe Geometric DistributionВидеоThe Negative Binomial DistributionВидеоExcel's NEGBINOM.DIST FunctionВидео

Sampling Without Replacement

The Hypergeometric DistributionВидеоThe Multinomial DistributionВидео

Poisson Process

The Poisson DistributionВидео

Joint and Conditional Probability Distributions

Joint and Marginal Probability DistributionsВидеоConditional Probability DistributionsВидео

Closing the Loop

Closing the LoopВидео

Reinforce Your Learning

(OPTIONAL) Week 4 DiscussionОбсуждениеGuided Workshop 4ЧтениеGuided Workshop 4: Modeling Traffic DataВидеоGuided Workshop 4 SubmissionЗаданиеWeek 4 Practice QuizЗаданиеWeek 4 Graded QuizЗаданиеWeek 5 Excel Files
05Continuous Probability Distributions23 материалов

Week 5 Cheat Sheet

Week 5 Cheat SheetЧтение

Introduction to Continuous Distributions

Introduction to Continuous DistributionsВидеоContinuous Variables and DistributionsВидеоThe Uniform DistributionВидеоExcel Functions For Continuous DistributionsЧтениеThe Normal DistributionВидео

Standardizing

Standardizing and Z-Values, Part 1ВидеоStandardizing and Z-Values, Part 2ВидеоPercentage Points of the Standard Normal Distribution (Table)ЧтениеInverse Normal Distribution CalculationsВидео

Other Continuous Distributions

Exponential DistributionВидеоOther Continuous DistributionsВидеоExample: Beta-PERT DistributionВидео

Probability Plots

Probability PlotsВидеоHow to Use the "Probability plot.xlsx" File Видео

Closing the Loop

Closing the LoopВидео

Reinforce Your Learning

(OPTIONAL) Week 5 DiscussionОбсуждениеGuided Workshop 5ЧтениеGuided Workshop 5: Fitting Data to the Gamma DistributionВидеоGuided Workshop 5 SubmissionЗаданиеWeek 5 Practice QuizЗаданиеWeek 5 Graded QuizЗадание

Final Quiz

Final Graded QuizЗадание
Чтение
Чтение
Чтение