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. The Case Teaching Note and final product example are available at https://www.informs.org/Publications/Subscribe/Access-Restricted-Materials .
Talk to us
Join us for a 30 min session where you can share your feedback and ask us any queries you have
Schedule a callDisclaimer: All third-party content on this website/platform is and will remain the property of their respective owners and is provided on "as is" basis without any warranties, express or implied. Use of third-party content does not indicate any affiliation, sponsorship with or endorsement by them. Any references to third-party content is to identify the corresponding services and shall be considered fair use under The CopyrightLaw.
