Difference between revisions of "ISSS608 2017-18 T3 Assign Liu Yuanjing Methodology"

From Visual Analytics and Applications
Jump to navigation Jump to search
Line 1: Line 1:
 +
<!----------- Main Header ------------>
 
<div style=background:#f2ebd2;>
 
<div style=background:#f2ebd2;>
 
[[Image:Water pollution.jpg|250px]]  
 
[[Image:Water pollution.jpg|250px]]  
 
<font size = 5; color="#751102"><span style="font-family:Segoe UI Semibold";>&nbsp;Investigating chemical contamination in the Boonsong Lekagul waterways</span>
 
<font size = 5; color="#751102"><span style="font-family:Segoe UI Semibold";>&nbsp;Investigating chemical contamination in the Boonsong Lekagul waterways</span>
 
</font></div>
 
</font></div>
<!----------- Main Header ------------>
+
   
{|style="background-color:#f2ebd2;" width="100%" cellspacing="0" cellpadding="0" valign="top" border="0"; text-align:center;" |
 
 
 
| style="font-family:Segoe UI Semibold; text-align:center;" width="15%" |
 
[[ISSS608_2017-18_T3_Assign_Liu Yuanjing|<font size="3"><font color="#751102">Background</font>]]
 
 
 
| style="font-family:Segoe UI Light; text-align:center;" width="15%" |
 
[[ISSS608_2017-18_T3_Assign_Liu Yuanjing_Methodology|<font size="3"><font color="#C4B78A">Methodology</font>]]
 
 
 
| style="font-family:Segoe UI Light; text-align:center;" width="15%" |
 
[[ISSS608_2017-18_T3_Assign_Liu Yuanjing_Visualisations|<font size="3"><font color="#C4B78A">Visualisations Analysis</font>]]
 
 
 
| style="font-family:Segoe UI Light; text-align:center;" width="15%" |
 
[[ISSS608_2017-18_T3_Assign_Liu Yuanjing_Conclusion|<font size="3"><font color="#C4B78A">Conclusion</font>]]
 
 
 
| style="font-family:Segoe UI Light; text-align:center;" width="15%" |
 
[[Assignments|<font size="3"><font color="#C4B78A">Back to main</font>]]
 
|}
 
 
 
<div style="font-family:Segoe UI; padding: 0px 15px 0px 15px;">
 
<div style="font-family:Segoe UI;">
 
<font size = 2; color ="#353839
 
">
 
 
 
 
 
<!------------ Navigation bar ------------>
 
  
 
==<font size="5"><font color="#000000">'''Tools'''</font></font>==
 
==<font size="5"><font color="#000000">'''Tools'''</font></font>==

Revision as of 20:24, 7 July 2018

Water pollution.jpg  Investigating chemical contamination in the Boonsong Lekagul waterways


Tools

  • JMP Pro
  • Tableau


Methodology

Methodology

Description

Standardization method:

Because we want to go through all measures in different waterways or locations but measures have different units and if we want see the volatility changes in different paths or location and then identify potential chemical contamination. Therefore, we decided to use Z-Score to modify the data bias. Z-score represents the distance of the original data from the mean, and the standard of the distance measure is the standard deviation.

  • Z-score greater than zero indicates that the data is greater than the mean
  • Z-score less than zero indicates that the data is less than the mean
  • Z-score equal to zero indicates that the data is equal to the mean
  • Z-score equal to "1" indicates that the data is one standard deviation larger than the mean
  • Z-score equal to "-1" indicates that the data is one standard deviation smaller than the mean

If the amount of statistical data is sufficient, the Z-score data distribution is satisfied, 68% of the data is distributed between "-1" and "1", and 95% of the data is distributed between "-2" and "2", 99%. The data is distributed between "-3" and "3". You can use this to verify your data. See the Z-score data distribution below:

Z-SCORE introducation.jpg

and then we edit the formula in tableau and add one measure variable, called “Z-Score”, the formula as below: