This is Real Life Sale
 
 

Special Offers see all

Enter to WIN a $100 Credit

Subscribe to PowellsBooks.news
for a chance to win.
Privacy Policy

Visit our stores


    Recently Viewed clear list


    Interviews | March 9, 2015

    Rhianna Walton: IMG Erik Larson: The Powells.com Interview



    Erik LarsonI've been a fan of Erik Larson's riveting brand of narrative history for years, and his latest book, Dead Wake: The Last Crossing of the Lusitania,... Continue »
    1. $19.60 Sale Hardcover add to wish list

    spacer
Qualifying orders ship free.
$39.99
New Trade Paper
Ships in 1 to 3 days
Add to Wishlist
Available for In-store Pickup
in 7 to 12 days
Qty Store Section
20 Remote Warehouse Mathematics- Statistics
5 Remote Warehouse Mathematics- Statistics

Decision Analytics: Microsoft Excel

by

Decision Analytics: Microsoft Excel Cover

 

Synopses & Reviews

Publisher Comments:

Crunch Big Data to optimize marketing and more!

 

Overwhelmed by all the Big Data now available to you? Not sure what questions to ask or how to ask them? Using Microsoft Excel and proven decision analytics techniques, you can distill all that data into manageable sets—and use them to optimize a wide variety of business and investment decisions. In Decision Analytics: Microsoft Excel, best selling statistics expert and consultant Conrad Carlberg will show you how—hands-on and step-by-step.

 

Carlberg guides you through using decision analytics to segment customers (or anything else) into sensible and actionable groups and clusters. Next, you’ll learn practical ways to optimize a wide spectrum of decisions in business and beyond—from pricing to cross-selling, hiring to investments—even facial recognition software uses the techniques discussed in this book!

 

Through realistic examples, Carlberg 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 perform your own analyses in Excel and work with results produced by advanced stats packages such as SAS and SPSS.

 

This book comes with an extensive collection of downloadable Excel workbooks you can easily adapt to your own unique requirements, plus VBA code to streamline several of its most complex techniques.

  • Classify data according to existing categories or naturally occurring clusters of predictor variables
  • Cut massive numbers of variables and records down to size, so you can get the answers you really need
  • Utilize cluster analysis to find patterns of similarity for market research and many other applications
  • Learn how multiple discriminant analysis helps you classify cases
  • Use MANOVA to decide whether groups differ on multivariate centroids
  • Use principal components to explore data, find patterns, and identify latent factors

Register your book for access to all sample workbooks, updates, and corrections as they become available at quepublishing.com/title/9780789751683.

Synopsis:

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.

About the Author

Conrad Carlberg has written eleven books about quantitative analysis with Excel, including Statistical Analysis: Microsoft® Excel 2010 and Predictive Analytics: Microsoft® Excel. His company, found at www.conradcarlberg.com, focuses on the quantitative analysis of data that companies routinely collect in their sales, employee, customer management and other operations database systems. Carlberg holds a Ph.D. in statistics from the University of Colorado and has 25 years’ experience applying advanced analytical techniques.

 

Conrad Carlberg lives near San Diego with his wife, not too far from the beach, but high enough that the rise in the sea level is unlikely to convert their home to waterfront property. Two cats round out the indoor menagerie; the three rabbits are required to stay outside.

Table of Contents

  1. Components of Decision Analytics
  2. Logistic Regression
  3. Univariate Analysis of Variance (ANOVA)
  4. Multivariate Analysis of Variance (MANOVA)
  5. Discriminant Function Analysis. The Basics
  6. Discriminant Function Analysis. Further Issues
  7. Principal Components
  8. Cluster Analysis: The Basics
  9. Cluster Analysis: Further Issues

Product Details

ISBN:
9780789751683
Author:
Carlberg, Conrad
Publisher:
Que
Subject:
Mathematics - Statistics
Subject:
Statistics
Subject:
Excel Big Data; Excel analytics; cluster analysis; logistic regression; discriminant function analysis; ANOVA; MANOVA; predictive analytics; decision analytics
Copyright:
Edition Description:
Trade paper
Publication Date:
20131015
Binding:
TRADE PAPER
Language:
English
Pages:
288
Dimensions:
9.063 x 7 x 0.598 in 445 gr

Related Subjects

Business » General
Business » Management
Business » Writing
Computers and Internet » Operating Systems » Microsoft Windows » Applications
Computers and Internet » Operating Systems » Microsoft Windows » Windows 95 » General
Computers and Internet » Personal Computers » Desktop Applications » Spreadsheets
Science and Mathematics » Mathematics » Probability and Statistics » Statistics

Decision Analytics: Microsoft Excel New Trade Paper
0 stars - 0 reviews
$39.99 In Stock
Product details 288 pages Que - English 9780789751683 Reviews:
"Synopsis" by ,

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.

spacer
spacer
  • back to top

FOLLOW US ON...

     
Powell's City of Books is an independent bookstore in Portland, Oregon, that fills a whole city block with more than a million new, used, and out of print books. Shop those shelves — plus literally millions more books, DVDs, and gifts — here at Powells.com.