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

INFORMS Transactions on Education

EricHuggins¹ 

关键词: zip codes;    microsoft excel;    MIS;    database;    customer analytics;    descriptive analytics;    operations;   

DOI  :  10.1287/ited.2018.0195

学科分类：社会科学、人文和艺术（综合）

来源: INFORMS

【 摘 要 】

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.

【 授权许可】

CC BY