Neil Binnie
This study investigates residential property sales in North Shore City, Auckland, between 1999 and 2007.
Video
Tasks
The video explores the Excel data file North Shore 99-07 December.xls which has 3788 property sales from 1999 to 2007. A number of tasks are suggested below. There is a teachers’ copy of some answers to the tasks in the file PropertySales-TeachersCopy.xls
The tasks are described in the following files:
- Task 1.pdf: Descriptive statistics of continuous variables
- Task 2.pdf: Exploring how the property market is performing
- Task 3-StatPro.pdf: Comparing the median selling prices using boxplots (instructions for StatPro+Excel)
- Task 3.pdf: Comparing the median selling prices using boxplots (instruction for Excel)
- Task 4.pdf: Difference between the List Price and the Selling Price
- Task 5.pdf: Difference between the Selling Price and the Government Valuation
Two additional data files are attached for further investigation:
- North Shore 2007.xls : with 6437 entries from 2006 to December 2007
- North Shore 2008.xls : with 9281 entries from 2006 to December 2008
Video content recorded and edited by Robert van der Vyver[1] and John Harraway[2].
Web site developed and maintained by Greg Trounson[2] and John Harraway
Contact us
1: Higher Education Development Unit, University of Otago
2: Department of Mathematics and Statistics, University of Otago