An analysis of household water consumption in the City of Cape Town using a panel data set (2016-2020)
| dc.contributor.advisor | Er, Sebnem | |
| dc.contributor.advisor | Visser, Martine | |
| dc.contributor.author | Kaplan, Anna Leah | |
| dc.date.accessioned | 2023-03-14T10:39:14Z | |
| dc.date.available | 2023-03-14T10:39:14Z | |
| dc.date.issued | 2022 | |
| dc.date.updated | 2023-03-14T08:59:44Z | |
| dc.description.abstract | 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. | |
| dc.identifier.apacitation | Kaplan, A. L. (2022). <i>An analysis of household water consumption in the City of Cape Town using a panel data set (2016-2020)</i>. (). ,Faculty of Science ,Department of Statistical Sciences. Retrieved from http://hdl.handle.net/11427/37433 | en_ZA |
| dc.identifier.chicagocitation | Kaplan, Anna Leah. <i>"An analysis of household water consumption in the City of Cape Town using a panel data set (2016-2020)."</i> ., ,Faculty of Science ,Department of Statistical Sciences, 2022. http://hdl.handle.net/11427/37433 | en_ZA |
| dc.identifier.citation | Kaplan, A.L. 2022. An analysis of household water consumption in the City of Cape Town using a panel data set (2016-2020). . ,Faculty of Science ,Department of Statistical Sciences. http://hdl.handle.net/11427/37433 | en_ZA |
| dc.identifier.ris | TY - Master Thesis AU - Kaplan, Anna Leah AB - 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. DA - 2022_ DB - OpenUCT DP - University of Cape Town KW - spatial panel analysis KW - water consumption KW - City of Cape Town KW - spatial lag model KW - moran's I LK - https://open.uct.ac.za PY - 2022 T1 - An analysis of household water consumption in the City of Cape Town using a panel data set (2016-2020) TI - An analysis of household water consumption in the City of Cape Town using a panel data set (2016-2020) UR - http://hdl.handle.net/11427/37433 ER - | en_ZA |
| dc.identifier.uri | http://hdl.handle.net/11427/37433 | |
| dc.identifier.vancouvercitation | Kaplan AL. An analysis of household water consumption in the City of Cape Town using a panel data set (2016-2020). []. ,Faculty of Science ,Department of Statistical Sciences, 2022 [cited yyyy month dd]. Available from: http://hdl.handle.net/11427/37433 | en_ZA |
| dc.language.rfc3066 | eng | |
| dc.publisher.department | Department of Statistical Sciences | |
| dc.publisher.faculty | Faculty of Science | |
| dc.subject | spatial panel analysis | |
| dc.subject | water consumption | |
| dc.subject | City of Cape Town | |
| dc.subject | spatial lag model | |
| dc.subject | moran's I | |
| dc.title | An analysis of household water consumption in the City of Cape Town using a panel data set (2016-2020) | |
| dc.type | Master Thesis | |
| dc.type.qualificationlevel | Masters | |
| dc.type.qualificationlevel | MSc |