This course allows learners to explore Regression Models in order to utilise these models for business forecasting. Unlike Time Series Models, Regression Models are causal models, where we identify certain variables in our business that influence other variables. Regressions model this causality, and then we can use these models in order to forecast, and then plan for our business' needs. We will explore simple regression models, multiple regression models, dummy variable regressions, seasonal variable regressions, as well as autoregressions. Each of these are different forms of regression models, tailored to unique business scenarios, in order to forecast and generate business intelligence for organisations.
이 강좌에 대하여
최근 조회 6,640회
유연한 마감일
일정에 따라 마감일을 재설정합니다.
공유 가능한 수료증
완료 시 수료증 획득
100% 온라인
지금 바로 시작해 나만의 일정에 따라 학습을 진행하세요.
다음 특화 과정의 3개 강좌 중 2번째 강좌:
중급 단계
완료하는 데 약 9시간 필요
영어
자막: 영어
귀하가 습득할 기술
- Microsoft Excel
- Business Forecasting
- regression models
유연한 마감일
일정에 따라 마감일을 재설정합니다.
공유 가능한 수료증
완료 시 수료증 획득
100% 온라인
지금 바로 시작해 나만의 일정에 따라 학습을 진행하세요.
다음 특화 과정의 3개 강좌 중 2번째 강좌:
중급 단계
완료하는 데 약 9시간 필요
영어
자막: 영어
제공자:
맥콰리대학교
Macquarie is ranked among the top one per cent of universities in the world, and with a 5-star QS rating, we are recognised for producing graduates who are among the most sought-after professionals in the world. Since our foundation 54 years ago, we have aspired to be a different type of university: one focused on fostering collaboration between students, academics, industry and society.
강의 계획표 - 이 강좌에서 배울 내용
완료하는 데 1시간 필요
Welcome and Critical Information
완료하는 데 1시간 필요
2개 동영상 (총 2분), 3 개의 읽기 자료
완료하는 데 2시간 필요
Regression Models
In this module, we explore the context and purpose of business forecasting and the three types of business forecasting using regression models. We will learn the theoretical underpinning for a regression model, and understand the relationship between explanatory variables and dependent variables. We will first focus on single variable or simple regression, and learn how to critically evaluate the model using regression diagnostic tools and then use our models for forecasting to suit our organisation's needs.
완료하는 데 2시간 필요
4개 동영상 (총 40분), 3 개의 읽기 자료, 4 개의 테스트
완료하는 데 2시간 필요
Multiple Variable Regression
In this module, we extend the simple regression model to take in multiple explanatory variables. We will extend the theoretical underpinning for a regression model by involving multiple dependent variables. We will learn how to critically evaluate the multiple regression models using regression diagnostic tools and then use our models for forecasting to suit our organisation's needs.
완료하는 데 2시간 필요
4개 동영상 (총 37분), 2 개의 읽기 자료, 4 개의 테스트
완료하는 데 2시간 필요
Dummy Variable Regression
In this module, we extend the multiple regression model to take in qualitative binary explanatory variables. We will extend the theoretical underpinning for a multiple regression model by creating dummy variables for binary qualitative data. We will learn how to critically evaluate the dummy variable regression models using regression diagnostic tools and then use our models for forecasting to suit our organisation's needs.
완료하는 데 2시간 필요
4개 동영상 (총 27분), 2 개의 읽기 자료, 4 개의 테스트
완료하는 데 2시간 필요
Seasonal Dummy Regression
In this module, we extend the binary dummary variable regression model to take in seasonal variables. We will extend the theoretical underpinning for a binary dummy variable regression model by creating a series of dummy variables to capture seasonality. We will learn how to critically evaluate the seasonal dummy regression models using regression diagnostic tools and then use our models for forecasting to suit our organisation's needs.
완료하는 데 2시간 필요
5개 동영상 (총 44분), 2 개의 읽기 자료, 4 개의 테스트
검토
- 5 stars97.72%
- 4 stars2.27%
EXCEL REGRESSION MODELS FOR BUSINESS FORECASTING의 최상위 리뷰
PR 제공2021년 10월 1일
I never new I'd like regression, thanks to Dr Prashan! His skills in teaching is very clear and concise. The lessons are easy to follow. Perfect for beginners.
DD 제공2022년 1월 8일
Learning this course was fantastic, it really improved my knowledge for excel and regression
CM 제공2021년 7월 12일
A step-by-step guide for business forecasting! Very easy to follow and the course brush up my statistics on linear regression as well.
MH 제공2021년 11월 12일
The lecturer did great demonstrating how equation looks like on business application.
Excel Skills for Business Forecasting 특화 과정 정보
The current state of the world makes business forecasting even more fundamental to the operation of institutions. In this Specialization we focus on Excel Skills for Business Forecasting in three courses — Time Series Models, Regression Models, and Judgmental Forecasting.
자주 묻는 질문
강의 및 과제를 언제 이용할 수 있게 되나요?
이 전문 분야를 구독하면 무엇을 이용할 수 있나요?
재정 지원을 받을 수 있나요?
궁금한 점이 더 있으신가요? 학습자 도움말 센터를 방문해 보세요.
