Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Statistical Analysis
Hi,
I have a probability problem to solve, and I hope you can please help. There are 5 total possible events, 3 of which can occur simultaneously at any given time (hence, order is not an issue). The events are called A, B, C, D, E, F. I created a square in excel with each event occupying a different row/column: A B C D E F A B C D E F The whole point is to figure out how often certain events occur with another. So, if A, D, and E occur the table should recognize that A has occurred once, and D and E occurred once with it and that D occurred with A and E, and so on: A B C D E F A 1 1 1 B C D 1 1 1 E 1 1 1 F If at another time event A, D, F occur, it should now calculate this and add it to the table from before. So A and D occurred together again, hence a total of 2 times: A B C D E F A 2 2 1 1 B C D 2 2 1 E 1 1 1 F 1 1 1 My list contains hundreds of rows, each with 3 columns, each column names one of the 5 possible events, 3 at any given time. Is there a way to link all those events to this one table to get a final result? Thanks! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Statistical Analysis
Im not 100% clear on the question, but if you are looking for the the
probability of any 3 events from 6 possibles then analytically this is =combin(6,3)=20 - ie each combination of 3 is a 1 in 20 chance (19/1 odds) I advise yo to look up =combin on Excel help. If you are looking to verify this with a simulation run on excel then please let me know and I will advise on the required code " wrote: Hi, I have a probability problem to solve, and I hope you can please help. There are 5 total possible events, 3 of which can occur simultaneously at any given time (hence, order is not an issue). The events are called A, B, C, D, E, F. I created a square in excel with each event occupying a different row/column: A B C D E F A B C D E F The whole point is to figure out how often certain events occur with another. So, if A, D, and E occur the table should recognize that A has occurred once, and D and E occurred once with it and that D occurred with A and E, and so on: A B C D E F A 1 1 1 B C D 1 1 1 E 1 1 1 F If at another time event A, D, F occur, it should now calculate this and add it to the table from before. So A and D occurred together again, hence a total of 2 times: A B C D E F A 2 2 1 1 B C D 2 2 1 E 1 1 1 F 1 1 1 My list contains hundreds of rows, each with 3 columns, each column names one of the 5 possible events, 3 at any given time. Is there a way to link all those events to this one table to get a final result? Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Statistical Analysis: Pass/Fail Correlation | Excel Worksheet Functions | |||
Statistical Analysis for a Thesis | New Users to Excel | |||
statistical analysis / trend repetition | Excel Discussion (Misc queries) | |||
preparing data for statistical analysis | Excel Programming | |||
Simple statistical analysis | Excel Worksheet Functions |