Icon

02b. Distribution 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 normalizationMEDVdistribution Box Plot Numeric Outliers Excel Reader (XLS) Statistics Statistics Normalizer Column Filter Box Plot Box Plot Box Plot Violin Plot(Plotly) 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 normalizationMEDVdistribution Box Plot Numeric Outliers Excel Reader (XLS) Statistics Statistics Normalizer Column Filter Box Plot Box Plot Box Plot Violin Plot(Plotly)

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: rb
Created at: 2017-03-01
On NodePit since: 2020-12-05
Last update: 2024-04-27
Created with KNIME version: v4.2.3
Tags: univariatevisualizationvisualizeunivariate analysisvisualize outliersvisualize distributionconditional box plotbox plotvarying box plotbox plotsJavaScriptboxplotdescriptive statisticsoutliersstatisticsnormalizationstandardizationscalerz-score

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!