Excel Help - Computer Technical Help - Software and Hardware Forum

Two Plus Two Forums Other Topics Computer and Technical Help

Excel Help

Post Reply Subscribe

...

07-22-2017 , 12:01 PM

PlasticElephant

Coach NLHE

Join Date: Jan 2013 Posts: 2,303

Hi, I am an Excel noob, and am struggling to solve a problem.
I have this data (obviously over a much larger data set)

I would like to find links between the cards in the left column, and the number in the far right column.
Firstly, individual cards (eg, 7 means that number in right is likely to be higher.)

Secondly, combinations of cards (eg, 7s, 6s in left means right is likely to be higher.)

Trying to learn via google but if anyone hear can help out quicker would be much appreciated!

Quote

07-24-2017 , 08:02 AM

just_grindin

Pooh-Bah

Join Date: Dec 2007 Posts: 5,263

The Math or Probability sub forums would be more helpful for the statistics to use to analyze the data. My stats are rusty but it should be pretty straight forward I think.

I have heard Python and R are used a lot for data analysis but I have never used either of them. I imagine ywou will need a library in python to parse the Excel file.

The other option is to use VBA but it is pretty awful. If you do that I would use the functions that allow you to query the spreadsheet using sql query syntax. It will make data retrieval for the questions you are going to ask easier.

Sent from my SM-G900R4 using Tapatalk

Quote

07-25-2017 , 02:24 AM

daveT

S.A.G.E. Master

Join Date: Jun 2005 Posts: 23,955

A good and helpful thread in OOT called "ask me anything about microsoft excel" here: http://forumserver.twoplustwo.com/34...-excel-874910/

Quote

07-25-2017 , 04:07 AM

jeccross

Pooh-Bah

Join Date: May 2005 Posts: 3,807

First you want to use text functions to separate out the cards into something excel can read.

Finding relationships from scratch is pretty tough. Presumably you have some hypothesis you want to test? If you do you need to find a way to turn the card data into figures that link to your hypothesis and then test that statistically.

Quote

Post Reply Subscribe

...