Business Statistics for Competitive Advantage with Excel 2016: Basics, Model Building, Simulation and...

— —

Cynthia Fraser

Business Statistics for Competitive Advantage with Excel 2016

Basics, Model Building, Simulation and Cases

Cynthia Fraser

$214.95 $171.85

Paperback

Not in-store but you can order this
How long will it take?

Availability Information

We source books from suppliers in Australia and overseas. For books we don't currently have in stock, the time it takes to get them from our suppliers can vary widely - from a few days to a few months - so we check each book with each supplier to determine the expected time it will take to be supplied to us.

We then advise you accordingly. If the time taken to get any book is too long for you, you can let us know and we will cancel or adjust your order, and refund as required.

To find out the anticipated arrival time for specific items prior to ordering, please contact us by phone or email:

Phone +61 2 9264 3111, or 1800 4 BOOKS (1800 4 26657) if outside Sydney:
option 1 Abbey's Bookshop (Crime, History, Science, Kids & more) • info@abbeys.com.au
option 2 Language Book Centre (ESL & Foreign Languages) • language@abbeys.com.au
option 3 Galaxy Bookshop (Sci-fi, Fantasy, Romance, Graphic Novels) • sf@galaxybooks.com.au

QTY:

English

Springer International Publishing AG
22 April 2018

Econometrics; Economic statistics; Finance; Spreadsheet software; Mathematical & statistical software

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.

By: Cynthia Fraser
Imprint: Springer International Publishing AG
Country of Publication: Switzerland
Edition: Softcover reprint of the original 1st ed. 2016
Dimensions: Height: 279mm, Width: 210mm, Spine: 25mm
Weight: 1.098kg
ISBN: 9783319812175
ISBN 10: 3319812173
Pages: 475
Publication Date: 22 April 2018
Audience: Professional and scholarly , Undergraduate
Format: Paperback
Publisher's Status: Active

Statistics 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.

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 business statistics. Her research has appeared in a number of journals, including Decision Science, Management Science, Journal of Marketing, Journal of Consumer Research, Psychology and Marketing, Journal of International Business Studies, and Journal of Applied Social Psychology.