Predictive Analytics: Microsoft Excel 2016 (2nd Edition)

Conrad Carlberg

  • 出版商: QUE
  • 出版日期: 2017-07-24
  • 定價: $1,440
  • 售價: 6.0$864
  • 語言: 英文
  • 頁數: 384
  • 裝訂: Paperback
  • ISBN: 0789758350
  • ISBN-13: 9780789758354
  • 相關分類: ExcelMachine Learning
  • 立即出貨 (庫存 < 3)

商品描述

EXCEL 2016 PREDICTIVE ANALYTICS FOR SERIOUS DATA CRUNCHERS!


Now, you can apply cutting-edge predictive analytics techniques to help your business win–and you don’t need multimillion-dollar software to do it. All the tools you need are available in Microsoft Excel 2016, and all the knowledge and skills are right here, in this book!


Microsoft Excel MVP Conrad Carlberg shows you how to use Excel predictive analytics to solve real problems in areas ranging from sales and marketing to operations. Carlberg offers unprecedented insight into building powerful, credible, and reliable forecasts, helping you gain deep insights from Excel that would be difficult to uncover with costly tools such as SAS or SPSS.


Fully updated for Excel 2016, this guide contains valuable new coverage of accounting for seasonality and managing complex consumer choice scenarios. Throughout, Carlberg provides downloadable Excel 2016 workbooks you can easily adapt to your own needs, plus VBA code–much of it open-source–to streamline especially complex techniques.


Step by step, you’ll build on Excel skills you already have, learning advanced techniques that can help you increase revenue, reduce costs, and improve productivity. By mastering predictive analytics, you’ll gain a powerful competitive advantage for your company and yourself.


Learn the “how” and “why” of using data to make better decisions, and choose the right technique for each problem


  • 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
  • Account for trends and seasonality via Holt-Winters smoothing
  • Prevent trends from running out of control over long time horizons
  • Construct more accurate predictions by using Solver
  • Manage large numbers of variables and unwieldy datasets with principal components analysis and Varimax factor rotation
  • Apply ARIMA (Box-Jenkins) techniques to build better forecasts and clarify their meaning
  • Handle complex consumer choice problems with advanced logistic regression
  • Benchmark Excel results against R results

商品描述(中文翻譯)

《EXCEL 2016 預測分析:為嚴肅的數據分析者而設!》

現在,您可以應用尖端的預測分析技術來幫助您的業務取得勝利,而且您不需要花費數百萬美元的軟體。您所需的所有工具都可以在 Microsoft Excel 2016 中找到,而所有的知識和技能都在這本書中!

Microsoft Excel MVP Conrad Carlberg 將向您展示如何使用 Excel 預測分析來解決從銷售和市場營銷到運營的真實問題。Carlberg 提供了建立強大、可信和可靠的預測的前所未有的見解,幫助您從 Excel 中獲得深入洞察,這對於使用昂貴的工具(如 SAS 或 SPSS)很難揭示。

本指南已完全更新至 Excel 2016,其中包含有關季節性會計和管理複雜的消費者選擇情境的寶貴新內容。在整個過程中,Carlberg 提供了可供您輕鬆適應自己需求的可下載 Excel 2016 工作簿,以及用於簡化特別複雜技術的 VBA 代碼(其中大部分是開源的)。

通過逐步學習,您將在已有的 Excel 技能基礎上,學習到可以幫助您增加收入、降低成本和提高生產力的高級技術。通過掌握預測分析,您將為您的公司和自己獲得強大的競爭優勢。

學習如何使用數據做出更好的決策的“如何”和“為什麼”,並為每個問題選擇合適的技術:

- 從各種來源(包括第三方網站)捕獲實時數據
- 使用邏輯回歸預測行為,例如“會買”與“不會買”
- 區分隨機數據波動和真實的基本變化
- 使用平滑和回歸預測時間序列
- 通過 Holt-Winters 平滑處理趨勢和季節性
- 避免長期時間範圍內趨勢失控
- 通過使用 Solver 構建更準確的預測
- 使用主成分分析和 Varimax 因子旋轉來處理大量變量和難以處理的數據集
- 使用 ARIMA(Box-Jenkins)技術建立更好的預測並澄清其含義
- 通過高級邏輯回歸處理複雜的消費者選擇問題
- 將 Excel 的結果與 R 的結果進行對比