AI (artificial intelligence) to analyse data

**excelnabb** · 04-26-2019, 04:56 AM

Hi

I'm wondering if anyone know about a program, or an AI (artificial intelligence) function that can analyse data to check if there are any correlation/similarities/patterns between two categories of data? I'm trying to activate Insights/Ideas to excel, but can't get it to work, don't even know if the program is capable to do this though. My example below is that I have two sets of data, yellow and white numbers, the program should give me suggestions of any correlation/similarities/patterns between these two sets of data:

Example: all yellow numbers in column A that are above a certain number has a value in column D that are between this and this percentage, while white numbers that are above the same number in column A, has no percentage between the same range as the yellow numbers had in column D.

This is just a weird example, that may not give any sense, my point is that the difficult part is that I'm not sure what I'm looking for in the numbers, that's what I want an AI program to analyse the data for me.

Don't know if this exist though.

2019-04-26_10-53-33.jpg

**Pepe Le Mokko** · 04-26-2019, 06:29 AM

Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

**Pepe Le Mokko** · 04-26-2019, 06:29 AM

Not being an acronym man, I wonder what AI means???

**excelnabb** · 04-26-2019, 06:46 AM

Originally Posted by Pepe Le Mokko

Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

Hi
This is hard to do when I don't have any answer on my desired results.

AI = artificial intelligence

**Pepe Le Mokko** · 04-26-2019, 08:37 AM

Well, you could at least post a worksheet on the forum so maybe someone can play with it

AI (artificial intelligence) to analyse data

LinkBack

Thread Tools

Rate This Thread

Display

AI (artificial intelligence) to analyse data

Re: AI to analyse data

Re: AI to analyse data

Re: AI to analyse data

Re: AI (artificial intelligence) to analyse data

Thread Information

Users Browsing this Thread

Similar Threads

Pivottable data analyse

[SOLVED] Help With Macro To Analyse Data

How to analyse data from multiple worksheets

How to analyse data in spreadsheet

Analyse Data in a Row

how do you use a chisquare function to analyse data

how do I analyse two spreadsheets for missing data?

Bookmarks

Bookmarks

Posting Permissions