Using Microsoft Excel, the market leading spreadsheet package, this book combines theory with modelling aspects and spreadsheet analysis. Microeconomics Using Excel provides students with the tools with which to better understand microeconomic analysis.It focuses on solving microeconomic problems by integrating economic theory, policy analysis and
This unique text uses Microsoft Excel® workbooks to instruct students. In addition to explaining fundamental concepts in microeconomic theory, readers acquire a great deal of sophisticated Excel skills and gain the practical mathematics needed to succeed in advanced courses. In addition to the innovative pedagogical approach, the book features explicitly repeated use of a single central methodology, the economic approach. Students learn how economists think and how to think like an economist. With concrete, numerical examples and novel, engaging applications, interest for readers remains high as live graphs and data respond to manipulation by the user. Finally, clear writing and active learning are features sure to appeal to modern practitioners and their students. The website accompanying the text is found at www.depauw.edu/learn/microexcel.
Microeconomics studies the choices made by individuals under conditions of scarcity of resources and time and the interaction between different decision makers. Scarcity forces economic actors to choose one opportunity among many. Microeconomics with Spreadsheets starts with the mathematical preliminaries and covers consumer theory, producer theory, general equilibrium, game theory, market structure and economics of information.The reader will use numerical tools to analyse problems that cannot be analysed analytically. There is a natural synergy between rigorous proofs and numerical methods, since before using a numerical method one should also prove that a solution exists and analyse whether it is unique, and therefore be able to interpret properly the output of a program.
This is a microeconomic theory book designed for upper-division undergraduate students in economics and agricultural economics. Basic introductory college courses in microeconomics and differential calculus are the assumed prerequisites. The last, tenth, chapter of the book reviews some mathematical principles basic to the other chapters. All of the chapters contain many numerical examples and graphs developed from the numerical examples. The ambitious student could recreate any of the charts and tables contained in the book using a computer and Excel spreadsheets. There are many numerical examples of the key elements of marginal analysis. In addition, many practical examples are taken from the real world to illustrate key points. Most of the examples used in the book come from the food and agricultural industries, broadly defined. Examples in consumer choice and utility focus on consumer decisions to purchase hamburgers and French fries. Production examples involve choices farmers make in order to apply fertilizer to crops. Market models are employed that illustrate consumer choice between beef, pork and chicken at the grocery meat counter, and so on. A few of the examples do not employ agriculturally related goods, such as the examples dealing with the fate of the Polaroid corporation and its instant cameras, monopoly power of cable television providers and competition between the big three automakers in the 1950s. Each chapter begins with material that will be familiar to nearly any student who has passed an introductory microeconomics course. However, as each chapter progresses, the problems and the math required to complete them get tougher. Critical points throughout the text are highlighted in text boxes. The instructor need not use all of the sections of each chapter for a course as each section of each chapter is self-contained. Each chapter concludes with a basic summary of key points and a comprehensive list of terms and definitions. Students might choose to begin by reading the key summary points and definitions at the end of each chapter. Each chapter also contains a spreadsheet exercise for students to create examples similar to the tables and charts in the text.The book is designed for use in a one-semester course, covering the parts of microeconomics that nearly every instructor believes should be covered at the intermediate level, but also recognizing that most instructors will want to devote a few weeks of the semester to material specific to their own interests.David L. Debertin
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
This highly accessible and innovative text with supporting web site uses Excel (R) to teach the core concepts of econometrics without advanced mathematics. It enables students to use Monte Carlo simulations in order to understand the data generating process and sampling distribution. Intelligent repetition of concrete examples effectively conveys the properties of the ordinary least squares (OLS) estimator and the nature of heteroskedasticity and autocorrelation. Coverage includes omitted variables, binary response models, basic time series, and simultaneous equations. The authors teach students how to construct their own real-world data sets drawn from the internet, which they can analyze with Excel (R) or with other econometric software. The accompanying web site with text support can be found at www.wabash.edu/econometrics.
Bowles and Halliday capture the intellectual excitement, analytical precision, and policy relevance of the new microeconomics that has emerged over the past decades. Drawing on themes of the classical economists from Smith through Marx and 20th century writers - including Hayek, Coase, and Arrow - the authors use twenty-first century analytical methods to address enduring challenges in economics. The subtitle of the work - Competition, conflict, and coordination - signals their focus on how the institutions of a modern capitalist economy work, introducing students to recent developments in the microeconomics of credit and labor markets with asymmetric information, a dynamic analysis of how firms compete going beyond price taking, as well as bargaining over the gains from exchange, social norms, and the exercise of power. The new benchmark model proposed by Bowles and Halliday is based on an empirical approach to economic actors and problems. They start from the premise that contracts are incomplete, and that as a result market failures, rather than being a special case illustrated by environmental spillovers, are to be expected in markets for labor, credit, knowledge and throughout the economy. They explain how experiments show that human motivations include ethical as well as other-regarding preferences (rather than entirely self-interested) and explain why the technologies of knowledge-based economies are a source of winner-take-all rather than stable competition. The authors also consider the intrinsic limits of mechanism design and governmental interventions in the economy. Teaching recent developments in microeconomic theory allows the authors to provide students with the tools to analyze and engage in informed debate on the issues that concern them most: climate change, inequality, innovation, and epidemic spread. Tradeoffs are highlighted by providing models in which capitalism can be seen as an "innovation machine" that raises material living standards on average, while at the same time sustaining levels of inequality that many find to be unfair. Digital formats and resources This title is available for students and institutions to purchase in a variety of formats and is supported by online resources. The e-book offers a mobile experience and convenient access to a variety of features that offer extra learning support. It allows students to engage in self-assessment activities, watch video material that further explains figures and mathematics, and offers the opportunity to work with interactive graphs to understand how the models work. Drawing on the authors' decades of teaching the new microeconomics, this title is supported by a range of online resources for students and lecturers including multiple-choice-questions with instant feedback, further mathematical and discussion-based questions, a fully customizable test bank for lecturer use, PowerPoint slides to accompany each chapter, worksheets that can be assigned to the class, and answers to the problems set in the book.
The book covers basic concepts, shows how to set up spreadsheets to solve dynamic allocation problems, and presents economic models for various industries.
Throughout the text of this introduction to benefit cost analysis, emphasis is on applications, and a worked case study is progressively undertaken as an illustration of the analytical principles in operation. The first part covers basic theory and procedures. Part Two advances to material on internationally tradeable goods and projects that affect market prices, and part Three introduces special topics such as the treatment of risk and uncertainty, income distributional effects and the valuation of non-marketed goods. Instructors' resource web site: http://www.uq.edu.au/economics/bca