Difference between revisions of "ISSS608 2017-18 T3 Assign Alejandro Llorens Moreno Conclusion"

From Visual Analytics and Applications
Jump to navigation Jump to search
Line 1: Line 1:
 
<div style=background:#F6CECE border:#A3BFB1>
 
<div style=background:#F6CECE border:#A3BFB1>
 
[[Image:Wildlife.jpg|165px]]  
 
[[Image:Wildlife.jpg|165px]]  
−
<b><font size = 6; color="#8B4513"> VAST Challenge 2017:Mystery at the Wildlife Preserve </font></b>
+
<b><font size = 6; color="#8B4513"> VAST Challenge 2018:Like a duck to water </font></b>
 
</div>
 
</div>
 
<!--MAIN HEADER -->
 
<!--MAIN HEADER -->
Line 11: Line 11:
 
| style="font-family:Century Gothic; font-size:100%; solid #1B338F; background:#FFF0F5; text-align:center;" width="25%" |  
 
| style="font-family:Century Gothic; font-size:100%; solid #1B338F; background:#FFF0F5; text-align:center;" width="25%" |  
 
;
 
;
−
[[ISSS608 2017-18 T3 Assign Alejandro Llorens Moreno_Data_Methodology|<b><font size="2"><font color="#BC8F8F">Methodology </font></font></b>]]
+
[[ISSS608 2017-18 T3 Assign Alejandro Llorens Moreno_Data_Preparation|<b><font size="2"><font color="#BC8F8F">Methodology & Dashboard Design</font></font></b>]]
  
 
| style="font-family:Century Gothic; font-size:100%; solid #1B338F; background:#FFF0F5; text-align:center;" width="25%" |  
 
| style="font-family:Century Gothic; font-size:100%; solid #1B338F; background:#FFF0F5; text-align:center;" width="25%" |  
 
;
 
;
−
[[ISSS608 2017-18 T3 Assign Alejandro Llorens Moreno_Answers|<b><font size="4"><font color="#8B4513">Answers</font></font></b>]]
+
[[ISSS608 2017-18 T3 Assign Alejandro Llorens Moreno_Visualization|<b><font size="2"><font color="#BC8F8F">Insights</font></font></b>]]
  
 
| style="font-family:Century Gothic; font-size:100%; solid #1B338F; background:#FFF0F5; text-align:center;" width="25%" |  
 
| style="font-family:Century Gothic; font-size:100%; solid #1B338F; background:#FFF0F5; text-align:center;" width="25%" |  
 
;
 
;
−
[[ISSS608 2017-18 T3 Assign Alejandro Llorens Moreno_Conclusion| <b><font size="2"><font color="#BC8F8F">Conclusion</font></font></b>]]
+
[[ISSS608 2017-18 T3 Assign Alejandro Llorens Moreno_Conclusion| <b><font size="4"><font color="#8B4513">Conclusion</font></font></b>]]
  
 
|  &nbsp;
 
|  &nbsp;
Line 25: Line 25:
 
<br/>
 
<br/>
  
−
<font size="5"><font color="#8B4513">'''Insights and answers to questions'''</font></font>
+
<font size="5"><font color="#8B4513">'''Conclusion'''</font></font>
  
−
==Trends: Do you see any trends of possible interest in this investigation? ==
+
<b>Top 3 patterns</b>
−
<table border='1'>
 
−
<tr>
 
−
<th>Patterns</th>
 
−
<th>Visualization</th>
 
−
</tr>
 
−
<tr>
 
−
<td><b> 1. Hight levels of Methylosmoline detected  ” </b>
 
−
<br>There’s a sharp increase in Methylosmoline levels in 2016 in both Kohsoom and Somchair. Averages increase sharply in the 4 quarters of 2016. This is of particular concern because it’s the contaminant agent. This requires more investigation. In all samples of Methylosmoline for all quarters the measurement is of 130 approx for Somchair and 50 for Kohsoom. This is considerably higher than the average of 22.32 in Kohsoom and 53.50 in Somchair for the last 3 years.
 
  
−
</td>
+
<br>
−
<td>[[File:Methyl.jpg|500px|center]]</td>
+
1) We have identified several challenges in the sampling strategy. Locations and Chemicals have very different distributions which seem quite suspicious. Why taking so many samples of a specific location and few from another? This is worth investigating further.
−
</tr>
 
