????? ??????

Select the product you need help with

??? ?????? RAND ?? Excel 2007 ?Excel 2003?

???? ???????: 828795 - ??? ???????? ???? ????? ????? ??? ???????.

??????

???? ??? ??????? ?????????? ??????? ?????????? ?? ???? ???? ??????? ?????????? RAND? ?? Microsoft Office Excel 2007 ?Microsoft Office Excel 2003.

???? ??? ?????? | ????? ???????

??????? ?????? RAND ?? ????????? ??????? ?? Excel ???????? ???? ????? ??????? ????? ??? ??? ?????? ??????? ?? ?????????? ???????? ??????? ?????????. ?????? ?? ?? ??? ?? ???? ??? ??? ?????????? ????? ????? ????? ????? ??? ???? ?? ??????????? ?? RAND? ??? ???? ?????? ?? ???? ?? ????? ??????? ?? ????? ??? ???? ??????? ??? ?? ??????? ?? ????? ???????? ???? ??????? ????????? ??????? ???? ??? ????? ??? ???? ??? ?? Excel 2003. ??? ???? ??? ???? ?????? ?????????? ????????.

????? ?????? ?????????? ???? Diehard (???? ?????? ?). ??? ?? ????? ?????????? ??????? ?? Excel 2003 ?????? B.A. Wichman ?I.D. Hill (???? ?????????? ? ??). ???? ????? ??????? ???? ??????? ????????? ??? ?? ???? ????? RAT-STATS ???? ??? ??????? ?????? ???? ?????? ????? ?????? ????? ???????? ????????? ?? ???????? ???????. ???? Rotz ?????? (???? ?????? ?)? ??? ???? ????? ???????? DIEHARD ??????????? ???????? ???? ?? ??????? ?????? ?????? ?????? ???????? ???????????? (NIST? ??????? ?????? ???? ?????? ?????? ???????? ????????).

???????

?? ????? ?????????? ?????? ??????? ??????? George Marsaglia? ???? ???????? ?? ????? ????? ???????? ??? ?????? ??? ???? ????? ??????:
http://i.cs.hku.hk/~diehard
(http://i.cs.hku.hk/~diehard)
Wichman, B.A. and I.D. Hill, Algorithm AS 183: An Efficient and Portable Pseudo-Random Number Generator, Applied Statistics, 31, 188-190, 1982.
Wichman, B.A. and I.D. Hill, Building a Random-Number Generator, BYTE, pp. 127-128, March 1987.
Rotz, W. and E. Falk, D. Wood, and J. Mulrow, A Comparison of Random Number Generators Used in Business, presented at Joint Statistical Meetings, Atlanta, GA, 2001.

?????? ???????? ????? ??? ??? ?? ???? ??? ????? ????? ??????? ????? ?? ??????? [? ??]? ???? ????? ?????? ?????? ?? ????? ???? ????? ?? ??? ?????? ??? [? ??]. ????????? ?????? ?? ????? ??????? Fortran ???????? ?? ????? Wichman ?Hill ??????? ??:

C	IX, IY, IZ SHOULD BE SET TO INTEGER VALUES BETWEEN 1 AND 30000 BEFORE FIRST ENTRY

IX = MOD(171 * IX, 30269)

IY = MOD(172 * IY, 30307)

IZ = MOD(170 * IZ, 30323)

RANDOM = AMOD(FLOAT(IX) / 30269.0 + FLOAT(IY) / 30307.0 + FLOAT(IZ) / 30323.0, 1.0)

???? ???? ?? ?? IX ?IY ?IZ ?????? ????? ????? ??? ? ?????? ???? ? ?????? ???? ? ?????? ??? ???????. ???? ??? ??? ??????? ?? ?????? ?????? ?????? ?????? ?????? ??????? ??????: ?? ???? ??? ????? ????? ??????? ????? ?? [? ??]? ???? ????? ?????? ?????? ?? ????? ???? ????? ?? ??? ?????? ??? [? ??].

????? ??? RAND ???? ?????? ????? ??????? ?????? ?? ???? ????? ????? ????? ?? ??? ???????? ????? ??????? ????? ?? ???????. ???? ????? ??? ??????? ????????? ??? ?? ????? Wichman-Hill ??? ???? ????? ???? ?? ??^?? ??? ??? ??? ????? ???????. ?? ???? ?????? ?? ???????? Diehard ????? ????? ?? ????????? ??????? ?? RAND ????? ???? ?????? ??? ????? ????? ????? ??????? ???? ??? ?????.

??????? ?? ????????? ??????? ?? Excel

???? ?????? RAND ???? ???? ??? ?? ????????? ??????? ?? Excel ?? ?????????? ????? ?? ?????? ??? ????? ????? ?? ??????? ????????? (?? ???? ?? ????? ???). ??? ???? ?????? ?? ?????? ?? ?????????? ???????? ??????? ?????????? ??? ??? ??? ??? ?????? ????? ??? ??? ????? ????? ?? ??????? ?????????.

??????? ?? Excel 2003

?? ????? ???????? ????? ??????. ??? ?????? ?????? ????? ?????????? ???????? ??????? ?????????.

???????

?????? ?????????? ????????? ????? RAND ????? ??????? ??? ??????? ????? ?? ??????? ????????? ???? ????? ???? ????? ???????? ?????? ?????? ?? Excel 2003. ??? ??????? ?????????? ??????? ???? ??? ????? ?? ??????? ???? RAND ?? ????????? ??????? ?? Excel.

???? ??? ?????? | ????? ???????

?????

????? ?? ????????? ??? ???? ???????? ???? ?? ??????? ??? ???? ???? ?? RAND? ???? ??? ??? ??????? ?????? ?????? ?? "????? ????? Microsoft" (?? ????? ??? ??????? ??? ???????? ??? ????? ?????? ?????????? (????? ?? ??? ?????? ???)):

834520

(http://support.microsoft.com/kb/834520/ )

???? ?????? RAND ?????? ????? ????? ?? Excel 2003

???? ??? ?????? | ????? ???????

???????

???? ???????: 828795 - ????? ??? ??????: 23/????�??????/1429 - ??????: 5.3

????? ???