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

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

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

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

Introduction to Predictive Modeling

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

О курсе

Welcome to Introduction to Predictive Modeling, the first course in the University of Minnesota’s Analytics for Decision Making specialization. This course will introduce to you the concepts, processes, and applications of predictive modeling, with a focus on linear regression and time series forecasting models and their practical use in Microsoft Excel. By the end of the course, you will be able to: - Understand the concepts, processes, and applications of predictive modeling. - Understand the structure of and intuition behind linear regression models. - Be able to fit simple and multiple linear regression models to data, interpret the results, evaluate the goodness of fit, and use fitted models to make predictions. - Understand the problem of overfitting and underfitting and be able to conduct simple model selection. - Understand the concepts, processes, and applications of time series forecasting as a special type of predictive modeling. - Be able to fit several time-series-forecasting models (e.g., exponential smoothing and Holt-Winter’s method) in Excel, evaluate the goodness of fit, and use fitted models to make forecasts. - Understand different types of data and how they may be used in predictive models. - Use Excel to prepare data for predictive modeling, including exploring data patterns, transforming data, and dealing with missing values. This is an introductory course to predictive modeling. The course provides a combination of conceptual and hands-on learning. During the course, we will provide you opportunities to practice predictive modeling techniques on real-world datasets using Excel. To succeed in this course, you should know basic math (the concept of functions, variables, and basic math notations such as summation and indices) and basic statistics (correlation, sample mean, standard deviation, and variance). This course does not require a background in programming, but you should be familiar with basic Excel operations (e.g., basic formulas and charting). For the best experience, you should have a recent version of Microsoft Excel installed on your computer (e.g., Excel 2013, 2016, 2019, or Office 365).

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

Regression AnalysisMicrosoft ExcelPredictive ModelingData PreprocessingExcel FormulasTime Series Analysis and ForecastingData ManipulationForecastingPivot Tables And ChartsModel TrainingSpreadsheet SoftwareModel EvaluationFeature EngineeringData CleansingData TransformationModel OptimizationPredictive AnalyticsStatistical MethodsStatistical Modeling

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

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

01Week/Module 1: Simple Linear Regression15 материалов

Course Overview: An Introduction to Predictive Modeling

Analytics for Decision Making SpecializationВидеоPersonal IntroductionВидеоCourse OverviewВидео

Week 1 Lesson 1: An Introduction to Linear Regression

Week/Module 1 Overview: What You Will Learn This WeekВидео

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

De Liu

Professor

Introduction to Predictive Modeling
В каталоге вашей программы

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

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

Начать на Coursera

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

Обучение на Coursera

≈ 12.4 ч

4 модулей

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

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

Часть программы вашего университета
Introduction to Predictive ModelingВидео
Introduction to Linear RegressionВидео
Practice Quiz: Introduction to Linear RegressionЗадание
Read this article on Applications of Predictive AnalyticsЧтение
Applications of Predictive AnalyticsОбсуждение

Week 1 Lesson 2: Understand the Mechanics of a Regression Model

Understanding the Mechanics of a Regression ModelВидеоPractice Quiz: Understanding the Mechanics of a Regression ModelЗадание

Week 1 Lesson 3: Using Excel to Conduct Linear Regression

Using Excel to Conduct Linear RegressionВидео

Week 1 Lesson 4: Using Linear Regression for Prediction

Using Linear Regression for PredictionВидеоPractice Quiz on Using Excel to Conduct Linear RegressionЗадание

Week 1 Graded Quiz

Week 1 Graded Quiz: Understanding Linear RegressionЗадание
02Week/Module 2: Multiple Linear Regression13 материалов

Lesson 1: Introduction to Multiple Regression

Week 2 Overview on Multiple Linear RegressionВидеоWhat is Multiple Linear Regression?ВидеоUnderstand Model Fit and Prediction using Multiple RegressionВидеоPractice Quiz on an "Introduction to Multiple Linear Regression"Задание

Lesson 2: Model Fit and Interpretation

