Predictive Analytics: Microsoft Excel
| Author | : | |
| Rating | : | 4.96 (588 Votes) |
| Asin | : | 0789749416 |
| Format Type | : | paperback |
| Number of Pages | : | 304 Pages |
| Publish Date | : | 2014-05-01 |
| Language | : | English |
DESCRIPTION:
A look back at the “About the Author” paragraph in Carlberg’s first book, published in 1995, shows that the only word that remains accurate is “He.” Scary.. Counting conservatively, this is Conrad Carlberg’s eleventh book about quantitative analysis using Microsoft Excel, which he still regards with a mix of awe and exasperation
From 0 to competent in 300 pages! As an inexperienced Demand Analyst I scrambled to understand the academic literature on forecasting. I was pretty swamped and did not know where to start until I found this book. Carlberg has a way of explaining very complex issues in a way that a beginner can grasp and an intermediate or expert can learn from. His book is funny, intuitive, and really hits home as to where to start when diving into predictive analytics. Although I've read through the book and worked through several of the examples, I keep the book close at hand for a quick reference. Great, great book!. "A good practiacal approach to the science/art of forecasting." according to Hall Barker. The book is designed for the data analyst vs. the theoretician. The chapters on Exponential Smoothing (Simple and the Holt's method) could get more attention but I understand these topics are addressed in another book. Chapters on logistic regression, principal components analysis, factor analysis and ARIMA are good. I wish I had these chapters when I was taking a graduate level multivariate statistics course using SPSS in a mainframe environment. The author does a nice job in reinforcing that a lot of analysis can be done in Excel but for some analytical techniques the reader is better off with a. "Not for beginners!" according to Antoine Johnson. Not for beginners! 3-Stars for now. As a beginner I think I bit off way too much at first. I'm going to start with a "For Dummies" book first on predictive analytics and then go back and re-read this one. I'm pretty Excel savvy so I'm looking forward to applying the concepts - one I actually understand them!. -Stars for now. As a beginner I think I bit off way too much at first. I'm going to start with a "For Dummies" book first on predictive analytics and then go back and re-read this one. I'm pretty Excel savvy so I'm looking forward to applying the concepts - one I actually understand them!
About the AuthorCounting conservatively, this is Conrad Carlberg’s eleventh book about quantitative analysis using Microsoft Excel, which he still regards with a mix of awe and exasperation. A look back at the “About the Author” paragraph in Carlberg’s first book, published in 1995, shows that the only word that remains accurate is “He.” Scary.
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. 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. 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 &