What Does MVP Stand For? It’s Not What You Think.
October 7, 2024
Article
This course is part of Analytics for Decision Making Specialization
Instructor: De Liu
11,879 already enrolled
Included with
(127 reviews)
(127 reviews)
Add to your LinkedIn profile
20 assignments
Add this credential to your LinkedIn profile, resume, or CV
Share it on social media and in your performance review
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).
This module provides a brief overview of predictive modeling problems, illustrating their broad applications. It then focuses on the simplest form of predictive models: simple linear regression. The module follows a graphical approach to illustrate the structure of a simple linear regression model, the intuition for Ordinary Least Squares, and related concepts. Finally, we demonstrate how to use various Excel tools, including trendlines, the Regression tool, and the Trend() function, to fit a simple linear regression model and use it to form predictions.
9 videos1 reading4 assignments1 discussion prompt
Building on Week 1, in this week we introduce multiple linear regression and its broad applications. Then, we cover how to fit a multiple linear regression model using Excel’s Regression tool and Trend() function and use the resulting model for predictions. The module further discusses the overfitting/underfitting problems and the basic principles of a good regression model. The module also introduces one approach for selecting a good model: backward elimination that can be implemented in Excel.
8 videos1 reading4 assignments
In this week, we will learn how to prepare a dataset for predictive modeling and introduce Excel tools that can be leveraged to fulfill this goal. We will discuss different types of variables and how categorical, string, and datetime values may be leveraged in predictive modeling. Furthermore, we will discuss the intuition for including high-order and interaction variables in regression models, the issue of multicollinearity, and how to handle missing values. We will also introduce several handy Excel tools for data handling and exploration, including Pivot Table, IF() function, VLOOKUP function, and relative reference.
13 videos6 assignments1 discussion prompt
This module focuses on a special subset of predictive modeling: time series forecasting. We discuss the nature of time-series data and the structure of time series forecasting problems. We then introduce a host of time series models for stationary data and data with trends and seasonality, with a focus on techniques that are easily implemented within Excel, including moving average, exponential smoothing, double moving average, Holt’s method, and Holt-Winters’ method. The module also covers linear-regression-based forecasting and a composite forecasting technique for boosting accuracy.
19 videos2 readings6 assignments1 discussion prompt
We asked all learners to give feedback on our instructors based on the quality of their teaching style.
The University of Minnesota is among the largest public research universities in the country, offering undergraduate, graduate, and professional students a multitude of opportunities for study and research. Located at the heart of one of the nation’s most vibrant, diverse metropolitan communities, students on the campuses in Minneapolis and St. Paul benefit from extensive partnerships with world-renowned health centers, international corporations, government agencies, and arts, nonprofit, and public service organizations.
University of California San Diego
Course
Illinois Tech
Build toward a degree
Course
Stanford University
Course
Erasmus University Rotterdam
Course
127 reviews
85.15%
12.50%
1.56%
0%
0.78%
Showing 3 of 127
Reviewed on Jul 11, 2023
I really enjoyed how the course was geared towards applying the theory. Very useful practical information and well presented!
Reviewed on Jan 25, 2022
Great course, good topic material and examples and well taught. Overall it was useful and relevant.
Reviewed on Aug 21, 2022
Contents presentation is very good.Given 1 star less due to non inclusion of ARIMA models.
Unlimited access to 10,000+ world-class courses, hands-on projects, and job-ready certificate programs - all included in your subscription
Earn a degree from world-class universities - 100% online
Upskill your employees to excel in the digital economy
Access to lectures and assignments depends on your type of enrollment. If you take a course in audit mode, you will be able to see most course materials for free. To access graded assignments and to earn a Certificate, you will need to purchase the Certificate experience, during or after your audit. If you don't see the audit option:
The course may not offer an audit option. 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.
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. If you only want to read and view the course content, you can audit the course for free.
If you subscribed, you get a 7-day free trial during which you can cancel at no penalty. After that, we don’t give refunds, but you can cancel your subscription at any time. See our full refund policy.
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.
These cookies are necessary for the website to function and cannot be switched off in our systems. They are usually only set in response to actions made by you which amount to a request for services, such as setting your privacy preferences, logging in or filling in forms. You can set your browser to block or alert you about these cookies, but some parts of the site will not then work.
These cookies may be set through our site by our advertising partners. They may be used by those companies to build a profile of your interests and show you relevant adverts on other sites. They are based on uniquely identifying your browser and internet device. If you do not allow these cookies, you will experience less targeted advertising.
These cookies allow us to count visits and traffic sources so we can measure and improve the performance of our site. They help us to know which pages are the most and least popular and see how visitors move around the site. If you do not allow these cookies we will not know when you have visited our site, and will not be able to monitor its performance.
These cookies enable the website to provide enhanced functionality and personalization. They may be set by us or by third party providers whose services we have added to our pages. If you do not allow these cookies then some or all of these services may not function properly.