Predictive Analytics: Microsoft Excel

Predictive Analytics: Microsoft Excel

Conrad Carlberg

Excel predictive analytics for critical facts crunchers!


The motion picture Moneyball made predictive analytics well-known: you can now practice a similar recommendations to aid your enterprise win. You don’t desire multimillion-dollar software program: all of the instruments you would like are available Microsoft Excel, and the entire wisdom and abilities are the following, during this booklet!


Microsoft Excel MVP Conrad Carlberg indicates you ways to exploit Excel predictive analytics to unravel real-world difficulties in components starting from revenues and advertising to operations. Carlberg bargains unparalleled perception into development robust, credible, and trustworthy forecasts, exhibiting how one can achieve deep insights from Excel that may be tough to discover with high priced instruments comparable to SAS or SPSS.


You’ll get an intensive choice of downloadable Excel workbooks you could simply adapt on your personal targeted necessities, plus VBA code—much of it open-source—to streamline numerous of this book’s most complicated techniques.


Step through step, you’ll construct on Excel talents you have already got, studying complicated thoughts which could assist you bring up profit, lessen charges, and enhance productiveness. through gaining knowledge of predictive analytics, you’ll achieve a robust aggressive virtue to your corporation and yourself.


   •   study either the “how” and “why” of utilizing facts to make greater tactical decisions

   •   select the perfect analytics approach for every problem

   •   Use Excel to catch stay real-time info from different assets, together with third-party websites

   •   Use logistic regression to foretell behaviors resembling “will purchase” as opposed to “won’t buy”

   •   Distinguish random facts bounces from actual, primary changes

   •   Forecast time sequence with smoothing and regression

   •   build extra actual predictions by utilizing Solver to discover greatest probability estimates

   •   deal with large numbers of variables and massive datasets with central parts research and Varimax issue rotation

   •   practice ARIMA (Box-Jenkins) options to construct greater forecasts and comprehend their meaning




Show sample text content

Download sample