??? ??????? ?????? ????????? ??????? Analysis ToolPak ?? Excel

?????? ????????? ?????? ?????????
???? ???????: 829208 - ??? ???????? ???? ????? ????? ??? ???????.
????? ???? | ?? ????

?? ??? ??????

??????

????? ??? ??????? ??? ????? ??????? ????? ?? ??????? ????????? Microsoft Office Excel 2003 ?????? ?? ?????????? ??????? ?? Excel ??? Analysis ToolPak (ATP). ???? ????? ATP ??????? ?????? ????????? ?? Excel ?? ????? ???? ???????. ?? ???? ?? ???????? ???? ??? ??????? ???? ??? ?????? ??? ?????? ????????? Excel ???????. ???????? ??? ???? ??? ????? ??? ATP ?????? ??????? ?????????? ???? ?????.

Microsoft Excel 2004 ?? Mac ?????????

?? ????? ??????? ????????? ?? Excel 2004 ?? Mac ???????? ??? ??????????? ???? ?? ????????? ?????? ??????? ????????? ?? Microsoft Office Excel 2003 ??? ????????? ??????? ?? Excel. ????? ??? ??????? ?? ??? ??????? ?????? ????? ??? ???? ?? ????? ????? ???? ??????? Excel 2003 ?????????? ??????? ?? Excel ??????? ' ????? ??? Excel 2004 ?? Mac.

??????? ????

?? ????? ????????? ???????? ?? ATP ?????? ???????? to ????? ????????? ?? ???? ????? ANOVA ATP ??.

?????? ??? ??? ATP ?? ????? ????? ????? ????? ?????? ?? Excel 2003 ?? ?????????? ??????? ?? Excel ???? ?????? ?????? Excel ??????? ???? ???? ??????? Excel 2003 ??? ??? ?????????? ??????? ?? Excel. ?? ??????? ??? ???? ????? ?????? ?? ????????? ??????? ?? Excel ?????????? ?????? ?? Excel ????? ??????? Excel 2003 ??? ??? ?????????? ??????? ?? Excel ???? ???.

??? ???? ?????????? ?? ????? ?????? ?? ????? ??? ??????? Excel ????????. ???? ???? ?????????? ???? ??? ???? ?? ????? ?????? ????? ??? ?????? ??? ?? ??????? ??????. ??? ???? ??? ?? ???? ??? ??????? ????? ?????? ?????? ???? ??? ???? ?????????? ????? ???? ??? ???? ?? Microsoft Excel 2002 ??? ????????? ??????? ?? Excel. ???? ?????? ?? ??? ?????????.

????? ???? ???? ???? ??? ????? ?? Excel 2002 ??? ????????? ??????? ?? Excel ????? ?? Excel 2003 ?????????? ??????? ?? Excel. ???? ?????? ATP ?? ??? ????????? ??? ???? ??????? Excel.

?????? ???? ???? ???????? ????? ???? ???? ???? ?????? ?? ???? ???????? ?????? ?? ???. ?? ????? ??? ?? Excel 2003 ?????????? ??????? ?? Excel. ?? ??? ???? ????? ???? ???????? ??? ??? ???? ???????? ?????? ?? ??? (?????? ????????? ???? ?? ??????? ??????).

??????? ??? ??? ?????????? ?? ???? ??????? Excel ???? t-Test ATP: ?????? ????? ?????? ?? ???? ?????? ??? ??? ???? ?? ???? ?? ????????? ???????? ????????. ???? ?????? ?????? ??? ?????? (?? ?? ?????? ???????) ??? ??? ???? ???? ?? ???? ?? ????????? ????????.

?????? ??? ???? ?? ????????? ??? ???? t-Test ATP ????? ????? ?????? ????? ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft:
829252?? ???? ????? ??? ????? ? ?????? ????? ??? ??????? t-Test Analysis ToolPak ?? Excel
??? ??? ???? ??????? ??? ?????? ???? ????? ???? ?????? (?? ??? ??? ???? ??? ???? ?????? ??????) ?????? TTEST ?? Excel ????? ??????? ??? ???? ????.

