Impact Analysis Using Correlation Bot

This Bot measures, statistical parametric correlation operation among multiple numerical variables and provides the impact and degree of relationship.

Top Benefits

  • Improve Decision Making: Speed up decision making for the real world applications.
  • Increase Productivity: Save approximately 30% time in feature selection process and automation workflow creation.
  • Zero Maintenance: Model is provided as SaaS using serverless function architecture of Azure.
  • Ease of use: Model is easy to setup, highly scalable, fault tolerant (Each request is independent of another request).
  • Runs in Cloud: Apply Correlation Model as a Cloud Bot to your workflow and automate your business processes.

Tasks

  • The correlation Bot performs parametric 'Pearson correlation' and provides correlation coefficients (r) among variables.
  • Input CSV file is provided to the model and processed MS Excel output is retrieved.
  • Help in understanding extent of relationship among numerical variables to make data driven business decisions.

Inputs:
a. Path: Path of the CSV file For example: C:~Housing.csv
b. ColumnCount: Count of columns available in CSV file being provided with input data
c. InputColumnNames: Name of columns being provided in CSV file. For example 'SNo','Price','Lotsize','Bedrooms','Bathrms','Stories','Driveway','Recroom','Fullbase','Gashw','Airco','Garagepl','Prefarea'
d. InputColumnDataType: Data Type of columns being provided in CSV file in the same order as column names. For example: 'Numeric','Numeric','Numeric','Numeric','Numeric','Numeric','String','String','String','String','String','Numeric','String'
e. MissingNumberValueReplacement: A value that can be used by Model in case CSV file has blank field/s or missing numerical value/s.
f. IgnoreColumns: Names of the column that model should ignore while calculating correlation. For example: 'SNo','Driveway','Recroom','Fullbase','Gashw','Airco','Garagepl','Prefarea' which are of string data type

Actions:
The Bot takes CSV file as an input, performs parametric correlation operation on numerical variables and provides output in the MS Excel to exhibit the extent of relationship ('not causality').

Outputs:
a. Output: the result in the form of the MS Excel.
b. Column "field1" and "field2" has the column names on which correlation has been processed.
c. Column "correlation" has the extent of relationship for each combination.

NOTES: Output correlation coefficients (r) for continuous (interval level) data ranges in a range of -1 to +1. Refer to readme file for more details.

Buy Now

$50 USD per bot
Annual Subscription

Free 30-Day Trial

Request quote for more purchase options

Bot Security Program
Level 1
Applications
Business Process
Category
Vendor
Automation Type
Bot
Last Updated
March 20, 2020
First Published
March 20, 2020
Enterprise Version
11.3.3
ReadMe
ReadMe
Support

See the Bot in Action

Code
Input Sample
Ouput Sample
PREV NEXT
Code
Input Sample
Ouput Sample

Setup Process

Install

Download the Bot and follow the instructions to install it in your AAE Control Room.

Configure

Open the Bot to configure your username and other settings the Bot will need (see the Installation Guide or ReadMe for details.)

Run

That's it - now the Bot is ready to get going!

Requirements and Inputs

  • a. Path: Path of the CSV file For example: C:~Housing.csv
  • b. ColumnCount: Count of columns available in CSV file being provided with input data
  • InputColumnNames: Name of columns being provided in CSV file. For example 'SNo','Price','Lotsize','Bedrooms','Bathrms','
  • d. InputColumnDataType: Data Type of columns being provided in CSV file in the same order as column names. For example:
  • MissingNumberValueReplacement: A value that can be used by Model in case CSV file has blank field/s or missing numerical
  • f. IgnoreColumns: Names of the column that model should ignore while calculating correlation. For example: 'SNo','Drive