Solution Exercise 4

Download data from an online well record database, open the data in a spreadsheet program, review the data to find and eliminate inconsistencies, then evaluate statistics on the ‘clean’ data for a few of the available fields of depth and yield. For example, the following average well depth and yield are presented for the city of ‘Big Creek’ by downloading the British Columbia Wells Database (Exercise 1) and filtering the ‘City’ field by “Big Creek”, and generating averages for the ‘finished well depth’ and ‘well yield’ fields. This example uses a city with only 6 wells. Try to find a city with at least 100 wells.

Return to Exercise 4