Business Statistics for Competitive Advantage with Excel 2010

Basics, Model Building, and Cases

Author: Cynthia Fraser

Publisher: Springer Science & Business Media

ISBN:

Category: Business & Economics

Page: 469

View: 725

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 [email protected] 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 [email protected]

Business Statistics for Competitive Advantage with Excel 2007

Basics, Model Building and Cases

Author: Cynthia Fraser

Publisher: Springer Science & Business Media

ISBN:

Category: Mathematics

Page: 410

View: 224

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. Statistics are created to make better decisions. Statistics are essential and relevant. Statistics must be easily and quickly produced using widely available software, Excel. Then results must be translated into general business language and illustrated with compelling graphics to make them understandable and usable by decision makers. This book helps students master this process of using statistics to create competitive advantages as decision makers. Statistics are essential, relevant, easy to produce, easy to understand, valuable, and fun, when used to create competitive advantage. The Examples, Assignments, And Cases Used To Illustrate Statistics For Decision Making Come From Business Problems McIntire Corporate Sponsors and Partners, such as Rolls-Royce, Procter & Gamble, and Dell, and the industries that they do business in, provide many realistic examples. The book also features a number of examples of global business problems, including those from important emerging markets in China and India. It is exciting to see how statistics are used to improve decision making in real and important business decisions. This makes it easy to see how statistics can be used to create competitive advantages in similar applications in internships and careers. Learning Is Hands On With Excel and Shortcuts

Business Statistics for Competitive Advantage with Excel 2013

Basics, Model Building, Simulation and Cases

Author: Cynthia Fraser

Publisher: Springer Science & Business Media

ISBN:

Category: Business & Economics

Page: 449

View: 930

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 2013 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 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. Chapters include screenshots to make it easy to conduct analyses in Excel 2013 with time-saving shortcuts expected in the business world. PivotTables and PivotCharts, used frequently in businesses, are introduced from the start. The Third Edition features Monte Carlo simulation in three 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.

Business Statistics for Competitive Advantage with Excel 2016

Basics, Model Building, Simulation and Cases

Author: Cynthia Fraser

Publisher: Springer

ISBN:

Category: Business & Economics

Page: 475

View: 99

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.

Statistics for Management and Economics

Author: Gerald Keller

Publisher: Cengage Learning

ISBN:

Category: Business & Economics

Page: 1008

View: 371

This worldwide best-selling business statistics text emphasizes applications over calculation. STATISTICS FOR MANAGEMENT AND ECONOMICS, 9e, demonstrates how vital statistical methods are for today's managers and economists--and teaches students how to apply these tools to real business problems. Through the author's unique three-step ICI approach to problem solving, students learn to IDENTIFY the correct statistical technique by focusing on the problem objective and data type, then COMPUTE the statistics (doing them by hand, using Excel, or using MINITAB), and ultimately INTERPRET results in the context of the problem. This approach enhances student comprehension and skills while offering you maximum flexibility. Incorporating various functional areas of business, data-driven examples, exercises, and cases demonstrate statistical applications used by marketing managers, financial analysts, accountants, economists, and others, giving students the hands-on practice they need, while sound pedagogical elements make the material accessible to undergrads. In addition, unique teaching and learning resources such as CourseMate save time while giving you more control and better student outcomes. Important Notice: Media content referenced within the product description or the product text may not be available in the ebook version.

Microsoft Excel Data Analysis and Business Modeling

Author: Wayne Winston

Publisher: Microsoft Press

ISBN:

Category: Computers

Page: 984

View: 149

This is the eBook of the printed book and may not include any media, website access codes, or print supplements that may come packaged with the bound book. Master business modeling and analysis techniques with Microsoft Excel 2016, and transform data into bottom-line results. Written by award-winning educator Wayne Winston, this hands on, scenario-focused guide helps you use Excel’s newest tools to ask the right questions and get accurate, actionable answers. This edition adds 150+ new problems with solutions, plus a chapter of basic spreadsheet models to make sure you’re fully up to speed. Solve real business problems with Excel–and build your competitive advantage Quickly transition from Excel basics to sophisticated analytics Summarize data by using PivotTables and Descriptive Statistics Use Excel trend curves, multiple regression, and exponential smoothing Master advanced functions such as OFFSET and INDIRECT Delve into key financial, statistical, and time functions Leverage the new charts in Excel 2016 (including box and whisker and waterfall charts) Make charts more effective by using Power View Tame complex optimizations by using Excel Solver Run Monte Carlo simulations on stock prices and bidding models Work with the AGGREGATE function and table slicers Create PivotTables from data in different worksheets or workbooks Learn about basic probability and Bayes’ Theorem Automate repetitive tasks by using macros

Geographical Information Systems

Principles, Techniques, Management and Applications

Author: Paul Longley

Publisher: John Wiley & Sons Incorporated

ISBN:

Category: Science

Page: 358

View: 102

This book provides a crucial background on basic GIS concepts and addresses the radical shifts and changes that have taken place in GIS technology, and its uses.