LEADER 05712nam a22004455i 4500
001 978-3-319-32185-1
003 DE-He213
005 20160805092404.0
007 cr nn 008mamaa
008 160805s2016    gw |    s    |||| 0|eng d
020   $a9783319321851$9978-3-319-32185-1
024 7 $a10.1007/978-3-319-32185-1$2doi
050  4$aQA276-280
072  7$aPBT$2bicssc
072  7$aK$2bicssc
072  7$aBUS061000$2bisacsh
082 04$a330.015195$223
100 1 $aFraser, Cynthia.$eauthor.
245 10$aBusiness Statistics for Competitive Advantage with Excel 2016$h[electronic resource] :$bBasics, Model Building, Simulation and Cases /$cby Cynthia Fraser.
264  1$aCham :$bSpringer International Publishing :$bImprint: Springer,$c2016.
300   $aXIV, 475 p. 375 illus., 370 illus. in color.$bonline resource.
336   $atext$btxt$2rdacontent
337   $acomputer$bc$2rdamedia
338   $aonline resource$bcr$2rdacarrier
347   $atext file$bPDF$2rda
505 0 $aStatistics for Decision Making and Competitive Advantage -- Describing your Data -- Hypothesis Tests, Confidence Intervals to Infer Population Characteristics and Differences -- Simulation to Infer Future Performance Levels Given Assumptions -- Simple Regression for Long Range Forecasts -- Consolidating Multiple Naïve Forecasts with Monte Carlo -- Presenting Statistical Analysis Results to Management -- Finance Application: Portfolio Analysis with a Market Index as a Leading Indicator in Simple Linear Regression -- Association between Two Categorical Variables: Contingency Analysis with Chi Square -- Building Multiple Regression Models -- Indicator Variables -- Model Building and Forecasting with Multicollinear Time Series -- Nonlinear Multiple Regression Models -- Nonlinear Explanatory Multiple Regression Models.
520   $aThe 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. Exceptional managers know that they can create competitive advantages by basing decisions on performance response under alternative scenarios, and managers need to understand how to use statistics to create such advantages. Statistics, from basic 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 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 emphasizes 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, 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. ·