momentum

[leovh]

Bonjour

I want to simulate the momentum effect in sports , that is the occurrence
in a row of not expected results. I generate random numbers and classify
them according to a criteria > than. After eg 10 occurrences note the
number of runs and than start again to generate a number "of results to
get some idea of the distribution. Could some body help me in putting this
in a scipt. Merci beaucoup The average value for a given run and probability
can be easily calculated , but i am intersted in the distribution.

 

[leovh]

Bonjour

I want to simulate the momentum effect in sports , that is the occurrence
in a row of not expected results. I generate random numbers and classify
them according to a criteria > than. After eg 10 occurrences note the
number of runs and than start again to generate a number "of results to
get some idea of the distribution. Could some body help me in putting this
in a scipt. Merci beaucoup The average value for a given run and
probability can be easily calculated , but i am intersted in the
distribution.

Version:1.00000000620000009943000
E000000028800000000009905Fragment:0000000000 EndFragment:0000000000

R\ {recalc F2..F101}
randoma {SELECT A:C11}
{calc}
{IF randa<0.667}{branch pta}
{branch ptcheck}
pta {let c12;c12+1}
{IF C12>=6}{QUIT}
{branch randoma}
randomb {select A:C21}
{calc}
{IF randb<0.333}{branch ptb}
{branch pta}
ptcheck {IF C12=0}{let C30;C30+1}
{IF C12=1}{let C31;C31+1}
{IF C12=2}{let C32;C32+1}
{IF C12=3}{let C33;C33+1}
{IF C12=4}{let C34;C34+1}
10.6 {IF C12=5}{let C35;C35+1}
{IF C12=6}{let C36;C36+1}
{IF C12=7}{let C37;C37+1}
{IF C12=8}{let C38;C38+1}
{IF C12=9}{let C39;C39+1}
{let c12;0}
{branch ptb}
ptb {let C18;C18+1}

 

[Jim Cone]

Suggest you look in Excel help under "statistical functions"
--
Jim Cone
Portland, Oregon USA .
http://www.mediafire.com/PrimitiveSoftware .
(Permutations Add-in: with option to highlight valid words)




"leovh" <[email protected]>
wrote in message
news:[email protected]...