Fitting and Interpreting Multiple Regression Models using Regression ToolВидеоMaking Predictions using the Regression ToolВидеоMaking Predictions using the Trend function ВидеоPractice Quiz on "Model Fit and Interpretation"Задание

Lesson 3: Model Selection

Building Good Regression ModelsВидеоA Demonstration of Backward EliminationВидеоPractice Quiz on "Model Selection"ЗаданиеReading more on model specification and overfittingЧтение

Week 2 Wrap Up

Module 2 Graded Quiz on Multiple Linear RegressionЗадание
03Week/Module 3: Data Preparation20 материалов

Lesson 1: Introduction to Data Preparation

Week 3 Overview: Preparing Your DataВидеоWhy Is Data Preparation Important?ВидеоWorking with Different Types of VariablesВидеоHandling Different Types of VariablesВидеоYour Experiences with Data PreparationОбсуждениеPractice Quiz on "Introduction to Data Preparation"Задание

Lesson 2: Working with String Variables

Using Excel Pivot Table to Explore Column ValuesВидеоUsing Excel VLOOKUP to Encode Ordinal VariablesВидеоUsing Excel IF function to Encode Nominal VariablesВидеоOther Uses of VLOOKUP and IF functionsВидеоPractice Quiz on "String Variables"Задание

Lesson 3: Working with Date/Time Variables

Handling Data/Time VariablesВидеоExcel Demonstration of Handling Data/Time VariablesВидеоPractice Quiz on "Date/Time Variables"Задание

Lesson 4: Working with High-Order and Interaction Variables

Handling High Order, Interaction VariablesВидеоInteraction VariablesВидеоPractice Quiz on "High-Order and Interaction Variables"Задание

Lesson 5: Handling Missing Values

Handling Missing Values & Module SummaryВидеоPractice Quiz on "Handling Missing Values"Задание

Week 3 Wrap Up

Module 3 Graded Quiz on "Preparing Your Data""Задание
04Week/Module 4: Time Series Forecasting28 материалов

Week 4 Lesson 1: An Introduction to Time Series Forecasting

Week 4 Overview: Time Series ForecastingВидеоTime Series Data and Time Series ForecastingВидеоComponents of Time SeriesВидеоModel Accuracy MetricsВидеоPractice Quiz an "Introduction to Time Series Forecasting"ЗаданиеApplications of Time Series ForecastingОбсуждение

Week 4 Lesson 2: Models for Stationary Data

Moving AveragesВидеоHow to Forecast using the Moving Averages ModelВидеоThe Exponential Smoothing ModelВидеоDemonstration of Exponential SmoothingВидеоPractice Quiz on "Models for Stationary Data"Задание

Week 4 Lesson 3: Time Series with Trends

Double Moving AveragesВидеоDemonstration of Double Moving AveragesВидеоDouble Exponential Smoothing (Holt's Method)ВидеоPractice Quiz on Time Series with TrendsЗадание

Week 4 Lesson 4: Time Series with Trends and Seasonality

Holt-Winters' Additive ModelВидеоA Demonstration of Holt-Winters' Additive ModelВидеоHolt-Winters' Multiplicative ModelВидеоPractice Quiz on "Time Series with Trends and Seasonality"Задание

Week 4 Lesson 5: Forecasting using Regression and Composite Models

Time Series RegressionВидеоComposite ForecastВидеоPractice Quiz on "Forecasting using Regression and Composite Models"Задание

Week 4 Wrap Up

Week 4 Graded Quiz on "Time Series Forecasting"ЗаданиеCourse Wrap Up: A Summary of What You Have Learned in this CourseВидеоCongratulations on Finishing "Introduction to Predictive Modeling"!Видео

OPTIONAL Lesson: MSBA Program

Carlson School of Management: Master of Science Program in Business Analytics (MSBA)ВидеоCarlson School of Management: MSBA Program WebsiteЧтениеManagement Information Systems (MIS) Research CenterЧтение