More predictive analytics: Microsoft Excel

Book Cover
Average Rating
Indianapolis, Indiana : Que, [2016].
Central Adult Nonfiction
303.49 CARLB
Call Number
Last Check-In
Central Adult Nonfiction
303.49 CARLB
Sep 19, 2019

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
More Details
Physical Desc:
vi, 252 pages : illustrations ; 23 cm.
9780789756145, 0789756145


General Note
Includes index.
Also in This Series
More Like This
Reviews from GoodReads
Loading GoodReads Reviews.
APA Citation (style guide)

Carlberg, C. G. (2016). More predictive analytics: Microsoft Excel. Indianapolis, Indiana: Que.

Chicago / Turabian - Author Date Citation (style guide)

Carlberg, Conrad George. 2016. More Predictive Analytics: Microsoft Excel. Indianapolis, Indiana: Que.

Chicago / Turabian - Humanities Citation (style guide)

Carlberg, Conrad George, More Predictive Analytics: Microsoft Excel. Indianapolis, Indiana: Que, 2016.

MLA Citation (style guide)

Carlberg, Conrad George. More Predictive Analytics: Microsoft Excel. Indianapolis, Indiana: Que, 2016. Print.

Note! Citation formats are based on standards as of July 2010. Citations contain only title, author, edition, publisher, and year published. Citations should be used as a guideline and should be double checked for accuracy.
Staff View
Grouped Work ID:
Go To GroupedWork

Record Information

Last Sierra Extract TimeSep 19, 2019 06:16:44 PM
Last File Modification TimeSep 20, 2019 04:50:28 AM
Last Grouped Work Modification TimeSep 20, 2019 04:48:43 AM

MARC Record

LEADER01470cam a2200361Ii 4500
008150901t20162016inua          001 0 eng d
010 |a  2015941441
020 |a 9780789756145|q (pbk.)|q ;
020 |a 0789756145|q (pbk.)
035 |a (OCoLC)921134495
040 |a CDX|b eng|e rda|c CDX|d CLE|d YDXCP|d VP@|d OCLCF|d VIA|d UtOrBLW
049 |a VIAC
0920 |a 303.49 CARLB
1001 |a Carlberg, Conrad George,|e author.|4 aut|0
24510|a More predictive analytics :|b Microsoft Excel /|c Conrad Carlberg.
264 1|a Indianapolis, Indiana :|b Que,|c [2016]
264 4|c ©2016.
300 |a vi, 252 pages :|b illustrations ;|c 23 cm.
336 |a text|b txt|2 rdacontent.
337 |a unmediated|b n|2 rdamedia.
338 |a volume|b nc|2 rdacarrier.
500 |a Includes index.
63000|a Microsoft Excel (Computer file)|0
650 0|a Statistics.|0
650 0|a Forecasting.|0
907 |a .b19055109|b 08-22-19|c 04-28-16
998 |a can|b 08-01-18|c m|d a |e -|f eng|g inu|h 0
905 |a MARS
903 |a OCLC Holdings Updated 20190822
989 |g 0|i 31000001056897|j 0|k  - - |l can |o -|p $39.99|q -|r -|s - |t 2|e  - - |d 09-19-2019 18:16|h 08-08-2019 17:34|u 12|v 16|w 1|x 6|y .i20571355|z 05-09-16