Two Plus Two Publishing LLC Two Plus Two Publishing LLC

Go Back   Two Plus Two Poker Forums > >


Programming Discussions about computer programming

Thread Tools Display Modes
Old 07-22-2017, 12:01 PM   #1
old hand
PlasticElephant's Avatar
Join Date: Jan 2013
Location: Whistler, BC
Posts: 1,486
Excel Help

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!
PlasticElephant is offline   Reply With Quote
Old 07-24-2017, 08:02 AM   #2
Join Date: Dec 2007
Posts: 4,537
Re: Excel Help

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
just_grindin is offline   Reply With Quote
Old 07-25-2017, 02:24 AM   #3
S.A.G.E. Master
daveT's Avatar
Join Date: Jun 2005
Location: Why didn't I use Clojure instead?
Posts: 22,343
Re: Excel Help

A good and helpful thread in OOT called "ask me anything about microsoft excel" here:
daveT is offline   Reply With Quote
Old 07-25-2017, 04:07 AM   #4
Join Date: May 2005
Posts: 2,919
Re: Excel Help

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.
jeccross is offline   Reply With Quote


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

All times are GMT -4. The time now is 05:43 AM.

Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
Copyright © 2008-2017, Two Plus Two Interactive
Poker Players - Streaming Live Online