Business Statistics for Competitive Advantage with Excel 2010

Basics, Model Building, and Cases

Authors: Fraser, Cynthia

  • Focuses on statistical model building and Analysis not Theory
  • Covers the full gamut of Excel properties and utilities for Business Stats, including all shortcuts. All communicate very clearly with concise tables and screen shots
  • Statistical Analyses are translated into concise Business English Applications. Applications are taken from actual Business problems
see more benefits

Buy this book

eBook $69.99
price for USA (gross)
  • ISBN 978-1-4419-9857-6
  • Digitally watermarked, DRM-free
  • Included format: EPUB, PDF
  • ebooks can be used on all reading devices
  • Immediate eBook download after purchase
Rent the ebook  
  • Rental duration: 1 or 6 month
  • low-cost access
  • online reader with highlighting and note-making option
  • can be used across all devices
About this Textbook

Exceptional managers know that they can create competitive advantages by basing decisions on performance response under alternative scenarios.  To create these advantages, managers need to understand how to use statistics to provide information on performance response under alternative scenarios. This updated edition of the popular text helps business students 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 2010 with shortcuts, and translate results into implications for decision makers. The author emphasizes communicating results effectively in plain English and with compelling graphics in the form of memos and PowerPoints.

Statistics, from basics to sophisticated models, are illustrated with examples using real data such as students will encounter in their roles as managers. A number of examples focus on business in emerging global markets with particular emphasis on China and India. Results are linked to implications for decision making with sensitivity analyses to illustrate how alternate scenarios can be compared. Chapters include screenshots to make it easy to conduct analyses in Excel 2010 with time-saving shortcuts expected in the business world.

PivotTables and PivotCharts, used frequently in businesses, are introduced from the start. Monte Carlo simulation is introduced early, 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, autocorrelation 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, and a chapter on logit regression models introduces models of market share or proportions. The Second Edition includes more explanation of hypothesis tests and confidence intervals, how t, F, and chi square distributions behave.

The Data Files, Solution Files, and Chapter PowerPoints:

The data files for text examples, cases, lab problems and assignments are stored on Blackboard and may be accessed using this link:

https://blackboard.comm.virginia.edu/webapps/portal/frameset.jsp

Instructors can gain access to the files, as well as solution files and chapter PowerPoints by registering on the Springer site: 

http://www.springer.com/statistics/business%2C+economics+%26+finance/book/978-1-4419-9856-9?changeHeader

 

Business people can gain access to the files by emailing the author cfg8q@virginia.edu.

https://blackboard.comm.virginia.edu/webapps/portal/frameset.jsp

Instructors can gain access to the files, as well as solution files and chapter PowerPoints by registering on the Springer site: 

http://www.springer.com/statistics/business%2C+economics+%26+finance/book/978-1-4419-9856-9?changeHeader

 

Business people can gain access to the files by emailing the author cfg8q@virginia.edu.

About the authors

Cynthia Fraser received her Ph.D. from The Wharton School, University of Pennsylvania, and is a member of the Marketing faculty at The McIntire School of Commerce, University of Virginia, where she teaches Quantitative Analysis I and II. Her research has appeared in a number of journals, including Decision Science, Management Science, Journal of Marketing, Journal of Consumer Research, Journal of International Business Studies, and Journal of Applied Social Psychology.

Reviews

From the book reviews:

“The book consists of 13 chapters and an index. Assignments, case histories, and lab exercises are given at the end of most chapters for the reader to test their knowledge. … this is a good business statistics text that would be of benefit to business professionals … . anyone in the business field who wants to learn more about how to do statistical analysis with Excel 2010 will find this a worthwhile addition to their library.” (Dean V. Neubauer, Technometrics, Vol. 55 (1), February, 2013)


Video

Table of contents (13 chapters)

  • Statistics for Decision Making and Competitive Advantage

    Fraser, Cynthia

    Pages 1-3

  • Describing Your Data

    Fraser, Cynthia

    Pages 5-44

  • Hypothesis Tests, Confidence Intervals, and Simulation to Infer Population Characteristics and Differences

    Fraser, Cynthia

    Pages 45-107

  • Quantifying the Influence of Performance Drivers and Forecasting: Regression

    Fraser, Cynthia

    Pages 109-151

  • Market Simulation and Segmentation with Descriptive Statistics, Inference, Hypothesis Tests, and Regression

    Fraser, Cynthia

    Pages 153-173

Buy this book

eBook $69.99
price for USA (gross)
  • ISBN 978-1-4419-9857-6
  • Digitally watermarked, DRM-free
  • Included format: EPUB, PDF
  • ebooks can be used on all reading devices
  • Immediate eBook download after purchase
Rent the ebook  
  • Rental duration: 1 or 6 month
  • low-cost access
  • online reader with highlighting and note-making option
  • can be used across all devices
Loading...

Recommended for you

Loading...

Bibliographic Information

Bibliographic Information
Book Title
Business Statistics for Competitive Advantage with Excel 2010
Book Subtitle
Basics, Model Building, and Cases
Authors
Copyright
2012
Publisher
Springer-Verlag New York
Copyright Holder
Springer Science+Business Media, LLC
eBook ISBN
978-1-4419-9857-6
DOI
10.1007/978-1-4419-9857-6
Edition Number
2
Number of Pages
XVI, 469
Number of Illustrations and Tables
3 b/w illustrations, 354 illustrations in colour
Topics