Two Plus Two Publishing LLC Two Plus Two Publishing LLC
 

Go Back   Two Plus Two Poker Forums > >

Notices

Programming Discussions about computer programming

Reply
 
Thread Tools Display Modes
Old 07-22-2017, 12:01 PM   #1
PlasticElephant
old hand
 
PlasticElephant's Avatar
 
Join Date: Jan 2013
Location: Whistler, BC
Posts: 1,384
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
just_grindin
Pooh-Bah
 
Join Date: Dec 2007
Posts: 4,342
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
daveT
S.A.G.E. Master
 
daveT's Avatar
 
Join Date: Jun 2005
Location: Why didn't I use Clojure instead?
Posts: 21,801
Re: Excel Help

A good and helpful thread in OOT called "ask me anything about microsoft excel" here: https://forumserver.twoplustwo.com/34...-excel-874910/
daveT is offline   Reply With Quote
Old 07-25-2017, 04:07 AM   #4
jeccross
veteran
 
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

Reply
      

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 04:34 PM.


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