??? ????? ????? ?????? ?????? ?? ??? ??????? ?????? ??? ??????? ??? ????? ATP ???????. ??????? ???? ?? ??? ??? ?? ?? ??? ????? ????????? ?? Excel 2003 ?????????? ??????? ?? Excel.

ANOVA: ?????? ???? ? ?????? ?????? ??? ?????? ????????? ?????? ?????? ??? ????? ????????

?? ?? ??? ??????? ANOVA ????? ??? ?? ????? ????? ?????? ??????? ???????? ???????? ???????? ?????? ???? ??????. ???? ??? ????????? ????????? ?? ??????? ????????? ???? ????? ?????????? ??????? ??? ??? (??? ???? ??????: VAR ? STDEV ? ????? ? PEARSON).

????? ?? ????????? ??? ANOVA ATP ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft:
829215????? ??? ??????? ????? ?? Analysis ToolPak ANOVA ?? Excel

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

?? ??? ????? ??? ??????. ??? ???? ???? ?????? ???? ??? ???? ???????? ???? ??????? ??????? ??? ??????? ?? ???? ??????? Excel. ????? ???? ?????? ???? ?????? ??????? ?????? ?? 1 "????" ? "?????????? ????? ??????. ?????? CORREL ????? ??????? ????? ???? ?????? ????? ?????? ??? ????????? ?? ?????? ???? ?? ??????? ?????? CORREL. (???? ??? ???? ?? ????? ???????? ? ?? ????? ?? ???? ?????????. ??? ?????? ?? ???? ??????? ??????? ???????.)

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

????? ??? ?????? ???? ??????? ??????? ??????? ?????? ??? ??????? ???? ? covariances ????? ??????. ????? ??????? ??? ?????? ?????? "= VARP(...)" ???? ??? ???? ????? ?????? ?? ?????? ????? ????? ??????. ?? ????? VARP Office Excel 2003 ? ?????????? ??????? ?? Excel.

????? ?? ????????? ??? VARP ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft:
826393??????? ????????? ?? Excel: VARP
???? ??????? ??????? ?????? COVAR ????? ??????? ????? ???? ????? ?????? ??? ????????? ?? ?????? ???? ?? ??????? ?????? COVAR. ????? ??? ???? ????? ?????? ?? ??? ?????? ??????? ????? ????.

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

??? ?????? ?????? ?????? ????????? ?? Excel ?? ??? ???? ????. ???? ??? ????? VAR ? STDEV ??????? Excel 2003 ??? ??? ?????????? ??????? ?? Excel, ???? ??? ?????? ????? ????? ????? ?????? ????? ?? ??????? ??????.

????? ?? ????????? ??? VAR ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft:
826112??????? ????????? ?? Excel: VAR

?????? F ?????? - ????? ????????? ?????????

??? ?????? "???????? ?????" ???????? ??? ?????? VAR. ??? ????? ??? ?????? ????? ????? ????? ?????? ????? ?? ??????? ??????.

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

??? ?????? ???? ???? ?? ????????? ??????. ??? ??? ????? ?? ??? ????????? ?????? ?? ??????? ???? ?? ??? recomputed ??? ????? ?????? ???? ??????? ????????? ????? ??? ????? ???? ??????. ?????? RAND ??????? ?? Excel? ?? ????? ????? ??????? ??????? ???????? ???????? ????? ?? ??? ??? ???? ????? ???? ??????. ???? ??????? RAND ???????? ??? ?????. ?????? ????? ??? ??????? ?? ???? ? ?? ?????? ??????? ??? ??? ???? ????? ?? ??? ??????.

???? ???? ????? ??? ??????? (RNG) ????? ????????? ?????? ?? ??????? ???????? ???????? ????? RAND ?????? ?? ???? ???? ?? ??????: ???? ?? ?????? ??? 0 ? 1. ???? ??? ??????? ????? ?? RAND ?? ??????? ????????? ?? Excel ????? ??? ?????????.

????? ?? ???????? ???? ??????? ???? ??? ?????? ATP ???????? RAND ? ??? ingenuity. ?? ??? ??????? ???? ???? ? ???? ??? ????? ??? ?????? ?????? ?? ??????? ?????????.

?? Excel 2002 ?????????? ??????? ??? ???? ???? ???? ??????? ????????? ATP ? RAND ?????? ???? ??? ??? ?????????? ???????? randomness. ?? ????? ?????? ???? ??? ???? ??? ??? ????? ????? pseudo-random ???? ???? ????. ??? ????? ??? ?????? ?? ??????? ????????? ??????.

?? ????? RAND ??????? Excel 2003 ??? ??? ?????????? ??????? ?? Excel ???? RAND ?????? ???? ?????????? ???????? ??? ????. ???? ??? ????? ????? RAND ????? ????? ?????? ???? ???? ??? ??? ????? trillion 1 ???? ?? ?????.

????? ?? ????????? ??? RAND ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft:
828795??? ?????? RAND ?? Excel
??? ???? ?? ??? ????? ATP ???? ??????? ????????? ??????. ??? ?? ????? RAND ??? ?? Excel 2002 ??? ????????? ??????? ?? Excel ????? ATP ???? ??????? ????????? ?????? ?????? ???? ??? ??? ?????????? ???????? randomness ???? ????? ?? ???? ????? ?????. ??? ?? ?????? ??????? ??? ??? ??? ?? ???? ??? ????? ????? ???? ?? ????? ??????? (??? ???? ??????? 1 ?????).

???? ?????? RNG ????????? ?????? ?? ??????? ???????? ???????? ? ?????? [??? ? ??] ? ??????? ??????? ????? ??????? ????????? ??? RAND. ???? ATP ????? ??? ??? ?????? [0,1] ???? ????????? (?? ???? ?? ???) ??? ?? ????? ??????? ??? observation ?? ??? ??????? ????? ???????. ????? ???? ?? ???? ????? ????? ???? RAND ???? ???? ????? ????????? ?????? ?? ? ????? ??? ??????? ????? ???? ?????? RAND ?? ?????? ?????. ??? ?????? ? ???? ??? cautionary ????????? ??? ?????? ??????? ?????? Analysis ToolPak.
?? ??? ??????????? ??? ??????
??????????? Excel ???????? RAND()
Bernoulli(p)=IF(RAND() < = p 1, 0)
Binomial(n,p)= CRITBINOM(n, p, RAND())
?????????? ?????
???? (mu ? ?????)= NORMINV(RAND(), mu, ?????)
????????? ????? ??????
Poisson(mean)???? ?????
uniform (?????? ? ?????)= ?????? + (???? ? ?????) * RAND()
???? ?????? ???? ?? ???? RAND ? ?????? ???????? ?? ??? ?????? ????? ?? ATP ?????? ??? ?????? ?? ???? ???? (mu ? ?????). ?????? RAND ???? ???? [0,1] ?????? ??? ???? ?? ????? ATP. ??????? ?? ???????? ???? ATP Excel ????? NORMINV ????? ???? ????? ?? ??? ????? ??????? ?????? ????? ?? ?? ????? ??????? ??????. ??? ??? ???? ?????? NORMINV ???? ?? Excel 2003 ?????????? ??????? ?? Excel. ??? ????? ?????? ?? ??? ????? ??????? ?????? ???? ?????? (?????? Excel ???? NORMSDIST ??????? ?????) ?? ????? ????? ???????? (Excel ???? ??? ????? ????? ??? ???? ???? ???? ??? ??????? ???????? ????? NORMINV). nutshell ???????? ATP ?? ??? ?????? ?? ????????? ?? ??????? ??????? Excel 2003 ??? ??? ?????????? ??????? ?? Excel ?? ????? NORMINV ? NORMSDIST RAND.

?????? ??? ????????? ?? ????? ?????? ???? ?? ????? ?? ?????? B ??? ?????????? ?????? ??? ?? ?????? C. ???? ??? ?? ????? ?? ?? ?? ?????? ?? ?????? ?????? ???? ????? ??? ?? ?????? ?? ?????? B ?? ????. ????????? ?? ???? 10 ??? ????? ?? ??? ???????? ?? ??????? A1:C10. ??? ??? A1 ????? ??? ?????? ?????? ???? ????? ??? ?? ?????? ?????? ???? ??????? ??? 0. ????? ??????? VLOOKUP(RAND() A1:C10, 2); ??????? ??????? ??? VLOOKUP ???????? ??? ?? ???? ?? ????? ?? ????? ??? TRUE. ???? "2" ???? ?????? ?????? ?????? ?? ?????? ?????? (?????? B ?? ??? ??????).

?????? ATP ??????? ??? ??????? ????? ????????? Poisson ?? Teukolsky ???? ? W.H. ? S.A. ?? Vetterling T. "???" ? ? Flannery B.P. ?? ????? ???? ?? C "???? ?? ???? ???????" ? ?????? ?????? ???? ????? Cambridge ? 1992 pp. 293-295. ???? ????? ?????? ????????? ?? ???????? ???? ????? Excel.

?????? ????? observation ?? ????? ?????? POISSON ??????? m ?? ????? ??? ????? ????? ?????? ?? ?????? (n ? m/n) ?? n ?????. ?? ???????? CRITBINOM(n, m/n, RAND()). ????? ???????? n ??? m; ??? ?? ???? ???? ?? 1000 ???? m ?????? ???? ????.

????? ?????? ??????? POISSON ??. ?? ???? ???? ????? ???????? ??? ????? POISSON ?? ???? m ?? ???? ??? ??? ????? ??? ????? ????? ??? ?? ????? 1/m. ?????? ??? observation POISSON ????? ?????? ??? ????? ????????? ?? ????? ??? ?? ???? ??? ??? ???? ??? ?? ?????? ????? ?????? ??? 1. ?????? ??? observation ?? ????? ??? ? ?????? GAMMAINV(RAND() 1? 1/m). ????? ?????? ??? ??????? ????? ???? m ?????? ?????? ?? 0.

????????

???????? ???? ???????? ?? Excel LINEST. ???? ??? ??????? ??? LINEST ??????? ????? ??????? Excel 2003 ??? ??? ?????????? ??????? ?? Excel.

????? ?? ????????? ??? LINEST ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft:
828533??? ???? LINEST ?? Excel
?? ???? ??????? Excel 2002 ?? ????? ???? ?? Excel ???? ??? shortcomings ????? ?? ???? ???????? ATP ?? LINEST:
  • ?????? "????? ?? ??????" r ??? ? ????? ????????? f ??? ????? ????? ????? ??? ??? ???????? ???? ?????.

    ?????? ??? LINEST? ???? ???? ???? "??????? ??????? ????? FALSE ????? ?? ?????? ??? TRUE ?? ?? ?????." ?????? ??? ?????? ATP ???? ???? "??? ???? ???????? ?????? ?? ???."
  • LINEST ????? ATP ??? ????? ?????? ?????? ??????? ?????? ?????????. ?????? ??????? ?? LINEST ????? ???????? LINEST ?? Excel 2003 ?????????? ??????? ?? Excel ?? ????? ????? ?? ????? ???? ??????? ?? ?????? ?? ????? ?????? ??? ????? ? ????? ???? ?????.
?? ?? ?????? ??? ?? ?? ??? shortcomings LINEST ?? Excel 2003 ?????????? ??????? ?? Excel. ??? ??? ????? ?????? ???? ???????? ATP ???? ?????. ?? ??? ????? ??? ?????? ??? ???????; ?? ????? ?????? ??????? ???? Excel ?????. ????? ??? ?????? ??????? ?? LINEST ????? ?????? ????? ?? ????????? ?????? ?????????.

???? ?????? ?????? ????? ???? ???????? ????????? ??????? ?? Excel ? ?????????? ??????? ?? Excel ?? ????? ???? ???????? ?????? ?? ???. ???? ??? shortcoming ????? ???? ??? ???? ??????. ?? ????????? ??????? ?? Excel: ?????? ????? ???????? ????? ??? ???? ???? R.
?? ??? ??????????? ??? ??????
X????? Y
111
212
313
Excel 2002 ?????????? ???????
???? ???????
?????? ??????????
R ??????65535
R ????-20.4285714
??? R ????-20.9285714
????? ???????4.629100499
?????????3
anova
dfss???? ?????f??????? F
????????1-40.85714286-40.85714286-1.90666667# NUM!
??????242.8571428621.42857143
??????32
Excel 2003 ?????????? ??????? ?? Excel ???????
???? ???????
?????? ??????????
R ??????0.949342311
R ????0.901250823
??? R ????0.401250823
????? ???????4.629100499
?????????3
anova
dfss???? ?????f??????? F
????????1391.1428571391.142857118.253333330.14637279
??????242.8571428621.42857143
??????3434

t-Test: ?????? ????? ?????? ?? ????

??? ???? ?????? ???? ??? ?????? ?? ???? ???? ??? ???? ???? ?? ???? ?? ??? ???????? ????????. ??? ????? prototypical ??? ???????? ????? ?? ???????? ??? ?????? ??? ? ??? ???????? (??? ??????? ??? ? ??? ??? ?????? ????? 60 ???). ?? ???? ?? ????????? ???????? ?????? ????? ???? ???. ?? ???? ????? ?????? ?? ????? ??? ? ??? ????????? ???? ????? ??? ? ??? ?? ????? ?????? ?? ???. ??? ??? ???? ?????? ????????? ?????? ?? ????? ??? ? ??? ????????? ??????? ? ???? ?????? ???????? ???? ????? ??? ??? ?????.

??????? ??????? ?????? ????? ?? ???????? ??? ??? ??? ?? ??? ?????? ????? ?????? ???????? ???? ????? ??? ??? ??? subjects ?? ????? ?? ??? ? ??? ????????. ????? ?? Excel TTEST ?????? ????? ???????? ???????? ??? ??? ??????? ???????.

??? ?????? ?????? t-Test ??????? ??????, ????????? ?????? ????? ?? ?????? ?? ????? ????????? ? ????????? ?????? ????? ?? ?????? ??? ????????? ? ??? ???.

z-Test: ?????? ??? ????? ?? ????

????? ??? ??????? ??? ??????? ??? ?? ???? ??????? ?????? ???? ????? ????? ???????? ?? ???????? ?????? NORMSINV (?? ???? ???? ??? NORMINV ?????? NORMSINV) ????? ????? ?????? ?? ??????? ????? ????? ?? ??? ????? ??????.

??????? ???? NORMSINV ?????? z-Test ?? ????????? ?? ??????? ??????? Excel 2003 ??? ??? ?????????? ??????? ?? Excel.

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

???? ????? ATP ?????? ???? ?? ????? ??????? Excel 2003 ?????????? ??????? ?? Excel ??????? ??? ??????? ?????? ????????? Excel ?? ????? ??????? Excel 2003 ??? ??? ?????????? ??????? ?? Excel. ??? ??? ????????? ??? LINEST? ???? ??? ????? ??????? ??????? ????? ?? ??? FALSE ? ????? ???? ???????? ATP ????? ????? ??? ????? ?? Excel 2002 ??? ?? ????????? ??????? ?? Excel ????? ?????? ?? ??? ???? ???????? ??? ?????. ?? ????? ????? ??? ?? ????? ????? Excel ??????? ????????? ??????? ??? ??????? ?? ????? ?????????? (????? ???? ??? ?????????? ????? ?????? ????? ?? ??????? ??????).

