Econometrics in Excel for MBA and professionals
What you'll learn
- Identify links in business data using econometric techniques
- Learn how to interpret regression output
- Apply regression analyses in Excel using Analysis ToolPak
- Build and test models for predictive analytics
- Analyze continuous and discrete variables as well as time series data
- Focus on examples and interpretation with a necessary minimum of theory
Requirements
- Basic Excel
Description
There are many great Econometrics courses on Udemy which sell in thousands of copies. However, busy MBA students and professionals might not have sufficient programming experience to run econometric models in Python, R, Stata or Eviews. MS Excel, on the other hand, is a familiar and accessible tool which can be used for advanced data analytics.
In this concise course I have carefully selected the most important econometric tools and techniques that are really needed to understand the complicated relationships that exist in your data. Linear regression is the absolute must for data analysis and Analysis ToolPak is a simple yet powerful feature available in MS Excel. The key concepts used in this course have been distilled based on my experience with many groups of business students that I have taught in three MBA programs and various industries.
Improved English subtitles (not automatically generated)
تحليل البيانات في Excel مع ترجمة باللغة العربية
Datenanalyse in Excel mit Untertiteln in deutscher Sprache
带有简体中文字幕的Excel中的数据分析
हिंदी भाषा में उपशीर्षक के साथ एक्सेल में डेटा विश्लेषण
한국어 자막으로 Excel 데이터 분석
Uchambuzi wa data huko Excel na manukuu kwa lugha ya Kiswahili
Who this course is for:
- pre-MBA students
- MBA students
- Business analysts working in Excel
- Professionals working in data analytics
Course content
- Preview12:10
- 09:22Modelling binary variable and time series
- 07:53First regression with Analysis ToolPak in Excel
- 13:55Interpreting the results of the linear model
- 5 questionsBusiness applications of linear regression
Instructor
![Maksym Obrizan](data:image/svg+xml,%3Csvg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 64 64"%3E%3C/svg%3E){kind=avatar}
- 4.4 Instructor Rating
- 35 Reviews
- 5,514 Students
- 1 Course
I have been teaching for business and professional audience since 2004 and find this experience very rewarding. I have taught for undergraduate, MA and MBA students as well as managers from various industries, government officials, journalists and even coal miners!
Managers and professionals usually do not have as much time as students, hence, I make my courses concise with focus on business applications rather than theory.
After obtaining PhD in Economics from the University of Iowa (2010) I have been Assistant and then Associate Professor at KSE. I have also consulted companies on data analytics in energy and FMCG sectors and participated in projects with USAID, World Bank, EBRD, the Economist Intelligence Unit. Finally, I am the author of 17 publications at SCOPUS.