Difference between revisions of "ISSS608 2017-18 T3 Assign Yeo Kaijun Method"
Line 41: | Line 41: | ||
To ensure recency of the data, only values from the recent 5 years will be used in the analysis | To ensure recency of the data, only values from the recent 5 years will be used in the analysis | ||
<br><br><br> | <br><br><br> | ||
− | 2.Comparison across time | + | 2.Comparison across time<br> |
Firstly, the waterways will be analyzed as a whole using a highlight cell chart, where % increase/decrease compared to the previous year will be highlighted. 2 main trend will be flagged out and further analyzed: | Firstly, the waterways will be analyzed as a whole using a highlight cell chart, where % increase/decrease compared to the previous year will be highlighted. 2 main trend will be flagged out and further analyzed: | ||
<br> | <br> | ||
− | 1. Sharp % increase/decrease | + | 1. Sharp % increase/decrease<br> |
2. Consistent increases | 2. Consistent increases | ||
<br> | <br> | ||
− | As the data are no collected consistently for all years across all areas, a sharp % increase/decrease can indicate the following: | + | As the data are no collected consistently for all years across all areas, a sharp % increase/decrease can indicate the following:<br> |
− | 1. There is a sharp increase of pollutant dumping in an area in the waterway during the year | + | 1. There is a sharp increase of pollutant dumping in an area in the waterway during the year<br> |
2. There was an area with high values of pollutant that was not sampled in the current/previous year | 2. There was an area with high values of pollutant that was not sampled in the current/previous year | ||
<br> | <br> |
Revision as of 00:57, 7 July 2018
VAST Mini Challenge 2: Methodology
|
|
|
|
Methodology
The data will be analyzed upon 3 different methods:
1. Comparison between different areas
2. Comparison across time
3. Comparison with a standardized water quality criteria
1. Comparison between different area
Firstly, there are 4 main exits of the waterway (Decha, Tansanee, Sakda & Kannika) The pollutant values of these 4 exits will be analyzed.
Next, upon spotting higher pollutant values in either of the exits, further investigation will be done on the sampling areas of each exits
To ensure recency of the data, only values from the recent 5 years will be used in the analysis
2.Comparison across time
Firstly, the waterways will be analyzed as a whole using a highlight cell chart, where % increase/decrease compared to the previous year will be highlighted. 2 main trend will be flagged out and further analyzed:
1. Sharp % increase/decrease
2. Consistent increases
As the data are no collected consistently for all years across all areas, a sharp % increase/decrease can indicate the following:
1. There is a sharp increase of pollutant dumping in an area in the waterway during the year
2. There was an area with high values of pollutant that was not sampled in the current/previous year
A consistent increase of pollutant would also be a case of concern as it might indicate that pollutants are building up in that area
Pollutants with the above mentioned situations will be further delved in to figure out the area of concern
3.