Full Text Available
Note: Clicking the button above will open the full text document at the original institutional repository in a new window.
An analysis of household water consumption in the City of Cape Town using a panel data set (2016-2020)
Understanding consumer behaviour with respect to water consumption has become an active field of study. This thesis uses a household billing dataset that tracks the quantity of water consumed by households in the City of Cape Town (CoCT) from 2016 to 2020. The household billing data was filtered to...
Saved in:
| Main Author: | |
|---|---|
| Other Authors: | |
| Format: | Thesis |
| Language: | English |
| Published: |
Department of Statistical Sciences
2023
|
| Subjects: | |
| Tags: |
No Tags, Be the first to tag this record!
|
| _version_ | 1867614147006431232 |
|---|---|
| access_status_str | Open Access |
| author | Kaplan, Anna Leah |
| author2 | Er, Sebnem |
| author_browse | Er, Sebnem Kaplan, Anna Leah |
| author_facet | Er, Sebnem Kaplan, Anna Leah |
| author_sort | Kaplan, Anna Leah |
| collection | Thesis |
| description | Understanding consumer behaviour with respect to water consumption has become an active field of study. This thesis uses a household billing dataset that tracks the quantity of water consumed by households in the City of Cape Town (CoCT) from 2016 to 2020. The household billing data was filtered to include only household observations and then aggregated to the ward level. As a result, the aggregated data is a balanced spatial panel dataset including 20 quarterly observations for each of the 88 wards. Using the billing data set, multiple linear regression models, panel data models as well as spatial panel models were implemented to predict ward level water consumption. Using several visualisations and statistical measures, this thesis found that consumption dropped significantly during the drought period (2016-2018) and also found spatial clusters of water consumption in the CoCT. The data showed that before and after the drought, water consumption exhibited a seasonal pattern which was absent during the drought period. It is also noted that although consumption levels after the drought increase, they do not rise as high as pre-drought levels. The linear models implemented in this thesis resulted in an Adjusted R-squared values of up to 0.85, implying that the independent variables used in the models explain a large amount of variation observed in the dependent variable, quantity of ward level water consumption. |
| format | Thesis |
| id | oai:open.uct.ac.za:11427/37433 |
| institution | University of Cape Town (South Africa) |
| language | eng |
| last_indexed | 2026-06-10T12:47:24.957Z |
| license_str | Not specified — see source repository |
| provenance_str_mv | Harvested via OAI-PMH from UCTD — University of Cape Town Open Access Repository |
| publishDate | 2023 |
| publishDateRange | 2023 |
| publishDateSort | 2023 |
| publisher | Department of Statistical Sciences |
| publisherStr | Department of Statistical Sciences |
| record_format | dspace |
| source_str | UCTD — University of Cape Town Open Access Repository |
| spelling | oai:open.uct.ac.za:11427/37433 An analysis of household water consumption in the City of Cape Town using a panel data set (2016-2020) Kaplan, Anna Leah Er, Sebnem Visser, Martine spatial panel analysis water consumption City of Cape Town spatial lag model moran's I Understanding consumer behaviour with respect to water consumption has become an active field of study. This thesis uses a household billing dataset that tracks the quantity of water consumed by households in the City of Cape Town (CoCT) from 2016 to 2020. The household billing data was filtered to include only household observations and then aggregated to the ward level. As a result, the aggregated data is a balanced spatial panel dataset including 20 quarterly observations for each of the 88 wards. Using the billing data set, multiple linear regression models, panel data models as well as spatial panel models were implemented to predict ward level water consumption. Using several visualisations and statistical measures, this thesis found that consumption dropped significantly during the drought period (2016-2018) and also found spatial clusters of water consumption in the CoCT. The data showed that before and after the drought, water consumption exhibited a seasonal pattern which was absent during the drought period. It is also noted that although consumption levels after the drought increase, they do not rise as high as pre-drought levels. The linear models implemented in this thesis resulted in an Adjusted R-squared values of up to 0.85, implying that the independent variables used in the models explain a large amount of variation observed in the dependent variable, quantity of ward level water consumption. 2023-03-14T10:39:14Z 2023-03-14T10:39:14Z 2022 2023-03-14T08:59:44Z Master Thesis Masters MSc http://hdl.handle.net/11427/37433 eng application/pdf Department of Statistical Sciences Faculty of Science |
| spellingShingle | spatial panel analysis water consumption City of Cape Town spatial lag model moran's I Kaplan, Anna Leah An analysis of household water consumption in the City of Cape Town using a panel data set (2016-2020) |
| thesis_degree_str | Master's |
| title | An analysis of household water consumption in the City of Cape Town using a panel data set (2016-2020) |
| title_full | An analysis of household water consumption in the City of Cape Town using a panel data set (2016-2020) |
| title_fullStr | An analysis of household water consumption in the City of Cape Town using a panel data set (2016-2020) |
| title_full_unstemmed | An analysis of household water consumption in the City of Cape Town using a panel data set (2016-2020) |
| title_short | An analysis of household water consumption in the City of Cape Town using a panel data set (2016-2020) |
| title_sort | analysis of household water consumption in the city of cape town using a panel data set 2016 2020 |
| topic | spatial panel analysis water consumption City of Cape Town spatial lag model moran's I |
| url | http://hdl.handle.net/11427/37433 |
| work_keys_str_mv | AT kaplanannaleah ananalysisofhouseholdwaterconsumptioninthecityofcapetownusingapaneldataset20162020 AT kaplanannaleah analysisofhouseholdwaterconsumptioninthecityofcapetownusingapaneldataset20162020 |