Practical spreadsheet modeling using @Risk / (Record no. 130264)
[ view plain ]
| 000 -LEADER | |
|---|---|
| fixed length control field | 06219cam a2200529Ii 4500 |
| 001 - CONTROL NUMBER | |
| control field | 9780429056444 |
| 003 - CONTROL NUMBER IDENTIFIER | |
| control field | FlBoTFG |
| 005 - DATE AND TIME OF LATEST TRANSACTION | |
| control field | 20220509193122.0 |
| 006 - FIXED-LENGTH DATA ELEMENTS--ADDITIONAL MATERIAL CHARACTERISTICS--GENERAL INFORMATION | |
| fixed length control field | m o d |
| 007 - PHYSICAL DESCRIPTION FIXED FIELD--GENERAL INFORMATION | |
| fixed length control field | cr cnu|||unuuu |
| 008 - FIXED-LENGTH DATA ELEMENTS--GENERAL INFORMATION | |
| fixed length control field | 191120s2020 flua o 001 0 eng d |
| 040 ## - CATALOGING SOURCE | |
| Original cataloging agency | OCoLC-P |
| Language of cataloging | eng |
| Description conventions | rda |
| -- | pn |
| Transcribing agency | OCoLC-P |
| 020 ## - INTERNATIONAL STANDARD BOOK NUMBER | |
| International Standard Book Number | 9780429056444 |
| -- | (electronic bk.) |
| 020 ## - INTERNATIONAL STANDARD BOOK NUMBER | |
| International Standard Book Number | 0429056443 |
| -- | (electronic bk.) |
| 020 ## - INTERNATIONAL STANDARD BOOK NUMBER | |
| Cancelled/invalid ISBN | 9780367173869 |
| 020 ## - INTERNATIONAL STANDARD BOOK NUMBER | |
| International Standard Book Number | 9780429508707 |
| -- | (electronic bk. : PDF) |
| 020 ## - INTERNATIONAL STANDARD BOOK NUMBER | |
| International Standard Book Number | 0429508700 |
| -- | (electronic bk. : PDF) |
| 020 ## - INTERNATIONAL STANDARD BOOK NUMBER | |
| International Standard Book Number | 9780429509322 |
| -- | (electronic bk. : EPUB) |
| 020 ## - INTERNATIONAL STANDARD BOOK NUMBER | |
| International Standard Book Number | 0429509324 |
| -- | (electronic bk. : EPUB) |
| 035 ## - SYSTEM CONTROL NUMBER | |
| System control number | (OCoLC)1128095585 |
| 035 ## - SYSTEM CONTROL NUMBER | |
| System control number | (OCoLC-P)1128095585 |
| 050 #4 - LIBRARY OF CONGRESS CALL NUMBER | |
| Classification number | HD61 |
| Item number | .L445 2020eb |
| 072 #7 - SUBJECT CATEGORY CODE | |
| Subject category code | BUS |
| Subject category code subdivision | 042000 |
| Source | bisacsh |
| 072 #7 - SUBJECT CATEGORY CODE | |
| Subject category code | MAT |
| Subject category code subdivision | 029000 |
| Source | bisacsh |
| 072 #7 - SUBJECT CATEGORY CODE | |
| Subject category code | KJ |
| Source | bicssc |
| 082 04 - DEWEY DECIMAL CLASSIFICATION NUMBER | |
| Classification number | 658.15/50285554 |
| Edition number | 23 |
| 100 1# - MAIN ENTRY--PERSONAL NAME | |
| Personal name | Lehman, Dale E., |
| Relator term | author. |
| 245 10 - TITLE STATEMENT | |
| Title | Practical spreadsheet modeling using @Risk / |
| Statement of responsibility, etc | Dale E. Lehman, Huybert Groenendaal. |
| 264 #1 - | |
| -- | Boca Raton : |
| -- | CRC Press, Taylor & Francis Group, |
| -- | [2020] |
| 264 #4 - | |
| -- | ©2020 |
| 300 ## - PHYSICAL DESCRIPTION | |
| Extent | 1 online resource : |
| Other physical details | illustrations |
| 336 ## - | |
| -- | text |
| -- | txt |
| -- | rdacontent |
| 337 ## - | |
| -- | computer |
| -- | c |
| -- | rdamedia |
| 338 ## - | |
| -- | online resource |
| -- | cr |
| -- | rdacarrier |
| 500 ## - GENERAL NOTE | |
| General note | "A Chapman & Hall book." |
| 500 ## - GENERAL NOTE | |
| General note | Includes index. |
| 505 0# - FORMATTED CONTENTS NOTE | |
| Formatted contents note | Chapter 1: Conceptual Maps and Models 1.1Introductory Case: MoviePass 1.2 First Steps: Visualization 1.3 Retirement Planning Example 1.4 Good Practices with Spreadsheet Model Construction 1.5 Errors in Spreadsheet Modeling 1.6 Decision Analysis 1.7Conclusion: Best Practices Chapter 1 Exercises Chapter 2: Basic Monte Carlo Simulation in Spreadsheets 2.1 Introductory Case: Retirement Planning 2.2 Risk and Uncertainty 2.3 Scenario Manager 2.4 Monte Carlo Simulation 2.4.1 Generating Random Numbers 2.4.2 Monte Carlo Simulation for MoviePass 2.5 Monte Carlo Simulation Using @Risk 2.6 Monte Carlo Simulation for Retirement Planning 2.7 Presenting Results for Decision Making 2.8 Discrete Event Simulation Chapter 2 Exercises Chapter 3: Selecting Distributions 3.1 First Introductory Case: Valuation of a public company using expert opinion 3.2 Modeling Expert Opinion in the Valuation Model 3.3 Second Introductory Case: Value at Risk - fitting distributions to data 3.4 Distribution Fitting for VaR - Parameter and Model Uncertainty 3.4.1 Parameter Uncertainty 3.4.2 Model Uncertainty 3.5 Third Introductory Case: Failure Distributions 3.6 Commonly Used Discrete Distributions 3.7 Commonly Used Continuous Distributions 3.8 A Brief Decision Guide for Selecting Distributions Chapter 3 Exercises Chapter 4: Modeling Relationships 4.1 First Example: Drug Development 4.2 Second Example: Collateralized Debt Obligations 4.3 Multiple Correlations Example: Cockpit Failures 4.4 Copulas example: How correlated are home prices? 4.5 Empirical Copulas 4.6 Fifth Example: Advertising Effectiveness 4.7 Regression Modeling 4.8 Simulation within Regression Models 4.9 Multiple Linear Regression Models 4.10 The Envelope Method 4.11 Summary Chapter 4 Exercises Chapter 5: Time Series Models 5.1 The Need for Time Series Analysis: A Tale of Two Series 5.2 Introductory Case: Air Travel and September 11 5.3 Analyzing the Air Traffic Data and 9/11 5.4 Second Example: Stock Prices 5.5 Types of Time Series Models 5.6 Third Example: Soybean Prices 5.7 Fourth Example: Home Prices and Multivariate Time Series Chapter 5 Exercises Chapter 6: Additional Useful Techniques 6.1 Advanced Sensitivity Analysis 6.2 Stress Testing 6.3 Non-parametric Distributions 6.4 Case: an Insurance Problem 6.5 Frequency and Severity 6.6 The Compound Distribution 6.7 Uncertainty and Variability 6.8 Bayesian Analysis Chapter 6 Exercises Chapter 7: Optimization and Decision Making 7.1 Introductory Case: Airline Seat Pricing 7.2 A Simulation Model of the Airline Pricing Problem 7.3 A Simulation Table to Explore Pricing Strategies 7.4 An Optimization Solution to the Airline Pricing Problem 7.5 Optimization with Multiple Decision Variables 7.6 Adding Constraints 7.7 Efficient Frontier 7.8 Stochastic Dominance 7.9 Summary Chapter 7 Exercises Appendix: Risk Analysis in Projects |
| 520 ## - SUMMARY, ETC. | |
| Summary, etc | Practical Spreadsheet Modeling Using @Risk provides a guide of how to construct applied decision analysis models in spreadsheets. The focus is on the use of Monte Carlo simulation to provide quantitative assessment of uncertainties and key risk drivers. The book presents numerous examples based on real data and relevant practical decisions in a variety of settings, including health care, transportation, finance, natural resources, technology, manufacturing, retail, and sports and entertainment. All examples involve decision problems where uncertainties make simulation modeling useful to obtain decision insights and explore alternative choices. Good spreadsheet modeling practices are highlighted. The book is suitable for graduate students or advanced undergraduates in business, public policy, health care administration, or any field amenable to simulation modeling of decision problems. The book is also useful for applied practitioners seeking to build or enhance their spreadsheet modeling skills. Features Step-by-step examples of spreadsheet modeling and risk analysis in a variety of fields Description of probabilistic methods, their theoretical foundations, and their practical application in a spreadsheet environment Extensive example models and exercises based on real data and relevant decision problems Comprehensive use of the @Risk software for simulation analysis, including a free one-year educational software license |
| 588 ## - | |
| -- | OCLC-licensed vendor bibliographic record. |
| 650 #7 - SUBJECT ADDED ENTRY--TOPICAL TERM | |
| Topical term or geographic name as entry element | BUSINESS & ECONOMICS / Management Science |
| Source of heading or term | bisacsh |
| 650 #7 - SUBJECT ADDED ENTRY--TOPICAL TERM | |
| Topical term or geographic name as entry element | MATHEMATICS / Probability & Statistics / General |
| Source of heading or term | bisacsh |
| 650 #0 - SUBJECT ADDED ENTRY--TOPICAL TERM | |
| Topical term or geographic name as entry element | Risk management. |
| 650 #0 - SUBJECT ADDED ENTRY--TOPICAL TERM | |
| Topical term or geographic name as entry element | Risk management |
| General subdivision | Mathematical models. |
| 650 #0 - SUBJECT ADDED ENTRY--TOPICAL TERM | |
| Topical term or geographic name as entry element | Electronic spreadsheets. |
| 700 1# - ADDED ENTRY--PERSONAL NAME | |
| Personal name | Groenendaal, Huybert, |
| Relator term | author. |
| 856 40 - ELECTRONIC LOCATION AND ACCESS | |
| Materials specified | Taylor & Francis |
| Uniform Resource Identifier | https://www.taylorfrancis.com/books/9780429056444 |
| 856 42 - ELECTRONIC LOCATION AND ACCESS | |
| Materials specified | OCLC metadata license agreement |
| Uniform Resource Identifier | http://www.oclc.org/content/dam/oclc/forms/terms/vbrl-201703.pdf |
No items available.