Excel: Economic Analysis and Data Analytics

Focused View

2:17:07

171 View

01 - Introduction

01 - Economic forecasting.mp4

01:02

02 - What you should know before watching this course.mp4

01:23

03 - Using the exercise files.mp4

00:49

02 - 1. The Basics

01 - Basics of economic analysis.mp4

02:11

02 - Sources of economic data.mp4

01:58

03 - Economic forecasting methods.mp4

03:57

04 - Regression analysis in economics.mp4

04:52

05 - Predicting values with regressions.mp4

03:56

06 - Economic forecasting in the research literature.mp4

05:51

03 - 2. Economic Data Analysis

01 - Trend analysis in forecasting.mp4

07:52

02 - Serial correlation in data.mp4

07:10

03 - Analyzing results.mp4

09:15

04 - 3. Forecasting Economic Trends

01 - Advanced forecasting methods.mp4

03:08

02 - Binomial regressions.mp4

02:23

03 - Fixed effects regressions.mp4

07:48

04 - Difference in differences analysis.mp4

05:32

05 - Stata and economic forecasting.mp4

04:56

06 - Interpreting Stata results.mp4

05:44

05 - 4. Using Economic Forecasts

01 - What do the results mean.mp4

11:50

02 - Testing accuracy in economic forecasts.mp4

08:44

03 - Scenario analysis in economics.mp4

07:25

06 - 5. Economic Data

01 - Common economic variables.mp4

09:08

02 - Lead and lag relationships.mp4

05:57

03 - Seasonality and data cleaning.mp4

06:51

04 - Interpreting other's economic forecasts.mp4

06:12

07 - Conclusion

01 - Projects to try next.mp4

01:13

Description

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.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

Excel

Excel Analytics

Linkedin Learning

View courses Linkedin Learning

LinkedIn Learning is an American online learning provider. It provides video courses taught by industry experts in software, creative, and business skills. It is a subsidiary of LinkedIn. All the courses on LinkedIn fall into four categories: Business, Creative, Technology and Certifications. It was founded in 1995 by Lynda Weinman as Lynda.com before being acquired by LinkedIn in 2015. Microsoft acquired LinkedIn in December 2016.