Predictive Analytics: Microsoft Excel
Author | : | |
Rating | : | 4.85 (648 Votes) |
Asin | : | B008JWQ8CA |
Format Type | : | |
Number of Pages | : | 420 Pages |
Publish Date | : | 2013-04-03 |
Language | : | English |
DESCRIPTION:
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. 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.
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.. 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
"From 0 to competent in 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. 00 pages!" according to Joseph Johnson. 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. "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, prin. Antoine Johnson said Not for beginners!. 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. -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
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 th