Free Book Online
Book Predictive Analytics: Microsoft Excel


Predictive Analytics: Microsoft Excel

4.4 (2240)

Log in to rate this item

    Available in PDF - DJVU Format | Predictive Analytics: Microsoft Excel.pdf | Language: ENGLISH
    Conrad Carlberg(Author)

    Book details

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 Excel, and all the knowledge and skills are right here, in this book!


Microsoft Excel MVP Conrad Carlberg shows you how to use Excel predictive analytics to solve real-world problems in areas ranging from sales and marketing to operations. Carlberg offers unprecedented insight into building powerful, credible, and reliable forecasts, showing how to gain deep insights from Excel that would be difficult to uncover with costly tools such as SAS or SPSS.


You’ll get an extensive collection of downloadable Excel workbooks you can easily adapt to your own unique requirements, plus VBA code—much of it open-source—to streamline several of this book’s most complex techniques.


Step by step, you’ll build on Excel skills you already have, learning advanced techniques that can help you increase revenue, reduce costs, and improve productivity. By mastering predictive analytics, you’ll gain a powerful competitive advantage for your company and yourself.


   •   Learn both the “how” and “why” of using data to make better tactical decisions

   •   Choose the right analytics technique for each problem

   •   Use Excel to capture live real-time data from diverse sources, including third-party websites

   •   Use logistic regression to predict behaviors such as “will buy” versus “won’t buy”

   •   Distinguish random data bounces from real, fundamental changes

   •   Forecast time series with smoothing and regression

   •   Construct more accurate predictions by using Solver to find maximum likelihood estimates

   •   Manage huge numbers of variables and enormous datasets with principal components analysis and Varimax factor rotation

   •   Apply ARIMA (Box-Jenkins) techniques to build better forecasts and understand their meaning




3.3 (3230)
  • Pdf

*An electronic version of a printed book that can be read on a computer or handheld device designed specifically for this purpose.

Formats for this Ebook

Required Software Any PDF Reader, Apple Preview
Supported Devices Windows PC/PocketPC, Mac OS, Linux OS, Apple iPhone/iPod Touch.
# of Devices Unlimited
Flowing Text / Pages Pages
Printable? Yes

Book details

  • PDF | 300 pages
  • Conrad Carlberg(Author)
  • Que Publishing; 1 edition (15 Mar. 2013)
  • English
  • 6
  • Computing & Internet

Read online or download a free book: Predictive Analytics: Microsoft Excel


Review Text

  • By Swinners Music on 15 September 2012

    Carlberg's book has ten well written chapters that cover the techniques of Correlation, Regression, Moving Averages, Forecasting, Principal Component Analysis, Arima Modelling and Varimax Factor Rotation. Each chapter is accompanied with an illustrative excel workbook that makes understanding much simpler and quicker. Chapter One is an exception to this because although the VBA code is provided, the excel workbook is not included, so I did not quite succeed in the aims of the author. However he uses some very neat and powerful techniques in this first chapter. The external data grabber is used select tables from a web site and is pasted into the excel sheet. VBA code is then used to find a particular string of characters and extract the Amazon ranking of an author's book every hour. From the changing ranks over time, it is then possible to estimate the number of books sold in the day. The problem is that the accompanying excel workbook to this chapter is not available, so I could not get this to work. Rather frustrating, but the book is logically written in clear language with sometimes too much detail; for example, a reader of this book really does not need to be told how to copy and paste in such great detail. This book succeeds in its aims in the predictive analysis of data.

  • By Zanamo on 30 April 2013

    An exceptional book, well written and good attention to both theory and practice. An enjoyable read following the Excel template examples which actually work. Some minor error and admissions in the examples but nothing that cannot be fixed or sort elsewhere. Good overall explanations of the subject, sensibly written for both novice and professional. I have now purchased the Excel 2010 version by the same author and I am expecting more good fun in this statistical predictive area. The final point I would make is that once the basics are seen to work and the basics are cleverly explained, one can then pursue more advanced texts outside of using Excel such as the fun time one can have with R to provide similar predictive statistical analysis. Very pleased with this book and good value for cash. Well done Conrad.

  • By Guest on 30 June 2016

    I can't remember ever writing a review about anything I have purchased on Amazon ( something I have been doing for years now). But this book is an exception! It is the best statistics and predictive analytics material I have ever laid my hands on. A great read with fantastic explanations and demonstration of not only the concepts, but their underlying background behind them. Thanks Conrad for such a great piece!

  • By B. Seworde on 24 October 2014

    Not quite what I expected. Data for the analyses could have been simulated rather than downloading "something" from amazon which makes the analyses in the book difficult to replicate. Very disappointing!

  • By joe on 19 August 2014

    excellent product and service

  • By Warehouse on 23 February 2015

    Super read, fast delivery

  • Name:
    The message text*: