This course gives participants the tools to be able to run regressions Excel and make forecasts based on those regressions. Starting from scratch, participants get direct practice in gathering business data from publicly traded companies.
***Please download and open all supporting materials before starting the course videos.***
Learning Objectives
- Discover how to gather business data from online sources at no cost
- Discover how to combine datasets into an easy to use format
- Discover how to run regressions based on the data
- Recognize how to interpret the regressions
- Explore how to form forecasts forecasts based on regressions
- Discover how to determine the margin of error around any regression forecast
- Explore how to run scenario analysis and produce output statistics that indicate how confident users of a regression forecast should be.
Last updated/reviewed: March 24, 2024
Included In Certifications
This course is included in the following Certification Programs:
15 CoursesData Analytics Professional (DAP) Certification
- The Fundamentals of Business Intelligence (BI): What it Does and Why it's so Essential
- How is Industry Using Big Data? – A Case Study Reading
- Business Intelligence - Data Collection and Cleaning
- Business Intelligence - Structuring Data for Analysis
- Business Intelligence - Fundamentals of Data Analysis
- Business Intelligence - Using Big Data Analytics
- Doing Data Analytics In Excel (Hands-on module)
- Regressions in Excel (Hands-on module)
- Financial Forecasting
- Advanced Analytics – Omitted Variables
- Advanced Analytics – Fixed Effects
- Case Study in Data Analytics
- Using Regressions for Forecasting
- Financial Forecasting in Excel (Hands-on module)
- Blockchain for Business
39 Reviews (272 ratings)
Prerequisites
Course Complexity: Intermediate
Viewers should be familiar with basic financial and accounting concepts. In addition, viewers should be familiar with Big Data and Business Intelligence, or review my existing courses on the topic. Familiarity with and access to Excel will be helpful.
Education Provider Information
Company:
Illumeo, Inc., 75 East Santa Clara St., Suite 1215, San Jose, CA
95113
Contact:
For more information regarding this course, including complaint and
cancellation policies, please contact our offices at (408) 400- 3993 or send an e-mail to
.
Course Questions and Answers1 Question
There are no questions. Answers to Frequently Asked Questions (FAQs)
Michael McDonaldPresident