Difference between revisions of "ISSS608 2017-18 T3 Assign DiyaNR data"
Jump to navigation
Jump to search
(Created page with "<div style="background:#F5B041; border:#002060; padding-left:15px; text-align:center;"> <font size = 5; color="#000000"><span style="font-family:Trebuchet MS;">VAST MINI CHAL...") |
|||
| Line 18: | Line 18: | ||
| style="font-family:Trebuchet MS; font-size:100%; solid #000000; background:#F5B041; text-align:center;" width="20%" | | | style="font-family:Trebuchet MS; font-size:100%; solid #000000; background:#F5B041; text-align:center;" width="20%" | | ||
; | ; | ||
| − | [[ISSS608_2017-18_T3_Assign_DiyaNR_conclusion| <font color="#000000">RECOMMENDATIONS | + | [[ISSS608_2017-18_T3_Assign_DiyaNR_conclusion| <font color="#000000">RECOMMENDATIONS</font>]] |
| style="font-family:Trebuchet MS; font-size:100%; solid #000000; background:#F5B041; text-align:center;" width="20%" | | | style="font-family:Trebuchet MS; font-size:100%; solid #000000; background:#F5B041; text-align:center;" width="20%" | | ||
| Line 31: | Line 31: | ||
The following are the datasets and their corresponding data fields present<br><br> | The following are the datasets and their corresponding data fields present<br><br> | ||
1. Boonsong Kekagul waterways readings<br> | 1. Boonsong Kekagul waterways readings<br> | ||
| − | [[File:table1_readings.JPG|400px|]] | + | [[File:table1_readings.JPG|400px|border="4"]] |
<br> | <br> | ||
<br> | <br> | ||
Revision as of 05:03, 9 July 2018
VAST MINI CHALLENGE 2
|
|
|
|
|
|
The Datasets
The following are the datasets and their corresponding data fields present
1. Boonsong Kekagul waterways readings
2. Chemical units of measure
Data Preparation
SAS JMP was used for preparing the data.
- The two datasets 'Boonsong Kekagul waterways readings' and 'Chemical units of measure' were joined using JMP based on the common 'Measure' Column present in both.
- The units were all converted to a common scale i.e. microgram.
- Sample Date was converted into "Date and Time' type. The dates under the 'Sample Date' Column were recoded from '2098' and '2099' to '1998' and '1999'. This was done using the recode feature in JMP by clicking 'Cols -> Recode'.
- An additional column called 'Scaled value' was calculated where the values were scaled based on the 'Measure' name, according to the following formula:
where,
Value = Record Value
Min = Minimum value for that chemical.
Max = Maximum Value for that chemical.
- The final table is as follows:
The Measure or Chemical "Macrozoobenthos" did not have a unit present.
