Customer Review

3 of 3 people found the following review helpful
4.0 out of 5 stars Conrad Carlberg's Predictive Analytics: Microsoft® Excel, 15 Sep 2012
This review is from: Predictive Analytics: Microsoft Excel (Kindle Edition)
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.
Help other customers find the most helpful reviews 
Was this review helpful to you? Yes No

Be the first person to comment on this review.

[Add comment]
Post a comment
To insert a product link use the format: [[ASIN:ASIN product-title]] (What's this?)
Amazon will display this name with all your submissions, including reviews and discussion posts. (Learn more)
Name:
Badge:
This badge will be assigned to you and will appear along with your name.
There was an error. Please try again.
Please see the full guidelines ">here.

Official Comment

As a representative of this product you can post one Official Comment on this review. It will appear immediately below the review wherever it is displayed.   Learn more
The following name and badge will be shown with this comment:
 (edit name)
After clicking on the Post button you will be asked to create your public name, which will be shown with all your contributions.

Is this your product?

If you are the author, artist, manufacturer or an official representative of this product, you can post an Official Comment on this review. It will appear immediately below the review wherever it is displayed.  Learn more
Otherwise, you can still post a regular comment on this review.

Is this your product?

If you are the author, artist, manufacturer or an official representative of this product, you can post an Official Comment on this review. It will appear immediately below the review wherever it is displayed.   Learn more
 
System timed out

We were unable to verify whether you represent the product. Please try again later, or retry now. Otherwise you can post a regular comment.

Since you previously posted an Official Comment, this comment will appear in the comment section below. You also have the option to edit your Official Comment.   Learn more
The maximum number of Official Comments have been posted. This comment will appear in the comment section below.   Learn more
Prompts for sign-in
 


Review Details

Item

4.5 out of 5 stars (2 customer reviews)
5 star:
 (1)
4 star:
 (1)
3 star:    (0)
2 star:    (0)
1 star:    (0)
 
 
 
£12.99
Add to wishlist
Reviewer


Top Reviewer Ranking: 1,302,544