Predictive Analytics with Excel LiveLessons (Video Training)

EngLish | .FLV | Audio: aac, 44100 Hz, stereo | Video: h264, yuv420p, 1280x720, 30.00 fps | 789MB

Genre: E-Learning

3 Hours of Video Instruction

Overview

In just three hours, discover how to create accurate forecasts and predictions with Microsoft Excel's powerful predictive analytics tools!

Description

Moneyball made predictive analytics famous: now, you can put it to work! In just three hours of expert video, Conrad Carlberg will teach you all the core skills you need to create accurate predictions of your own with Microsoft Excel–hands-on! Learn how to use Excel to design and run the two most basic analyses used in quantitative forecasting: smoothing and regression. Explore the self-correcting nature of exponential smoothing, discover how to use autoregression to create effective forecasts, and get comfortable using Excel's powerful Data Analysis and Solver add-ins. Understand trends in time series, and master differencing, the most important technique for dealing with them. Finally, learn about ACFs and PACFs, and uncover their patterns to identify the best ways to forecast any given time series. These hands-on videos are accompanied by Excel workbooks containing all sample data and analyses: workbooks you can easily replicate and adapt for your own needs!