Trend Projections- using the Least Squares Technique + example in Microsoft Excel

  Рет қаралды 3,607

Operations & Supply Chain Management University

Operations & Supply Chain Management University

11 ай бұрын

This video discusses Trend Projections using the Least Squares Technique. The Least Squares technique is a time series forecasting method that uses historical data points and then projects the line into a future forecast. We will learn to calculate the slope (b) and y-intercept (a). We will also go over how to calculate a forecast using Least Squares, and then conclude the video with an example in Microsoft Excel. Content derived from from the Textbook "Operations Management, Sustainability and Supply Chain" 13th edition by Jay Heizer, Barry Render and Chuck Munson. Chapter 4 on Forecasting.
You can get free copies of this slide deck and other chapter outlines on our website at www.operationsuniversity.org

Пікірлер: 6
@shadiadeeq
@shadiadeeq Ай бұрын
thank you you help me so much😊
@OperationsAndSupplyChain
@OperationsAndSupplyChain Ай бұрын
Hi Shadia, happy to help! Thanks for watching!
@kevinjonathan5282
@kevinjonathan5282 2 ай бұрын
you r a good teacher
@OperationsAndSupplyChain
@OperationsAndSupplyChain 2 ай бұрын
Thanks Kevin, I appreciate the positive & kind feedback! Thank you for watching my videos!
@sriavula
@sriavula 4 ай бұрын
my teacher is dogwater so I’m here
@OperationsAndSupplyChain
@OperationsAndSupplyChain 4 ай бұрын
Well that's not good! But I'm glad to have you, and I hope that I can help!
Measuring Forecast Error in Time Series Forecasting using MSE, MAD, and MAPE techniques
25:27
Operations & Supply Chain Management University
Рет қаралды 2,4 М.
Linear Regression & Correlation Analysis used in Forecasting + Example in Microsoft Excel
16:25
Operations & Supply Chain Management University
Рет қаралды 1,1 М.
Nutella bro sis family Challenge 😋
00:31
Mr. Clabik
Рет қаралды 13 МЛН
Я нашел кто меня пранкует!
00:51
Аришнев
Рет қаралды 4,8 МЛН
路飞被小孩吓到了#海贼王#路飞
00:41
路飞与唐舞桐
Рет қаралды 72 МЛН
Forecasting in Excel Tutorial
11:23
Kevin Stratvert
Рет қаралды 280 М.
Using Excel to Do Trend Forecasting
6:10
Stephanie Powers
Рет қаралды 82 М.
Exponential Smoothing in Forecasting
9:56
Mike von Massow
Рет қаралды 45 М.
Exponential Smoothing in Forecasting
7:15
Operations & Supply Chain Management University
Рет қаралды 5 М.
Operations Management using Excel: Seasonality and Trend Forecasting
13:32
Excel@Analytics - Dr. Canbolat
Рет қаралды 412 М.
Learn Statistical Regression in 40 mins! My best video ever. Legit.
40:25
Linear Regression Using Least Squares Method - Line of Best Fit Equation
15:05
The Organic Chemistry Tutor
Рет қаралды 1,3 МЛН
How to calculate a Weighted Moving Average (Quantitative / Time Series Methods of Forecasting)
17:49
Operations & Supply Chain Management University
Рет қаралды 2 М.
Nutella bro sis family Challenge 😋
00:31
Mr. Clabik
Рет қаралды 13 МЛН