Limit search to available items
Record 3 of 19
Previous Record Next Record
Book Cover
E-book
Author Fraser, Cynthia.

Title Business statistics for competitive advantage with Excel 2010 : basics, model building, and cases / by Cynthia Fraser
Edition 2nd ed
Published New York : Springer, ©2012

Copies

Description 1 online resource (xvi, 469 pages)
Contents Statistics for Decision Making and Competitive Advantage -- Describing Your Data -- Hypothesis Tests, Confidence Intervals, and Simulation to Infer Population Characteristics and Differences -- Quantifying the Influence of Performance Drivers and Forecasting: Regression -- Market Simulation and Segmentation with Descriptive Statistics, Inference, Hypothesis Tests, and Regression -- 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 -- Model Building and Forecasting with Multicollinear Time Series -- Indicator Variables -- Nonlinear Multiple Regression Models -- Indicator Interactions for Segment Differences or Changes in Response -- Logit Regression for Bounded Responses
Summary 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
Analysis Mathematical statistics
Economics Statistics
Statistics for Business/Economics/Mathematical Finance/Insurance
Statistics and Computing/Statistics Programs
Statistics, general
SUBJECT Microsoft Excel (Computer file) http://id.loc.gov/authorities/names/n86025775
Microsoft Excel (Computer file) fast
Subject Commercial statistics -- Computer programs
Mathematical statistics -- Computer programs.
Decision making -- Mathematical models.
Statistics.
Statistics as Topic
Decision Support Techniques
statistics.
Estadística matemática -- Programas de ordenador
Toma de decisiones -- Modelos matemáticos
Estadística
Statistics
Commercial statistics -- Computer programs
Decision making -- Mathematical models
Mathematical statistics -- Computer programs
Form Electronic book
ISBN 9781441998576
1441998578
144199856X
9781441998569