??? ?????? 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
  • 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 ???? ?????? RAND ?????? ????? ????? ?? Excel 2003

???????

???? ???????: 828795 - ????? ??? ??????: 23/???? ??????/1429 - ??????: 5.3
????? ???
  • Microsoft Office Excel 2007
  • Microsoft Office Excel 2003
????? ??????: 
kbfuncstat kbfunctions kbinfo KB828795

????? ???????

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com