{"product_id":"9780789756145","title":"More Predictive Analytics: Microsoft Excel","description":"\u003cp\u003e \u003cb\u003eAccurate, practical Excel predictive analysis: powerful smoothing techniques for serious data crunchers!\u003c\/b\u003e \u003c\/p\u003e\u003cp\u003e\u003c\/p\u003e\u003cp\u003eIn \u003ci\u003eMore Predictive Analytics\u003c\/i\u003e, 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.\u003c\/p\u003e\u003cp\u003e\u003c\/p\u003e\u003cp\u003eCarlberg goes beyond his highly-praised \u003ci\u003ePredictive Analytics\u003c\/i\u003e, 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.”\u003c\/p\u003e\u003cp\u003e\u003c\/p\u003e\u003cp\u003eDrawing 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.\u003c\/p\u003e\u003cp\u003e\u003c\/p\u003e\u003cp\u003eStep 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.\u003c\/p\u003e\u003cp\u003e\u003c\/p\u003e\u003cp\u003eIf you’re ready to make better forecasts for better decision-making, you’re ready for \u003ci\u003eMore Predictive Analytics.\u003c\/i\u003e \u003c\/p\u003e\u003cp\u003e \u003c\/p\u003e\u003cul\u003e \u003cli\u003eDiscover when and how to use smoothing instead of regression\u003c\/li\u003e \u003cli\u003eTest your data for trends and seasonality\u003c\/li\u003e \u003cli\u003eCompare sets of observations with the autocorrelation function\u003c\/li\u003e \u003cli\u003eAnalyze trended time series with Excel’s Solver and Analysis ToolPak\u003c\/li\u003e \u003cli\u003eUse Holt's linear exponential smoothing to forecast the next level and trend, and extend forecasts further into the future\u003c\/li\u003e \u003cli\u003eInitialize your forecasts with a solid baseline\u003c\/li\u003e \u003cli\u003eImprove your initial forecasts with backcasting and optimization\u003c\/li\u003e \u003cli\u003eFully reflect simple or complex seasonal patterns in your forecasts\u003c\/li\u003e \u003cli\u003eAccount for sudden, unexpected changes in trends, from fads to new viral infections\u003c\/li\u003e \u003cli\u003eUse range names to control complex forecasting models more easily\u003c\/li\u003e \u003cli\u003eCompare additive and multiplicative models, and use the right model for each task\u003c\/li\u003e \u003c\/ul\u003e","brand":"Que","offers":[{"title":"Default Title","offer_id":47029686468848,"sku":"9780789756145","price":39.99,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0737\/7593\/9824\/files\/9780789756145_p0.jpg?v=1763728162","url":"https:\/\/shop-qa.barnesandnoble.com\/products\/9780789756145","provider":"Barnes \u0026 Noble (DEV)","version":"1.0","type":"link"}