Excel: Economic Analysis and Data Analytics
Excel: Economic Analysis and Data Analytics
.MP4, AVC, 1280x720, 30 fps | English, AAC, 2 Ch | 2h 26m | 444 MB
Instructor: Michael McDonald
.MP4, AVC, 1280x720, 30 fps | English, AAC, 2 Ch | 2h 26m | 444 MB
Instructor: Michael McDonald
Economics affects us all each day—from issues like inflation to the health of the economy and risk of a recession. In this course, learn how to harness economic data to do economic analysis and forecasting to gain key business insights and analyze market conditions.
Join professor Michael McDonald as he demonstrates how to harness the wealth of information available on the internet to forecast statistics such as industry growth, GDP, and unemployment rates, as well as factors that directly affect your business like property prices, future interest rate hikes, supply chain issues, and more. All you need is the built-in formulas, functions, and calculations of Microsoft Excel. Along the way, get tips on using regression analysis, confidence intervals, and forecasting tools with your company’s key performance indicators (KPIs), building your skill set in data analytics to better meet the needs of your business.
Learning objectives
- Explore the different kinds of economics data.
- Differentiate between forecasting methods.
- Identify the correct regression technique for different data sets.
- Define types of correlation.
- Review the types of variables used in various forms of regression analysis.
- Identify proper Stata techniques.
Excel: Economic Analysis and Data Analytics