−
<tr>
 
−
<td><b>2.Water temperature has been increasing </b><br>Water temperature is cyclical and warmer in the months from June to September (summer). However, in 2016 there’s a higher average water temperature in all locations. To be specific, in 1998 the average water temperature in all locations was 12.95 degrees. While in 2013 is 13.89, in 2014 is 14.79, in 2015 is 14.09 and in 2016 is 14.74 degrees.  Global warming and other external causes can obviously affect this measurement, however, it’s worth exploring further..</td>
 
−
<td>[[File:watertemp2.jpg|500px|center]]</td>
 
  
−
</tr>
+
2) Specific outliers (and extreme outliers 3 standard deviations from the average of the samples taken) are present in this dataset. We have presented a few examples worth investigating further. For example, Methylosmoline, Nitrates, Magnesium, Sulphates, Coliforms, Iron..etc.. are just a few examples of samples that represent very high values in specific months. Understanding the relationship between these variables and correlating these with the outliers presented in our Tableau analysis is important to interlink suspicious potential behaviours.
−
<tr>
 
−
<td><b>3.There's been drastic changes in Sulfates</b>
 
−
<br> We can see a clear trend in the years after 2007 until 2012 when the average measurement for Sulphates is lower for all locations. But specifically in Kohsoom , Somchair and Busarakhan.
 
−
</td>
 
−
<td>[[File:SulfatesAlex2.JPG|500px|center]]
 
  
−
</tr>
+
3) Designing a better sampling strategy is important. A strategy more systematic and focusing at specific days of the month over time. This would help determine cyclical patterns or spot true outliers in the data. Most of the chemical values have been discarded because of poor quality of data, not enough samples or abnormal distributions.
−
<tr>
 
−
<td><b>4.Other chemical changes </b>
 
−
<br>TLooking at Arsenic, Iron and Aluminium, we can determine there’s a huge release of these heavy metals: Arsenic in 2009 for all locations and specifically in 2010 for Kohsoom. Aluminium in Q2 2009. Iron in Q3 2003. Phosphorus peaks in different locations in 2006, 2009, 2014. This is a clear sign of drastic changes in soil or water. It's worth investigating all chemical changes.
 
−
 
 
−
</td>
 
−
<td>[[File:Otherchemicals.JPG|500px|center]]
 
−
</tr>
 
−
 
 
−
</table>
 

Revision as of 20:42, 8 July 2018

Wildlife.jpg VAST Challenge 2018:Like a duck to water

Background

Methodology & Dashboard Design

Insights

Conclusion

 


Conclusion

Top 3 patterns


1) We have identified several challenges in the sampling strategy. Locations and Chemicals have very different distributions which seem quite suspicious. Why taking so many samples of a specific location and few from another? This is worth investigating further.

2) Specific outliers (and extreme outliers 3 standard deviations from the average of the samples taken) are present in this dataset. We have presented a few examples worth investigating further. For example, Methylosmoline, Nitrates, Magnesium, Sulphates, Coliforms, Iron..etc.. are just a few examples of samples that represent very high values in specific months. Understanding the relationship between these variables and correlating these with the outliers presented in our Tableau analysis is important to interlink suspicious potential behaviours.

3) Designing a better sampling strategy is important. A strategy more systematic and focusing at specific days of the month over time. This would help determine cyclical patterns or spot true outliers in the data. Most of the chemical values have been discarded because of poor quality of data, not enough samples or abnormal distributions.

Retrieved from ‘https://wiki.smu.edu.sg/1718t3isss608/index.php?title=ISSS608_2017-18_T3_Assign_Alejandro_Llorens_Moreno_Conclusion&oldid=8256’