How to predict correlation between variables of the provided dataset.

Hi.

Please could anyone help with my task below:

How can I use the regression or artificial neural network methods to build up a model that may
seek to establish relationships between the variables of the provided dataset. For instance, I want to know if there are correlations between some category of products in the given dataset to answer the question do
people who buy products from the baked goods section also buy products from the Cheese section
etc? (the unit sold and sales price and other variables are given as shown below)

Thanks

Predictive Analysis

Accepted answers

All comments

atcodedog05

Hi @Luuv01

This is more of a market basket analysis. Below resources might help you.

https://community.alteryx.com/t5/Data-Science/Market-Basket-Analysis-102-Alteryx-Designer-Python/ba-p/662029

https://community.alteryx.com/t5/Data-Science/Market-Basket-Analysis-101-An-Introduction/ba-p/661963

Hope this helps 🙂

AngelosPachis

Hi @Luuv01,

The Association Analysis tool allows you to find if there is a correlation between a target variable and a predictor variable, and it does that through either the Spearman, Pearson or Hoeffding correlations. However, those correlations will mainly investigate linearity, so if the units sold has a linear correlation to the sales price.

From your final question, it doesn't seem that you are looking to find correlation, but rather you are interested in Market Basket Analysis. As you said, do people who buy X product also buy Y products. Those tools fall under the Predictive grouping tool palette.

Here are two posts that will help you get started with it

https://community.alteryx.com/t5/Data-Science/Market-Basket-Analysis-101-An-Introduction/ba-p/661963

https://community.alteryx.com/t5/Data-Science/Market-Basket-Analysis-102-Alteryx-Designer-Python/ba-p/662029

Cheers,

Angelos

Luuv01

atcodedog05

I will check it out

Luuv01

Thanks AngelosPachis,

I will check it out

Luuv01

Hi AngelosPachis

I tried MB but it seems not working in my case, my dataset only gives the Unit sold for each product which are grouped in section so we need to build a machine learning model to predict the correlation of the section to answer the question. Do you know how we can build either Regression or Neural Network model to predict if there are any correlation between sections. Thanks

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703