{"id":1651,"date":"2015-11-05T15:51:09","date_gmt":"2015-11-05T15:51:09","guid":{"rendered":"http:\/\/sites.berry.edu\/wmixon\/?page_id=1651"},"modified":"2015-11-09T22:16:22","modified_gmt":"2015-11-09T22:16:22","slug":"economics-in-excel","status":"publish","type":"page","link":"https:\/\/sites.berry.edu\/wmixon\/home\/economics-in-excel\/","title":{"rendered":"Economics in Excel"},"content":{"rendered":"<p>This page provides links to three distinct sets of material. The first is to <strong>courses<\/strong>. We have integrated <i>Excel<\/i> into a Principles of Economics course (microeconomic emphasis) and an International Economics course. The second set of references is to \u00a0our\u00a0<strong>published papers<\/strong> that relate predominantly to the materials developed for these courses. Finally, we include a set of links\u00a0to other sites with similar material. (&#8220;Our&#8221; refers to Wilson Mixon and coauthors: Soumaya Tohamy, W. D. Sockwell, and B. N. Hopkins.)<\/p>\n<p>&nbsp;<\/p>\n<hr \/>\n<p><strong>Courses<\/strong><\/p>\n<p>We (Mixon and Tohamy) have used <em>Excel<\/em> workbooks and ancillary material in Principles of Microeconomics \u00a0and in International Economics. In each case, the approach is to write a Study Guide for each chapter. The Study Guide provides a set of instructions, directing the user to open a specific workbook and to conduct and report the results of specific exercises. We often use the workbooks in class to illustrate the relevant principles.<\/p>\n<p><span style=\"text-decoration: underline\">Principles of Economics<\/span>. The material in this course is primarily microeconomic. The text for the course is Gwartney, Stroup, Sobel, and Macpherson, <em>Economics<\/em>, 10th ed. The workbooks correspond to chapters in that text, with each worksheet corresponding to a graph. Using Excel allows students to introduce changes and examine the effects of these changes.<\/p>\n<p>Most of the microeconomic material in Mankiw&#8217;s text is also available. This material was developed for the 1st edition.<\/p>\n<p><span style=\"text-decoration: underline\">International Economics<\/span>. This page provides access to <em>Exce<\/em>l-based counterparts to all graphs in selected chapters of Krugman and Obstfeld, <em>International Economics: Theory and Policy<\/em> (5th ed.).<\/p>\n<hr \/>\n<p><strong>Published Papers<\/strong><br \/>\nMost of these papers relate to material developed for use in the two courses above. An exception is the paper on the CES utility function.<\/p>\n<ul>\n<li>&#8220;The Heckscher-Ohlin Model with Variable Input Coefficients in Spreadsheets,&#8221; <em>Computers in Higher Education Economics Review<\/em>, 13 (1999). Develops the Heckscher-Ohlin model. The article is based on a workbook that follows the development of Krugman and Obstfeld, <em>International Economics<\/em>. The paper is <a href=\"http:\/\/www.economicsnetwork.ac.uk\/cheer\/ch14_2\/mixon.htm\" target=\"_blank\">here<\/a>. \u00a0The workbook is <a href=\"http:\/\/sites.berry.edu\/wmixon\/wp-content\/uploads\/sites\/75\/2015\/11\/KO4_HeckscherOhlin1.xls\">here<\/a>.<\/li>\n<li>&#8220;Using Microsoft Excel to Illustrate Gains from Trade,&#8221; <em>Business Quest<\/em> (2000). The paper and the workbook develop the simple Ricardian model of trade, showing how specialization according to comparative advantage increases total product. \u00a0Both the paper and the workbook are <a href=\"http:\/\/www.westga.edu\/~bquest\/2000\/excel.html\" target=\"_blank\">here<\/a>. A slightly different development that follows Krugman and Obstfeld, International Economics is <a href=\"http:\/\/sites.berry.edu\/wmixon\/wp-content\/uploads\/sites\/75\/2015\/11\/KO_2_OneFactorEconomy.xls\">here<\/a>.<\/li>\n<li>&#8220;Using Microsoft Excel in Principles of Economics,&#8221; <em>Computers in Higher Education Economics Review<\/em>, 14 (2001), <a href=\"http:\/\/www.economicsnetwork.ac.uk\/cheer\/ch14_2\/mixon.htm\">here<\/a>. The paper shows how <em>Excel<\/em> is being used in principles of economics. Most of the graphs used in the microeconomics chapters of texts by Gwartney, Stroup, Sobel, and Macpherson; and by Mankiw are used in our principles course. See <strong>Courses<\/strong> above.<br \/>\n&#8220;Cost Curves and How They Relate,&#8221; <em>Journal of Economic Education<\/em>, 33 (2002), 89. The <em>JEE<\/em> publishes an abstract of this article. The article (<a href=\"https:\/\/www.dropbox.com\/s\/juesu04m5jy0ser\/CostCurves.htm?dl=0\">here<\/a>) contains references to these workbooks used to draw the various long-run and short-run cost curves:\u00a0<a href=\"http:\/\/sites.berry.edu\/wmixon\/wp-content\/uploads\/sites\/75\/2015\/11\/CostCurves_Basic.xls\">CostCurves_Basic<\/a>, <a href=\"http:\/\/sites.berry.edu\/wmixon\/wp-content\/uploads\/sites\/75\/2015\/11\/CostCurves_quadratic_AVC.xls\">CostCurves_quadratic_AVC<\/a>, and <a href=\"http:\/\/sites.berry.edu\/wmixon\/wp-content\/uploads\/sites\/75\/2015\/11\/CostCurves_w_revenue.xls\">CostCurves_w_revenue<\/a>. The links in the article may be broken, so access the workbooks with the three links provided above.<\/li>\n<li>&#8220;Comparing Trade Instruments Using Spreadsheets,&#8221; <em>Social Science Computer Review<\/em>, 20 (2002), Summer: 197 &#8211; 193. A <em>Microsoft Word<\/em> version of the material on which the \u00a0paper is based is\u00a0<a href=\"http:\/\/sites.berry.edu\/wmixon\/wp-content\/uploads\/sites\/75\/2015\/11\/KO8_TradePolicyInstruments.doc\">here<\/a>. The workbook on which the article is based is <a href=\"http:\/\/sites.berry.edu\/wmixon\/wp-content\/uploads\/sites\/75\/2015\/11\/KO8_TradePolicyInstruments.xls\">here<\/a>.<\/li>\n<li>&#8220;Lessons from the Specific Factors Model of International Trade.&#8221; <em>Journal of Economic Education<\/em> (2003): Vol. 34, No. 2. This paper is based on the development in Krugman and Obstfeld, <em>International Economics<\/em>. The <em>Microsoft Word<\/em> version of the document is <a href=\"http:\/\/sites.berry.edu\/wmixon\/wp-content\/uploads\/sites\/75\/2015\/11\/specific-factors-in-excel.doc\">here<\/a>\u00a0and\u00a0the workbook upon which it is based is <a href=\"http:\/\/sites.berry.edu\/wmixon\/wp-content\/uploads\/sites\/75\/2015\/11\/SpecificFactors.xls\">here<\/a>. A PDF version is available at the <em>JEE<\/em> website.<\/li>\n<li>\u201cIllustrating Consumer Theory with the CES Utility Function.\u201d <em>Journal of Economic Education<\/em> (2004): Vol 35, No. 3. The Microsoft Word version of the document is <a href=\"http:\/\/sites.berry.edu\/wmixon\/wp-content\/uploads\/sites\/75\/2015\/11\/CES_tohamy_mixon_JEE1.doc\">here<\/a>, and the workbook upon which the paper is based is <a href=\"http:\/\/sites.berry.edu\/wmixon\/wp-content\/uploads\/sites\/75\/2015\/11\/CES_JEE.xls\">here<\/a>.<\/li>\n<li>\u201cAnalyzing Subsidies in Microsoft Excel.\u201d <em>Journal of Economic Education<\/em> (2005): Vol. 36, No. 2 is an abstract for this paper, <a href=\"https:\/\/www.dropbox.com\/s\/52uzrif78eqnwyk\/subsidies.html?dl=0\">here<\/a>. The document is here. The document contains links to two workbooks that illustrate the relevant principles. The workbooks treat a fixed-quantity subsidy (<a href=\"http:\/\/sites.berry.edu\/wmixon\/wp-content\/uploads\/sites\/75\/2015\/11\/schooling_subsidy1.xls\">here<\/a>) and a variable-quantity subsidy (<a href=\"http:\/\/sites.berry.edu\/wmixon\/wp-content\/uploads\/sites\/75\/2015\/11\/housing_subsidy1.xls\">here<\/a>). The links in this web page are broken. Please open the relevant workbooks and follow the text.<\/li>\n<li>\u201cAnalysing the Effects of Excise Taxes Using Microsoft Excel,\u201d with Bradley N. Hopkins. <em>Computers in Higher Education Economics Review<\/em> (2006), Vol. 18. The document is <a href=\"http:\/\/www.economicsnetwork.ac.uk\/cheer\/ch18\/mixon.pdf\">here<\/a>.\u00a0The workbook is <a href=\"http:\/\/sites.berry.edu\/wmixon\/wp-content\/uploads\/sites\/75\/2015\/11\/TaxationIncidence.xls\">here<\/a>.<\/li>\n<li>\u201cThe Solow Growth Model: An Excel-Based Primer,\u201d with William D. Sockwell. <em>Journal of Economic Education<\/em> (2007), Vol. 38, Issue 4. The document is <a href=\"http:\/\/www.tandfonline.com\/doi\/abs\/10.3200\/JECE.38.4.483?journalCode=vece20\">here<\/a>. The workbook is\u00a0<a href=\"http:\/\/sites.berry.edu\/wmixon\/wp-content\/uploads\/sites\/75\/2015\/11\/solowmodel.xls\">here<\/a>. A primer based on the workbook is <a href=\"http:\/\/sites.berry.edu\/wmixon\/wp-content\/uploads\/sites\/75\/2015\/11\/SolowPrimer.pdf\">here<\/a>.<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>This page provides links to three distinct sets of material. The first is to courses. We have integrated Excel into a Principles of Economics course (microeconomic emphasis) and an International [&hellip;]<\/p>\n","protected":false},"author":65,"featured_media":0,"parent":7,"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-1651","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/sites.berry.edu\/wmixon\/wp-json\/wp\/v2\/pages\/1651","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=1651"}],"version-history":[{"count":22,"href":"https:\/\/sites.berry.edu\/wmixon\/wp-json\/wp\/v2\/pages\/1651\/revisions"}],"predecessor-version":[{"id":1716,"href":"https:\/\/sites.berry.edu\/wmixon\/wp-json\/wp\/v2\/pages\/1651\/revisions\/1716"}],"up":[{"embeddable":true,"href":"https:\/\/sites.berry.edu\/wmixon\/wp-json\/wp\/v2\/pages\/7"}],"wp:attachment":[{"href":"https:\/\/sites.berry.edu\/wmixon\/wp-json\/wp\/v2\/media?parent=1651"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}