Overwhelmed by all the "Big Data" now available to you? Dumbfounded by all the variables and observations you can make? Not sure what questions to ask? Using proven decision analytics techniques, you can easily distill all that data into manageable sets - and you can do it with Microsoft Excel, a tool you already know. In Decision Analytics: Microsoft Excel, best-selling statistics expert and consultant Conrad Carlberg will show you how.
Carlberg's hands-on tutorial guides you through using decision analytics to segment customers (or anything else) into sensible and actionable groups and clusters - and then using those groups to improve everything from pricing to cross-selling, investment decisions to inventory management. Throughout, he provides Excel workbooks containing complete sample data and analyses: workbooks designed so you can easily adapt them for your unique requirements.
Carlberg begins by reviewing each component of the decision analysis system, and then guides you step-by-step through:
- Logistic regression
- Univariate Analysis of Variance (ANOVA)
- Multivariate Analysis of Variance (MANOVA)
- Discriminant Function Analysis (basic and advanced)
- Cluster Analysis (basic and advanced)
Through practical and realistic examples, he helps you understand the techniques and assumptions that underlie decision analytics, and use simple Excel charts to intuitively grasp the results. With this foundation in place, you can either do your own analyses in Excel, or begin working with and evaluating results produced by advanced statistical packages such as SAS and SPSS.
Note: This book assumes some basic familiarity with regression analysis; if you need to learn this, also read his outstanding companion guide, Predictive Analytics. Microsoft Excel.
Unless otherwise noted above, most orders ship within 1 to 2 days. We will promptly notify you if there is a stock problem with any items on your order and provide you with an estimated delivery date. If you have a firm need by date, please provide such information in the comment section at checkout.
Publisher: Que Publishing
Page Count (est.): 336
Pub Date: 11/4/2013