Business Statistics for Competitive Advantage with Excel 2016: Basics, Model Building, Simulation and Cases
暫譯: 使用 Excel 2016 的商業統計學:基礎、模型建構、模擬與案例分析
Cynthia Fraser
- 出版商: Springer
- 出版日期: 2018-04-22
- 售價: $4,210
- 貴賓價: 9.5 折 $4,000
- 語言: 英文
- 頁數: 475
- 裝訂: Paperback
- ISBN: 3319812173
- ISBN-13: 9783319812175
-
相關分類:
Excel、機率統計學 Probability-and-statistics
海外代購書籍(需單獨結帳)
商品描述
The revised Fourth Edition of this popular textbook is redesigned with Excel 2016 to encourage business students to develop competitive advantages for use in their future careers as decision makers. Students learn to build models using logic and experience, produce statistics using Excel 2016 with shortcuts, and translate results into implications for decision makers. The textbook features new examples and assignments on global markets, including cases featuring Chipotle and Costco. A number of examples focus on business in emerging global markets with particular emphasis on emerging markets in Latin America, China, and India. Results are linked to implications for decision making with sensitivity analyses to illustrate how alternate scenarios can be compared.
The author emphasises communicating results effectively in plain English and with screenshots and compelling graphics in the form of memos and PowerPoints. Chapters include screenshots to make it easy to conduct analyses in Excel 2016. PivotTables and PivotCharts, used frequently in business, are introduced from the start. The Fourth Edition features Monte Carlo simulation in four chapters, as a tool to illustrate the range of possible outcomes from decision makers’ assumptions and underlying uncertainties. Model building with regression is presented as a process, adding levels of sophistication, with chapters on multicollinearity and remedies, forecasting and model validation, auto-correlation and remedies, indicator variables to represent segment differences, and seasonality, structural shifts or shocks in time series models. Special applications in market segmentation and portfolio analysis are offered, and an introduction to conjoint analysis is included. Nonlinear models are motivated with arguments of diminishing or increasing marginal response.
商品描述(中文翻譯)
修訂版的第四版這本受歡迎的教科書重新設計為 Excel 2016,旨在鼓勵商業學生為未來作為決策者的職業生涯發展競爭優勢。學生學習使用邏輯和經驗建立模型,利用 Excel 2016 的快捷鍵生成統計數據,並將結果轉化為對決策者的啟示。這本教科書包含有關全球市場的新範例和作業,包括涉及 Chipotle 和 Costco 的案例。許多範例專注於新興全球市場,特別強調拉丁美洲、中國和印度的新興市場。結果與決策的啟示相連結,並進行敏感性分析,以說明如何比較不同的情境。
作者強調以簡單明瞭的英語有效地傳達結果,並使用截圖和引人注目的圖形,以備忘錄和 PowerPoint 的形式呈現。各章節包含截圖,以便於在 Excel 2016 中進行分析。PivotTables 和 PivotCharts,這些在商業中經常使用的工具,從一開始就被引入。第四版在四個章節中介紹了蒙地卡羅模擬,作為一種工具來說明決策者假設和潛在不確定性所可能產生的結果範圍。回歸模型的建立被呈現為一個過程,增加了複雜性,並包含有關多重共線性及其解決方案、預測和模型驗證、自相關及其解決方案、用於表示細分差異的指標變數,以及時間序列模型中的季節性、結構性變化或衝擊的章節。提供了市場細分和投資組合分析的特殊應用,並包含了聯合分析的介紹。非線性模型的動機是基於邊際反應遞減或遞增的論點。