IDEAS home Printed from https://ideas.repec.org/a/sej/ancoec/v663y2000p770-792.html
   My bibliography  Save this article

Exploring Economic Models Using Excel

Author

Listed:
  • Miles Cahill
  • George Kosicki

Abstract

This paper applies spreadsheet software to intermediate-level consumer theory concepts. Spreadsheets help make the concepts more accessible while allowing students to explore the ideas in more depth. Areas of application are utility functions, income and substitution effects, price indices, measures of welfare change, and the optimal saving rate. We chose the examples to stimulate awareness and discussion of the many classroom uses for four important Excel spreadsheet tools: three-dimensional (3-D) graphs, iteration, Goal Seek, and Solver.

Suggested Citation

  • Miles Cahill & George Kosicki, 2000. "Exploring Economic Models Using Excel," Southern Economic Journal, Southern Economic Association, vol. 66(3), pages 770-792, January.
  • Handle: RePEc:sej:ancoec:v:66:3:y:2000:p:770-792
    as

    Download full text from publisher

    To our knowledge, this item is not available for download. To find whether it is available, there are three options:
    1. Check below whether another version of this item is available online.
    2. Check on the provider's web page whether it is in fact available.
    3. Perform a search for a similarly titled item that would be available.

    References listed on IDEAS

    as
    1. Baumol, William J, 1982. "Contestable Markets: An Uprising in the Theory of Industry Structure," American Economic Review, American Economic Association, pages 1-15.
    2. Ray, Subhash C & Desli, Evangelia, 1997. "Productivity Growth, Technical Progress, and Efficiency Change in Industrialized Countries: Comment," American Economic Review, American Economic Association, pages 1033-1039.
    3. Banker, Rajiv D., 1984. "Estimating most productive scale size using data envelopment analysis," European Journal of Operational Research, Elsevier, vol. 17(1), pages 35-44, July.
    4. Lau, Lawrence J, 1972. "Profit Functions of Technologies with Multiple Inputs and Outputs," The Review of Economics and Statistics, MIT Press, pages 281-289.
    5. W. Briec, 1997. "A Graph-Type Extension of Farrell Technical Efficiency Measure," Journal of Productivity Analysis, Springer, pages 95-110.
    6. Robert Russell, R., 1985. "Measures of technical efficiency," Journal of Economic Theory, Elsevier, vol. 35(1), pages 109-126, February.
    7. Chambers, Robert G. & Chung, Y. & Fare, R., 1996. "Profit, Directional Distance Functions, and Nerlovian Efficiency," Working Papers 197837, University of Maryland, Department of Agricultural and Resource Economics.
    8. Fare, Rolf & Shawna Grosskopf & Mary Norris & Zhongyang Zhang, 1994. "Productivity Growth, Technical Progress, and Efficiency Change in Industrialized Countries," American Economic Review, American Economic Association, pages 66-83.
    9. Forsund, Finn R. & Lovell, C. A. Knox & Schmidt, Peter, 1980. "A survey of frontier production functions and of their relationship to efficiency measurement," Journal of Econometrics, Elsevier, pages 5-25.
    10. Luenberger, David G., 1992. "Benefit functions and duality," Journal of Mathematical Economics, Elsevier, vol. 21(5), pages 461-481.
    11. Caves, Douglas W & Christensen, Laurits R & Diewert, W Erwin, 1982. "Multilateral Comparisons of Output, Input, and Productivity Using Superlative Index Numbers," Economic Journal, Royal Economic Society, vol. 92(365), pages 73-86, March.
    12. Caves, Douglas W & Christensen, Laurits R & Diewert, W Erwin, 1982. "The Economic Theory of Index Numbers and the Measurement of Input, Output, and Productivity," Econometrica, Econometric Society, vol. 50(6), pages 1393-1414, November.
    13. Banker, Rajiv D & Maindiratta, Ajay, 1988. "Nonparametric Analysis of Technical and Allocative Efficiencies in Production," Econometrica, Econometric Society, vol. 56(6), pages 1315-1332, November.
    14. Seiford, Lawrence M. & Thrall, Robert M., 1990. "Recent developments in DEA : The mathematical programming approach to frontier analysis," Journal of Econometrics, Elsevier, pages 7-38.
    15. Diewert, W. E., 1976. "Exact and superlative index numbers," Journal of Econometrics, Elsevier, pages 115-145.
    16. Chambers, Robert G. & Chung, Yangho & Fare, Rolf, 1996. "Benefit and Distance Functions," Journal of Economic Theory, Elsevier, vol. 70(2), pages 407-419, August.
    17. Bauer, Paul W., 1990. "Recent developments in the econometric estimation of frontiers," Journal of Econometrics, Elsevier, pages 39-56.
    Full references (including those not matched with items on IDEAS)

    Citations

    Citations are extracted by the CitEc Project, subscribe to its RSS feed for this item.
    as


    Cited by:

    1. Reza Oladi & John Gilbert, 2006. "A Simulation Experiment of a Customs Union," Computers in Higher Education Economics Review, Economics Network, University of Bristol, vol. 18(1), pages 29-33.
    2. Arthur Caplan & John Gilbert, 2006. "Interactive Scenario Analysis of Exhaustible Resource Problems," Computers in Higher Education Economics Review, Economics Network, University of Bristol, vol. 18(1), pages 4-9.
    3. Holger Strulik, 2004. "Solving Rational Expectations Models Using Excel," The Journal of Economic Education, Taylor & Francis Journals, pages 269-283.
    4. Charles E. Hegji, 2000. "Demonstrating Cournot and Collusive equilibria using computer spreadsheets," Managerial and Decision Economics, John Wiley & Sons, Ltd., vol. 21(7), pages 305-312.
    5. Axelsen, Dan & Snarr, Hal W. & Friesner, Dan, 2009. "Teaching consumer theory to business students: an integrative approach," MPRA Paper 37249, University Library of Munich, Germany.

    More about this item

    Statistics

    Access and download statistics

    Corrections

    All material on this site has been provided by the respective publishers and authors. You can help correct errors and omissions. When requesting a correction, please mention this item's handle: RePEc:sej:ancoec:v:66:3:y:2000:p:770-792. See general information about how to correct material in RePEc.

    For technical questions regarding this item, or to correct its authors, title, abstract, bibliographic or download information, contact: (Laura Razzolini). General contact details of provider: http://edirc.repec.org/data/seaaaea.html .

    If you have authored this item and are not yet registered with RePEc, we encourage you to do it here. This allows to link your profile to this item. It also allows you to accept potential citations to this item that we are uncertain about.

    We have no references for this item. You can help adding them by using this form .

    If you know of missing items citing this one, you can help us creating those links by adding the relevant references in the same way as above, for each refering item. If you are a registered author of this item, you may also want to check the "citations" tab in your profile, as there may be some citations waiting for confirmation.

    Please note that corrections may take a couple of weeks to filter through the various RePEc services.

    IDEAS is a RePEc service hosted by the Research Division of the Federal Reserve Bank of St. Louis . RePEc uses bibliographic data supplied by the respective publishers.