More Predictive Analytics: Microsoft Excel

More Predictive Analytics: Microsoft Excel

<p style="margin:0px;"> </p> <div usercontent=""> <p style="margin:0px;"> <b>Accurate, practical Excel predictive analysis: powerful smoothing techniques for serious data crunchers!</b> </p> <p style="margin:0px;"> </p> <p style="margin:0px;">In <i>More Predictive Analytics</i>, 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.</p> <p style="margin:0px;"> </p> <p style="margin:0px;">Carlberg goes beyond his highly-praised <i>Predictive Analytics</i>, 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.”</p> <p style="margin:0px;"> </p> <p style="margin:0px;">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.</p> <p style="margin:0px;"> </p> <p style="margin:0px;">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.</p> <p style="margin:0px;"> </p> <p style="margin:0px;">If you’re ready to make better forecasts for better decision-making, you’re ready for <i>More Predictive Analytics.</i> </p> <ul> <li>Discover when and how to use smoothing instead of regression</li> <li>Test your data for trends and seasonality</li> <li>Compare sets of observations with the autocorrelation function</li> <li>Analyze trended time series with Excel’s Solver and Analysis ToolPak</li> <li>Use Holt's linear exponential smoothing to forecast the next level and trend, and extend forecasts further into the future</li> <li>Initialize your forecasts with a solid baseline</li> <li>Improve your initial forecasts with backcasting and optimization</li> <li>Fully reflect simple or complex seasonal patterns in your forecasts</li> <li>Account for sudden, unexpected changes in trends, from fads to new viral infections</li> <li>Use range names to control complex forecasting models more easily</li> <li>Compare additive and multiplicative models, and use the right model for each task</li> </ul> </div> <p style="margin:0px;"> </p> <p style="margin:0px;"> </p> <p style="margin:0px;"> </p>