Difference between revisions of "ISSS608 2017-18 T3 Assign Xie Zhimao Method"
Jump to navigation
Jump to search
| Line 29: | Line 29: | ||
|- | |- | ||
| | | | ||
| + | *SAS JMP Pro | ||
| + | *Microsoft Excel | ||
*Tableau | *Tableau | ||
| − | *JMP | + | |} |
| − | *Excel | + | </div> |
| + | |||
| + | <div style="margin:0px; padding: 2px; border-radius: 1px; text-align:left"> | ||
| + | {| class="wikitable" style="background-color:#FFFFFF;" width="100%" | ||
| + | |- | ||
| + | | | ||
| + | <b>No.</b> | ||
| + | || | ||
| + | <b> Approach</b> | ||
| + | || | ||
| + | <b>  Description</b> | ||
| + | |- | ||
| + | | | ||
| + | 1. | ||
| + | || | ||
| + | SAS JMP Pro<br> | ||
| + | (  Data Understanding) | ||
| + | || | ||
| + | *Use SAS JMP Pro to open the metadata and check the ditribution and validity of the data. [[File:Zhimao3.png|500px]] [[File:Zhimao4.png|500px]] | ||
| + | *We found the missing data is <b>0</b> and there is no obviously unreasonable skewed distribution, so our initial clean step is complete. | ||
| + | *However, when it refers to chemical units of measure, we noticed there are different units, such as mg/l and μg/l. Therefore, we need further data wrangling by use Microsoft Excel. | ||
| + | |- | ||
| + | | | ||
| + | 2. | ||
| + | || | ||
| + | Microsoft Excel | ||
| + | || | ||
| + | |||
| + | |- | ||
| + | | | ||
| + | 3. | ||
| + | || | ||
| + |   Tableau | ||
| + | || | ||
| + | |||
| + | |- | ||
|} | |} | ||
</div> | </div> | ||
Revision as of 17:54, 7 July 2018
2018 Mini-Challenge 2 Method
|
|
|
|
|
Tools Description
|
|
No. |
Approach |
Description |
|
1. |
SAS JMP Pro |
|
|
2. |
Microsoft Excel |
|
|
3. |
Tableau |
