Converting ZIP code data into distances: A case study for teaching business analytics

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.