Two Plus Two Poker Forums Excel Help
 Register FAQ Search Today's Posts Mark Forums Read TwoPlusTwo.com

 Notices

 07-22-2017, 12:01 PM #1 PlasticElephant old hand     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!
 07-24-2017, 08:02 AM #2 just_grindin Pooh-Bah   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
 07-25-2017, 02:24 AM #3 daveT S.A.G.E. Master     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: https://forumserver.twoplustwo.com/34...-excel-874910/
 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.

 Thread Tools Display Modes Linear Mode

 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 Rules
 Forum Jump User Control Panel Private Messages Subscriptions Who's Online Search Forums Forums Home Links to Popular Forums     News, Views, and Gossip     Beginners Questions     Marketplace & Staking     Casino & Cardroom Poker     Internet Poker     NL Strategy Forums     Poker Goals & Challenges     Las Vegas Lifestyle     Sporting Events     Politics     Other Other Topics Two Plus Two     About the Forums     Two Plus Two Magazine Forum     The Two Plus Two Bonus Program     Two Plus Two Pokercast     The Best of Two Plus Two Marketplace & Staking     Commercial Marketplace     General Marketplace     Staking - Offering Stakes     Staking         Staking - Offering Stakes         Staking - Seeking Stakes         Staking - Selling Shares - Online         Staking - Selling Shares - Live         Staking Rails         Transaction Feedback & Disputes     Transaction Feedback & Disputes Coaching & Training     Coaching Advice     Cash Game Poker Coach Listings     Tournament/SNG Poker Coach Listings Poker News & Discussion     News, Views, and Gossip     Poker Goals & Challenges     Poker Beats, Brags, and Variance     That's What She Said!     Poker Legislation & PPA Discussion hosted by Rich Muny     Twitch - Watch and Discuss Live Online Poker     Televised Poker General Poker Strategy     Beginners Questions     Books and Publications     Poker Tells/Behavior, hosted by: Zachary Elwood     Poker Theory     Psychology No Limit Hold'em Strategy     Medium-High Stakes PL/NL     Micro-Small Stakes PL/NL     Medium-High Stakes Full Ring     Micro-Small Stakes Full Ring     Heads Up NL     Live Low-stakes NL Limit Texas Hold'em Strategy     Mid-High Stakes Limit     Micro-Small Stakes Limit Tournament Poker Strategy     STT Strategy     Heads Up SNG and Spin and Gos     Mid-High Stakes MTT     Small Stakes MTT     MTT Community     Tournament Events Other Poker Strategy     High Stakes PL Omaha     Small Stakes PL Omaha     Omaha/8     Stud     Draw and Other Poker Live Poker     Casino & Cardroom Poker         Venues & Communities         Regional Communities     Venues & Communities     Tournament Events         WPT.com     Home Poker     Cash Strategy     Tournament Strategy Internet Poker     Internet Poker         Winning Poker Network         nj.partypoker.com         Global Poker     Commercial Software     Software         Commercial Software         Free Software General Gambling     Backgammon Forum hosted by Bill Robertie.     Probability     Sports Betting     Other Gambling Games 2+2 Communities     Other Other Topics         OOTV         Game of Thrones     The Lounge: Discussion+Review     EDF     Las Vegas Lifestyle     BBV4Life         omg omg omg     House of Blogs Sports and Games     Sporting Events         Single-Team Season Threads         Fantasy Sports     Fantasy Sports         Sporting Events     Wrestling     Golf     Chess and Other Board Games     Video Games         League of Legends         Hearthstone     Puzzles and Other Games Other Topics     Politics     History     Business, Finance, and Investing     Science, Math, and Philosophy     Religion, God, and Theology     Travel     Health and Fitness     Laughs or Links!     Computer Technical Help     Programming International Forums     Deutsch         BBV [German]     Français     Two Plus Two en Espańol

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

 Contact Us - Two Plus Two Publishing LLC - Privacy Statement - Top