Dates and location
Hours
Dates and location
Hours
Description
Do you know the strength of relationship between your sales and marketing spend?
How much extra Y do you get for one extra unit X? What is the trend and how confident are you of the forecast? This one-hour course will show you how to use Excel to generate comprehensive statistical analysis and create predictive analytics for causal analysis, forecasting an effect, and trend forecasting.
Unlock learning anytime, anywhere with the Blackboard Learn app
Seamlessly access your on demand courses, assignments, and get PD hours on the go. Learn how to download now and elevate your education experience with the convenience of mobile learning.
Key Takeaways
By the end of the course, you will be able to:
- Discover how to use descriptive statistics.
- Generate a comprehensive statistical analysis.
- Understand the basics of linear regression analysis.
- Learn how to use regression analysis to create a predictive model.
- Build multiple predicted forecasts using the SUMPRODUCT function.
- Understand the difference between correlation and causation.
Who Will Benefit
Business professionals looking to incorporate predictive analytics into their forecasting processes.
How to Access The Course
This is an online session. This course is available 24 hours a day, 7 days a week. Once registered, you can access the material at any time.
However, you will only have access to the course for 90 days after REGISTRATION.
New mobile learning! Download Blackboard Learn from your app store (iOS or Android). Learn more.
To access the course on your computer please visit our BlackBoard site, and log-in using the same login and password used for the Registration Portal.
Please allow up to 15 minutes after registration for the course to appear on your BlackBoard page.
Registration, cancellation, withdrawal and all other CPA Ontario PD policies can be found here.
Speaker(s)
David Elsner is the President of DHE Consulting, providing training, consulting, and analytical solutions to organizations. He specializes in solution implementation, guiding businesses to make use of their data assets, and developing cost-saving strategies. David provides analytical and professional classes to clients including the Rotman School of Management and CPA Ontario.