{"id":1673,"date":"2015-11-06T20:55:16","date_gmt":"2015-11-06T20:55:16","guid":{"rendered":"http:\/\/sites.berry.edu\/wmixon\/?page_id=1673"},"modified":"2015-11-07T19:46:23","modified_gmt":"2015-11-07T19:46:23","slug":"microprinciples-gwartney-et-al","status":"publish","type":"page","link":"https:\/\/sites.berry.edu\/wmixon\/home\/economics-in-excel\/microprinciples-gwartney-et-al\/","title":{"rendered":"MicroPrinciples"},"content":{"rendered":"

Principles of Microeconomics: Study Guide<\/strong><\/p>\n

Excel-based counterparts to all graphs in the chapters of Gwartney, Stroup, Sobel, and Macpherson Economics may be accessed below. For each chapter we provide an Excel workbook and a set of questions to guide users through the worksheets. The study guides are Word documents. The links to the individual workbooks and associated assignment sheets follow the chapter overviews below.<\/p>\n

A similar set of exercises based on chapters from Mankiw, Economics, is available below.<\/p>\n

Chapter 1. Appendix\u00a0<\/strong><\/p>\n

This material follows the text quite closely, using Excel workbooks to illustrate the graphical analysis that the text develops. Click here<\/a> for the Study Guide and \u00a0here<\/a>\u00a0for the workbook.<\/p>\n

Chapter 3.\u00a0 Supply, Demand, and the\u00a0 Market Process<\/strong><\/p>\n

The Study Guide covers three related topics: Demand, Supply, and Market Equilibrium. Each of those topics is treated in a separate workbook. Click here<\/a> for the Study Guide.<\/p>\n

The first workbook examines demand. It develops the concepts of the demand curve and consumer surplus. It examines the distinction between a change in demand and a change in the quantity demanded. It shows the distinction between an elastic demand curve and an inelastic demand curve. Finally, it examines some of the factors that shift a demand curve. Click here<\/a>\u00a0for the demand workbook.<\/p>\n

The second workbook examines supply. It develops the concepts of the supply curve and producer surplus. It examines the distinction between a change in supply and a change in the quantity supplied. It shows the distinction between an elastic supply curve and an inelastic supply curve. Finally, it examines some of the factors that shift a supply curve. Click here<\/a>\u00a0for the supply workbook.<\/p>\n

The third workbook examines market equilibrium. It shows how markets can result in an efficient quantity of a good being produced. It also examines the effect of changes in demand and supply on market equilibrium. Click here<\/a>\u00a0for the market equilibrium workbook.<\/p>\n

Chapter 4. Supply and Demand: Applications and Extensions<\/strong><\/p>\n

This chapter extends the analysis of markets to consider the relationship between product markets and markets for resources used to produce those goods or services. It examines the market for loanable funds where the “price” is the interest rate, and the market for foreign exchange. It also examines the effects of policies designed to keep the price above or below the price that would result in market equilibrium. Finally, it applies the analysis to the impact of taxes. Click here<\/a>\u00a0for the Study Guide and here<\/a>\u00a0for the workbook.<\/p>\n

Chapter 5. The Economic Role of Government<\/strong><\/p>\n

This chapter examines the economic roles played by government. Two of these roles are to address concerns in which markets lead to quantities that are not efficient, as defined in Chapter 3. One reason is less than perfect competition — “rigged” markets. The other is the existence of external costs or external benefits associated with the production and consumption of some goods. Click here<\/a>\u00a0for the Study Guide and here<\/a>\u00a0for the workbook.<\/p>\n

Chapter 17. Gaining from International Trade<\/strong><\/p>\n

This chapter shows gains from exchange, based on the principle of Comparative Advantage. Shows gains and losses in specific domestic industries when those industries are open to international trade. Demonstrates the effects of imposing tariffs and quotas–who loses, who gains, and the reasons for a deadweight loss. Click here<\/a>\u00a0for the Study Guide and here<\/a>\u00a0for the workbook.<\/p>\n

Chapter 18. International Finance and the Foreign Exchange Market<\/strong><\/p>\n

This chapter uses the demand\/supply framework to analyze aspects of the market for foreign currencies. Click here<\/a>\u00a0for the workbook.<\/p>\n

Chapter 20. Costs and the Supply of Goods<\/strong><\/p>\n

This chapter shows how a firm’s cost relates to its output. Begins with an overview of types of cost–fixed and variable. Introduces the production function, from which costs are derived. Develops the following cost-curve relations: total cost, total variable cost; average total cost, average variable cost, marginal cost, average fixed cost. Click here<\/a>\u00a0for the Study Guide and here<\/a>\u00a0for the workbook.<\/p>\n

Chapter 21. Price Takers and the Competitive Process <\/strong><\/p>\n

This chapter shows how price taking firms act in order to maximize profits, and how firms’ behavior relates to that of the market in which the firms are located. Uses cost information (especially marginal cost) to develop the reasoning behind a price-taking firm’s supply curve. Analyzes the connection between the firm and market in the short run and in the long run, thus developing the logic of the short-run and long-run industry supply curves. Click here<\/a>\u00a0for the Study Guide and here<\/a>\u00a0for the workbook.<\/p>\n

Chapter 22. Price-Searcher Markets with Low Entry Barriers<\/strong><\/p>\n

This chapter shows how price-searching (aka, price-making) firms act in order to maximize profits. Develops the concept of marginal revenue and shows how marginal revenue and marginal cost define the profit-maximizing output level. Develops the implications of free entry and exit (low barriers to entry). Introduces price discrimination. Click here<\/a>\u00a0for the Study Guide and here<\/a>\u00a0for the workbook.<\/p>\n

Chapter 23. Price-Searcher Markets with High Entry Barriers <\/strong><\/p>\n

This chapter considers two cases. In the first, a monopoly (single seller) is the only firm in the market. In the second, a few firms are in the industry. In this case “few” means a small enough number that the effect of each firm’s decisions regarding price and quantity appreciably affect the other firms. Click here<\/a>\u00a0for the Study Guide and here<\/a>\u00a0for the workbook.<\/p>\n

Chapter 24. The Supply of and Demand for Productive Resources<\/strong><\/p>\n

This chapter applies the basic market model to markets for productive resources. It shows some of the ways that the supply and\/or demand for a specific type of resource resemble and differ from other markets. Click here<\/a>\u00a0for the Study Guide and here<\/a>\u00a0for the workbook.<\/p>\n

 <\/p>\n

\n
\n

Material for Mankiw’s Economics<\/em> text, 2nd edition.<\/strong><\/p>\n

Excel-based counterparts to all graphs in selected chapters of Mankiw’s Economics may be accessed below. For each chapter we provide an Excel workbook and a set of questions to guide users through the worksheets. The study guides are Word documents. The links to the individual workbooks and associated assignment sheets follow the chapter overviews below. Obviously, this material is dated, but Mankiw does offer some useful insights that might warrant looking at these workbook.<\/p>\n

Chapter 2. Appendix (Graphing: A Brief Review). The workbook follows the mathematical appendix. It offers Excel counterparts to the graphs that Mankiw develops.
\n2. Study Guide\u00a0Click here<\/a>
\n2. Workbook\u00a0Click here<\/a><\/p>\n

Chapter 4. Demand, Supply, and Market Equilibrium. The Study Guide covers Demand, Supply, and Market Equilibrium. Each of those topics is treated in a separate workbook.
\n4. Study Guide\u00a0Click here<\/a>
\n4. Demand workbook. This workbook examines demand. Click here<\/a>
\n4. Supply workbook. This workbook examines supply.4.\u00a0Click here<\/a>
\n4. Market: Demand, Supply, and Equilibrium workbook. This workbook examines market equilibrium.\u00a0Click here<\/a><\/p>\n

Chapter 5. Elasticity and Its Application. Develops the concepts of price elasticity of demand and supply and of income elasticity of demand.
\n5. Workbook\u00a0Click here<\/a>
\n5. Study Guide\u00a0Click here<\/a><\/p>\n

Chapter 6. Supply, Demand, and Government Policies. The Study Guide covers both price controls and taxes. Each of those topics is treated in a separate workbook.
\n6. Study Guide.\u00a0Click here<\/a>
\n6. Controls workbook.\u00a0Click here<\/a>
\n6. Taxes workbook.\u00a0Click here<\/a><\/p>\n

Chapter 7. Consumers, Producers, and the Efficiency of Markets. Develops consumer surplus and producer surplus concepts. Shows how intersection of demand and supply can lead to maximum total (consumer plus producer) surplus.
\n7. Study Guide.\u00a0Click here<\/a>
\n7. Workbook. Click here<\/a><\/p>\n

Chapter 8. Application: The Costs of Taxation. Develops the effects of taxation on economic efficiency.
\n8.\u00a0Study Guide.\u00a0Click here<\/a>
\n8. Workbook.\u00a0Click here<\/a><\/p>\n

Chapter 9. International Trade. Shows gains and losses from international trade in specific industries, along with the effects of tariffs and quotas.
\n9. Study Guide.\u00a0Click here<\/a>
\n9. Workbook.\u00a0Click here<\/a><\/p>\n

Chapter 10. Externalities. Shows how the existence of externalities causes market solutions to be less than perfectly efficient. Shows how government policies might result in increased efficiency.
\n10.\u00a0Study Guide.\u00a0Click here<\/a>
\n10. Workbook\u00a0Click here<\/a><\/p>\n

Chapter 13. The Costs of Production.
\n13.\u00a0Study Guide.\u00a0Click here<\/a>
\n13.\u00a0Workbook.\u00a0Click here<\/a><\/p>\n

Chapter 14. Firms in Competitive Markets.
\n14.\u00a0Study Guide.\u00a0Study Guide<\/a>
\n14. Study Guide.\u00a0Click here<\/a><\/p>\n

Chapter 15. Monopoly.
\n15.\u00a0Study Guide.\u00a0Click here<\/a>
\n15. Workbook.\u00a0Click here<\/a><\/p>\n

Chapter 18. The Markets for the Factors of Production.
\n18. Study Guide.\u00a0Click here<\/a>
\n18. Workbook.\u00a0Click here<\/a><\/p>\n

Chapter 30. A Macroeconomic Theory of the Open Economy.
\n30.\u00a0Study Guide.\u00a0Click here<\/a>
\n30. Workbook.\u00a0Click here<\/a><\/p>\n

 <\/p>\n","protected":false},"excerpt":{"rendered":"

Principles of Microeconomics: Study Guide Excel-based counterparts to all graphs in the chapters of Gwartney, Stroup, Sobel, and Macpherson Economics may be accessed below. For each chapter we provide an […]<\/p>\n","protected":false},"author":65,"featured_media":0,"parent":1651,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"site-container-style":"default","site-container-layout":"default","site-sidebar-layout":"default","site-transparent-header":"default","disable-article-header":"default","disable-site-header":"default","disable-site-footer":"default","disable-content-area-spacing":"default","footnotes":""},"class_list":["post-1673","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/sites.berry.edu\/wmixon\/wp-json\/wp\/v2\/pages\/1673","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sites.berry.edu\/wmixon\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/sites.berry.edu\/wmixon\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/sites.berry.edu\/wmixon\/wp-json\/wp\/v2\/users\/65"}],"replies":[{"embeddable":true,"href":"https:\/\/sites.berry.edu\/wmixon\/wp-json\/wp\/v2\/comments?post=1673"}],"version-history":[{"count":18,"href":"https:\/\/sites.berry.edu\/wmixon\/wp-json\/wp\/v2\/pages\/1673\/revisions"}],"predecessor-version":[{"id":1692,"href":"https:\/\/sites.berry.edu\/wmixon\/wp-json\/wp\/v2\/pages\/1673\/revisions\/1692"}],"up":[{"embeddable":true,"href":"https:\/\/sites.berry.edu\/wmixon\/wp-json\/wp\/v2\/pages\/1651"}],"wp:attachment":[{"href":"https:\/\/sites.berry.edu\/wmixon\/wp-json\/wp\/v2\/media?parent=1673"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}