Forecasting and Regression Analysis in Excel
Автор: Edspira
Загружено: 2022-10-24
Просмотров: 16961
This video shows how to forecast the number of daily active users and total revenue for a company. The number of daily active users for Snapchat is predicted using Excel's Forecast Sheet tool. Snapchat's quarterly revenue is then predicted using regression analysis. (Note: performing a regression in Excel requires that the Analysis ToolPak add-in be installed.)
The data set used in the video contains quarterly data on daily active users and revenue for Snapchat going back to the first quarter of 2015. The data set can be obtained by signing up for the email list (link below) or becoming a supporter on Patreon (link below).
0:00 Introduction
0:20 Line Chart
0:57 Sparklines
1:33 Forecast Sheet
3:05 Analysis ToolPak Add-in
3:26 Regression Analysis
5:40 Comparing Predictions
—
Edspira is the creation of Michael McLaughlin, an award-winning professor who went from teenage homelessness to a PhD. Edspira’s mission is to make a high-quality business education freely available to the world.
—
SUBSCRIBE FOR A FREE 53-PAGE GUIDE TO THE FINANCIAL STATEMENTS, PLUS:
• A 23-PAGE GUIDE TO MANAGERIAL ACCOUNTING
• A 44-PAGE GUIDE TO U.S. TAXATION
• A 75-PAGE GUIDE TO FINANCIAL STATEMENT ANALYSIS
• MANY MORE FREE PDF GUIDES AND SPREADSHEETS
http://eepurl.com/dIaa5z
—
SUPPORT EDSPIRA ON PATREON
* / prof_mclaughlin
—
GET CERTIFIED IN FINANCIAL STATEMENT ANALYSIS, IFRS 16, AND ASSET-LIABILITY MANAGEMENT
https://edspira.thinkific.com
—
LISTEN TO THE SCHEME PODCAST
Apple Podcasts: https://podcasts.apple.com/us/podcast...
Spotify: https://open.spotify.com/show/4WaNTqV...
Website: https://www.edspira.com/podcast-2/
—
GET TAX TIPS ON TIKTOK
/ prof_mclaughlin
—
ACCESS INDEX OF VIDEOS
https://www.edspira.com/index
—
CONNECT WITH EDSPIRA
Facebook: / edspira
Instagram: / edspiradotcom
LinkedIn: / edspira
—
CONNECT WITH MICHAEL
Twitter: / prof_mclaughlin
LinkedIn: / prof-michael-mclaughlin
—
ABOUT EDSPIRA AND ITS CREATOR
https://www.edspira.com/about/
https://michaelmclaughlin.com
Доступные форматы для скачивания:
Скачать видео mp4
-
Информация по загрузке: