Que Publishing, 2015. — 336 p. — ISBN-10: 0-7897-5614-5, ISBN-13: 978-0-7897-5614-5.
Accurate, practical Excel predictive analysis: powerful smoothing techniques for serious data crunchers!In More Predictive Analytics, Microsoft Excel® MVP Conrad Carlberg shows how to use intuitive smoothing techniques to make remarkably accurate predictions. You won’t have to write a line of code-all you need is Excel and this all-new, crystal-clear tutorial.Carlberg goes beyond his highly-praised Predictive Analytics, introducing proven methods for creating more specific, actionable forecasts. You’ll learn how to predict what customers will spend on a given product next year… project how many patients your hospital will admit next quarter… tease out the effects of seasonality (or patterns that recur over a day, year, or any other period)… distinguish real trends from mere noise.Drawing on more than 20 years of experience, Carlberg helps you master powerful techniques such as autocorrelation, differencing, Holt-Winters, backcasting, polynomial regression, exponential smoothing, and multiplicative modeling.Step by step, you’ll learn how to make the most of built-in Excel tools to gain far deeper insights from your data. To help you get better results faster, Carlberg provides downloadable Excel workbooks you can easily adapt for your own projects.If you’re ready to make better forecasts for better decision-making, you’re ready for More Predictive Analytics.Discover when and how to use smoothing instead of regression. Test your data for trends and seasonality. Compare sets of observations with the autocorrelation function. Analyze trended time series with Excel’s Solver and Analysis ToolPak. Use Holt's linear exponential smoothing to forecast the next level and trend, and extend forecasts further into the future. Initialize your forecasts with a solid baseline. Improve your initial forecasts with backcasting and optimization. Fully reflect simple or complex seasonal patterns in your forecasts. Account for sudden, unexpected changes in trends, from fads to new viral infections. Use range names to control complex forecasting models more easily. Compare additive and multiplicative models, and use the right model for each task.
Чтобы скачать этот файл зарегистрируйтесь и/или войдите на сайт используя форму сверху.
Wiley, 2014. — 456 p. — ISBN: 9781118727966
Predictive analytics is what translates big data into meaningful, usable business information. Written by a leading expert in the field, this guide examines the science of the underlying algorithms as well as the principles and best practices that govern the art of predictive analytics. It clearly explains the theory behind predictive...
Wiley, 2014. — 344 p. — ISBN: 9781118728963, 1118728963, 9781118729410, 9781118729205
Predict the future! This practical guide will help you use Big Data and technology to discover real-world insights, define projects, and help you create goals.
Getting started with predictive analytics. Entering the arena ; Predictive analytics in the wild ;...
Que Publishing, 2015. — 336 p. — ISBN: 0-7897-5614-5 Only sample files Accurate, practical Excel predictive analysis: powerful smoothing techniques for serious data crunchers! In More Predictive Analytics, Microsoft Excel MVP Conrad Carlberg shows how to use intuitive smoothing techniques to make remarkably accurate predictions. You won’t have to write a line of code-all you need...
Que Publishing – 2012, 304 pages
ISBN: 0789749416, 9780789749413
Predictive Analytics: Microsoft® Excel
Excel predictive analytics for serious data crunchers!
The movie Moneyball made predictive analytics famous: Now you can apply the same techniques to help your business win. You don’t need multimillion-dollar software: All the tools you need are available in Microsoft...
Wiley, 2012. — 2100 p. — ISBN: 1118006739, 9781118006733
3 Volume Set.
An essential reference dedicated to a wide array of financial models, issues in financial modeling, and mathematical and statistical tools for financial modeling
The need for serious coverage of financial modeling has never been greater, especially with the size, diversity, and efficiency of modern capital...
Wiley, 2008. – 1033 p. – ISBN: 047017921X, 9780470179215
If you’re seeking solutions to advanced and even esoteric problems, Advanced Analytical Models goes beyond theoretical discussions of modeling by facilitating a thorough understanding of concepts and their real-world applications—including the use of embedded functions and algorithms. This reliable resource will equip you...