Models for Life : An Introduction to Discrete Mathematical Modeling with Microsoft Office Excel.

Intro -- TITLE PAGE -- TABLE OF CONTENTS -- EXCEL TABLE OF CONTENTS -- PREFACE -- HOW TO USE THIS BOOK -- ACKNOWLEDGMENTS -- 1 DENSITY-INDEPENDENT POPULATION MODELS -- 1.1 EXPONENTIAL GROWTH -- 1.2 EXPONENTIAL GROWTH WITH STOCKING OR HARVESTING -- 1.3 TWO FUNDAMENTAL EXCEL TECHNIQUES -- 1.4 EXPLICIT FORMULAS -- 1.5 EQUILIBRIUM VALUES AND STABILITY -- 2 PERSONAL FINANCE -- 2.1 COMPOUND INTEREST AND SAVINGS -- 2.2 BORROWING FOR MAJOR PURCHASES -- 2.3 CREDIT CARDS -- 2.4 THE TIME VALUE OF MONEY: PRESENT VALUE -- 2.5 CAR LEASES -- 3 COMBAT MODELS -- 3.1 LANCHESTER COMBAT MODEL -- 3.2 PHASE PLANE GRAPHS -- 3.3 THE LANCHESTER MODEL WITH REINFORCEMENTS -- 3.4 HUGHES AIMED FIRE SALVO MODEL -- 3.5 ARMSTRONG SALVO MODEL WITH AREA FIRE -- 4 THE SPREAD OF INFECTIOUS DISEASES -- 4.1 THE S-I-R MODEL -- 4.2 S-I-R WITH VITAL DYNAMICS -- 4.3 DETERMINING PARAMETERS FROM REAL DATA -- 4.4 S-I-R WITH VITAL DYNAMICS AND ROUTINE VACCINATIONS -- 5 DENSITY-DEPENDENT POPULATION MODELS -- 5.1 THE DISCRETE LOGISTIC MODEL -- 5.2 LOGISTIC GROWTH WITH ALLEE EFFECTS -- 5.3 LOGISTIC GROWTH WITH HARVESTING -- 5.4 THE DISCRETE LOGISTIC MODEL AND CHAOS -- 5.5 THE RICKER MODEL -- 6 BLOOD ALCOHOL CONCENTRATION AND PHARMACOKINETICS -- 6.1 BLOOD ALCOHOL CONCENTRATION -- 6.2 THE WIDMARK MODEL -- 6.3 THE WAGNER MODEL -- 6.4 ALCOHOL CONSUMPTION PATTERNS -- 6.5 MORE GENERAL DRUG ELIMINATION -- 6.6 THE VOLUME OF DISTRIBUTION -- 6.7 COMMON DRUGS -- 7 RANKING METHODS -- 7.1 INTRODUCTION TO MARKOV MODELS -- 7.2 RANKING SPORTS TEAMS -- 7.3 GOOGLE PAGERANK -- 8 BODY WEIGHT AND BODY COMPOSITION -- 8.1 CONSTANT CALORIE EXPENDITURE -- 8.2 VARIABLE CALORIE EXPENDITURE -- 8.3 HEALTH METRICS -- 8.4 BODY COMPOSITION -- 8.5 THE BODY COMPOSITION MODEL FOR BODY WEIGHT -- 8.6 POINTS-BASED SYSTEMS: THE WEIGHT WATCHERS MODEL -- APPENDIX A: THE GEOMETRIC SERIES FORMULA.

APPENDIX B: LANCHESTER'S SQUARE LAW AND THE FRACTIONAL EXCHANGE RATIO -- APPENDIX C: DERIVATION OF THE FER = 1 LINE FOR THE HUGHES SALVO MODEL -- APPENDIX D: THE WAITING TIME PRINCIPLE -- APPENDIX E: CREATING COBWEB DIAGRAMS IN EXCEL -- APPENDIX F: PROPORTION OF TOTAL CREDIT DISTRIBUTED DOES NOT EXCEED 1 -- BIBLIOGRAPHY -- INDEX -- END USER LICENSE AGREEMENT.

Description based on publisher supplied metadata and other sources.

Electronic reproduction. Ann Arbor, Michigan : ProQuest Ebook Central, 2024. Available via World Wide Web. Access may be limited to ProQuest Ebook Central affiliated libraries.