?? ????? ???? ????? ANOVA ATP ?? ???? ????? ????????? ???????? ATP ??????? ???????? ?????? ???? ?????? (?? ??? ???? ?? ??????? ?? Excel VAR). ?? ??????? ?? ????? ?????????? ??? ?? ??????? ?????? ?????????? ??? ??????? ?? ????????? ??????? ?? Excel.

????? ??? ?????? ??????? ???? ?????????: ???? t-Test: "?????? ????? ??????" ?? ???? ??? ??? ???? ???? slightest ????? ????????.

??????? ?? Excel 2003 ?????????? ??????? ?? Excel

?? ????? ??????? ???? ?? ??????? ????????? ?? Excel. ??? ????? ??? ????????? ?? ?????? ?? ??????? ATP ???? ?????? ??? ???????. ???? ?????? ATP ????? ?????? ??? ???? ? ???? ?? ?????? ?????? RAND ????? (???? ??? ????? ?????? ?????? ??? ?? ???????? RAND). ??? unfortunate ???? unfortunate ???? ?? ???? ???? ?? ????????? ?????? ????? ???? ????. ????? ??????? ?????? ????? ????? ?????? ?????? ?? ?? ???? ???????? ?????? NORMSINV ??????? ?????.

???? ?????? ?????? ????? ATP ???????? ??? Excel ???? ??????? ???? ?? ????? ??????? Excel 2003 ??? ??? ?????????? ??????? ?? Excel. ??? ??????? ?????? ???? ?????? ??? ?? ???? Excel ????.
?? ??? ??????????? ??? ??????
???? ATP????? Excel ???? ????
ANOVA: ???? ????VAR finv
ANOVA: ?????? ?????? ??? ?????? ?????????VAR finv
ANOVA: ?????? ?????? ???? ????? ????????VAR finv
????? ????????
??????? ???????
???????? ?????VAR STDEV TINV ?
????? ???
?????? F ?????? - ????? ????????? ?????????VAR finv
????? Fourier
???? ??????
?????? ???????
????? ??? ??????
?????? ? ?????? ???????
????????linest
??? ???????rand
t-Test: ?????? ????? ?????? ?? ????VAR PEARSON ? tinv
t-Test: ????? ?????? ?? ?????? ????????? ????????? ?????VAR tinv
t-Test: ????? ?????? ?? ?????? ????????? ?????????VAR tinv
z-Test: ?????? ??? ????? ?? ????NORMSDIST normsinv
?????? ??? ???? ??????? ???? ???? ?? ??? ?????? ??? LINEST ?? RAND ?? ??????? ?????? ?????????? ??? ????????? ??????? ?? Excel ?????????? ?????? ?? Excel ??? ????? ????? ?????? ????? ?? ??????? ??????. LINEST ?? ????? ????? ??? ??? ??????? ?? ????? ????. ?? ????? RAND ?????. curiously ? ???????? ???? ??????? RAND ???? ?????? RNG ????? ??? ???? ????? ????? ????? ?????? ??? ??? ????? ????? ?? ????????? ??????.

??????

???????? ????????? ??? ATP ??? ?? ????? ????? ANOVA ??? ATP ????? ?? ??? ?????. ??? ???? ???? ??????? ?? ??????? ????? Excel ??????? ??? ?? ???? ?? ?????? ???? ATP. ????? ?? t-Test: ?? ?? ??????? "?????? ?????? ?????" ?????? ???? Excel 2003 ?? ????????? ??????? ?? Excel. ??????? ??????? ?????? ?? ??????? ?? ???? ?? ???? ???????? ??? LINEST ??? ????? ????? ??? ????? ??? ????? ???? ???????? ?????? ?? ??? ???? ?? ????? LINEST ??????? ????? ???? ??????? ???? ?????.

???????

???? ???????: 829208 - ????? ??? ??????: 03/????/1428 - ??????: 4.2
????? ???
  • Microsoft Office Excel 2007
  • Microsoft Office Excel 2003
  • Microsoft Excel 2004 for Mac
????? ??????: 
kbmt kbformula kbexpertisebeginner kbfunctions kbfuncstat kbinfo KB829208 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????829208

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

 

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