Overview
Cutting-edge coverage of Excel 2016 for use in business school classrooms and beyond
New real-world examples and assignments on global markets incorporated throughout
Focuses on statistical analysis, model building, simulation, sensitivity analysis, and translation of results to improve business decisions
Covers the full gamut of Excel properties and utilities for Business Statistics, including time-saving shortcuts communicated very clearly with concise tables and screen shots
Statistical Analyses are translated into concise business English applications that are taken from actual business problems
Includes supplementary material: sn.pub/extras
Access this book
Tax calculation will be finalised at checkout
Other ways to access
Table of contents (14 chapters)
-
Front Matter
-
Back Matter
Keywords
About this book
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.
Authors and Affiliations
About the author
Bibliographic Information
Book Title: Business Statistics for Competitive Advantage with Excel 2016
Book Subtitle: Basics, Model Building, Simulation and Cases
Authors: Cynthia Fraser
DOI: https://doi.org/10.1007/978-3-319-32185-1
Publisher: Springer Cham
eBook Packages: Mathematics and Statistics, Mathematics and Statistics (R0)
Copyright Information: Springer Nature Switzerland AG 2016
Hardcover ISBN: 978-3-319-32184-4Published: 22 August 2016
Softcover ISBN: 978-3-319-81217-5Published: 22 April 2018
eBook ISBN: 978-3-319-32185-1Published: 05 August 2016
Edition Number: 1
Number of Pages: XIV, 475
Number of Illustrations: 5 b/w illustrations, 370 illustrations in colour
Topics: Statistics for Business, Management, Economics, Finance, Insurance, Management, Market Research/Competitive Intelligence