IDEAS home Printed from https://ideas.repec.org/a/inm/orited/v19y2019i2p105-107.html
   My bibliography  Save this article

Case Article—Converting Zip Code Data into Distances: A Case Study for Teaching Business Analytics

Author

Listed:
  • Eric Huggins

    (School of Business Administration, Fort Lewis College, Durango, Colorado 81301)

Abstract

In this case study, we demonstrate how to convert a column of zip code data into approximate distances from a default zip code using only standard Microsoft (MS) Excel functions and a free zip code database available online. We illustrate one example of analytics that may be applied to these distances with real data. The Case Article discusses our experiences in teaching the case and highlights the positive aspects of it. In the Case Study, we develop a hypothetical scenario in order to convey the value of being able to convert standard zip code data into distances to the students reading the case. Finally, the Case Teaching Note provides guidance regarding classroom discussion as well as specific instructions for developing the MS Excel spreadsheet.

Suggested Citation

  • Eric Huggins, 2019. "Case Article—Converting Zip Code Data into Distances: A Case Study for Teaching Business Analytics," INFORMS Transactions on Education, INFORMS, vol. 19(2), pages 105-107, January.
  • Handle: RePEc:inm:orited:v:19:y:2019:i:2:p:105-107
    DOI: 10.1287/ited.2018.0195
    as

    Download full text from publisher

    File URL: https://doi.org/10.1287/ited.2018.0195
    Download Restriction: no

    File URL: https://libkey.io/10.1287/ited.2018.0195?utm_source=ideas
    LibKey link: if access is restricted and if your library uses this service, LibKey will redirect you to where you can use your library subscription to access this item
    ---><---

    Citations

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


    Cited by:

    1. Jyotirmoy Dalal, 2022. "An Exercise for Teaching Transportation Problem Using Spatial Data," INFORMS Transactions on Education, INFORMS, vol. 23(1), pages 12-26, September.
    2. Sanjay Choudhari & Saurabh Chandra, 2022. "Case Article—Route Planning at an Animal Husbandry Department," INFORMS Transactions on Education, INFORMS, vol. 23(1), pages 35-40, September.

    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:inm:orited:v:19:y:2019:i:2:p:105-107. See general information about how to correct material in RePEc.

    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 bibliographic 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 RePEc Author Service profile, as there may be some citations waiting for confirmation.

    For technical questions regarding this item, or to correct its authors, title, abstract, bibliographic or download information, contact: Chris Asher (email available below). General contact details of provider: https://edirc.repec.org/data/inforea.html .

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

    IDEAS is a RePEc service. RePEc uses bibliographic data supplied by the respective publishers.