Repeat Sales Index Using Large Data: From Data Handling to Index Estimation

Опубликовано: 14 Июль 2026
на канале: Ali NasserEddine
4,405
39

In this tutorial, we use the standard Bailey et al. method to construct a repeat sales index. We organize the data in OpenOffice Calc, and run the multiple regression with R. We use R studio interface as it is more user friendly. Both are free programs. The same procedure can be used with any other programs. We constructed the sample for educational reasons. Feel free to contact me if you have any questions.

The index can be constructed for any period size and category. The same concept to be applied.

If you would like to understand the concept behind the index, please refer to this tutorial:
►    • The Repeat Sales Index: Step-by-Step  

If you would like to see how the Case & Shiller index is constructed, follow this link:
►    • Case & Shiller Repeat Sales Index: A Step-...  

You can download the original data file from here:
⇩ www.nassereddine.com/uploads/Data.csv
⇩ Backup link: https://goo.gl/gVqjgF

Or the processed data file from here:
⇩ www.nassereddine.com/uploads/DataBMN.csv
⇩ Backup link: https://goo.gl/Q9bpf1

Please let me know if you have any questions.