Icon

03. Box Plot and Statistics - solution

Statistics, data distribution, outliers and data normalization
Check the data distributionof the prices (column MEDV)Are there any outliers?Hint: use the box plot Check the values of the distribution for all columns and check ifthere are any missing values. See the basic statistics indicatorsHint: use the box plot and statistics nodes Remove rows including outliers of MEDV and check it. Hint: use the outliers node (to avoid all outliers K should be set up1), and check via box plot. Boston House pricesRead excel file boston house prices Normalize your data by using z-score. Hint: use the normalizer node and check the box plots andstatistics again (resulted standard deviation should be 1 for allcolumns) MEDVdistributionRemovingoutliershouse pricesData statisticsStatistics after normalizationNormalizationz-scoreDelete first columnindexesMEDVdistribution w/ooutliersAll columnsdistributionBox plotafter normalization Box Plot Numeric Outliers Excel Reader (XLS) Statistics Statistics Normalizer Column Filter Box Plot Box Plot Box Plot Check the data distributionof the prices (column MEDV)Are there any outliers?Hint: use the box plot Check the values of the distribution for all columns and check ifthere are any missing values. See the basic statistics indicatorsHint: use the box plot and statistics nodes Remove rows including outliers of MEDV and check it. Hint: use the outliers node (to avoid all outliers K should be set up1), and check via box plot. Boston House pricesRead excel file boston house prices Normalize your data by using z-score. Hint: use the normalizer node and check the box plots andstatistics again (resulted standard deviation should be 1 for allcolumns) MEDVdistributionRemovingoutliershouse pricesData statisticsStatistics after normalizationNormalizationz-scoreDelete first columnindexesMEDVdistribution w/ooutliersAll columnsdistributionBox plotafter normalization Box Plot Numeric Outliers Excel Reader (XLS) Statistics Statistics Normalizer Column Filter Box Plot Box Plot Box Plot

Nodes

Extensions

Links