Decision Analytics: Microsoft Excel (Paperback)

Conrad Carlberg

  • 出版商: QUE
  • 出版日期: 2013-11-15
  • 定價: $1,320
  • 售價: 8.0$1,056
  • 語言: 英文
  • 頁數: 288
  • 裝訂: Paperback
  • ISBN: 0789751682
  • ISBN-13: 9780789751683
  • 相關分類: Excel
  • 立即出貨 (庫存=1)

買這商品的人也買了...

商品描述

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.

商品描述(中文翻譯)

利用大數據來優化行銷等領域!

對於現在可用的大量數據感到不知所措嗎?不確定應該問什麼問題或如何提問嗎?使用Microsoft Excel和經過驗證的決策分析技術,您可以將所有數據提煉成可管理的集合,並將其用於優化各種業務和投資決策。在《決策分析:Microsoft Excel》中,暢銷統計專家和顧問康拉德·卡爾伯格將親自指導您進行這一過程,並逐步引導您。

卡爾伯格將指導您使用決策分析將客戶(或其他任何事物)分為合理且可操作的群組和集群。接下來,您將學習在商業和其他領域中優化各種決策的實用方法,從定價到交叉銷售,從招聘到投資,甚至面部識別軟件都使用了本書中討論的技術!

通過實際示例,卡爾伯格幫助您理解決策分析的技術和假設,並使用簡單的Excel圖表直觀地理解結果。在建立了這個基礎之後,您可以在Excel中進行自己的分析,並使用SAS和SPSS等高級統計軟件生成的結果進行工作。

本書附帶了一系列可下載的Excel工作簿,您可以輕鬆地根據自己的獨特需求進行調整,還有VBA代碼來簡化其中一些最複雜的技術。

以下是本書的一些重點內容:
- 根據現有類別或自然發生的預測變量集群將數據進行分類
- 減少大量變量和記錄的數量,以獲得您真正需要的答案
- 利用集群分析找到市場研究和其他應用中的相似模式
- 學習如何使用多重判別分析來分類案例
- 使用MANOVA來判斷群組在多變量中心點上是否有差異
- 使用主成分分析探索數據,找到模式並識別潛在因素

註冊您的書籍,以獲得所有示例工作簿、更新和更正的訪問權限,請訪問quepublishing.com/title/9780789751683。