Shortcuts
Please wait while page loads.
SISSA Library . Default .
PageMenu- Main Menu-
Page content

Catalogue Display

Business Statistics for Competitive Advantage with Excel 2007: Basics, Model Building, and Cases

Business Statistics for Competitive Advantage with Excel 2007: Basics, Model Building, and Cases
Catalogue Information
Field name Details
Dewey Class 330.015195
Title Business Statistics for Competitive Advantage with Excel 2007 ([Ebook]) : Basics, Model Building, and Cases / by Cynthia Fraser.
Author Fraser, Cynthia
Other name(s) SpringerLink (Online service)
Publication New York, NY : Springer , 2009.
Physical Details XVIII, 410 pages : online resource.
ISBN 9780387744032
Summary Note This 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 2007 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 2007 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. 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.:
System details note Online access to this digital book is restricted to subscription institutions through IP address (only for SISSA internal users).
Internet Site http://dx.doi.org/10.1007/978-0-387-74403-2
Links to Related Works
Subject References:
Authors:
Corporate Authors:
Classification:
Catalogue Information 27399 Beginning of record . Catalogue Information 27399 Top of page .

Reviews


This item has not been rated.    Add a Review and/or Rating27399
Quick Search