4 of 4 people found the following review helpful
4.0 out of 5 stars
Conrad Carlberg's Predictive Analytics: Microsoft® Excel, 15 Sept. 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.