?????? ????? ?? ????? ????? t-Test Analysis ToolPak ?? Excel

?????? ????????? ?????? ?????????
???? ???????: 829247 - ??? ???????? ???? ????? ????? ??? ???????.
????? ???? | ?? ????

?? ??? ??????

??????

???? ??? ??????? ?????? ????? ???? ?????? ?? ????? ?? ?? ????? ????? t-Test Analysis ToolPak ? ????? ??? ????? ???? ??????? ???????.

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

?????? ??? ??????? ?????? ??? t-Test: "?????? ????? ??????" ????? ???? ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft:
829252Analysis ToolPak Excel ??????? ?????????: t-Test: ?????? ????? ?????? ??????? ????

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

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

??????? ????

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

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

?????? ????? t-Test ????? ???? Excel ???? ??? ??? ?????? ?????? ?? ??? ?????? A1 ?? ???? ??? Excel ???????. ?? ?? ???? ????????? ???? ???? ?????? ?????? A1:C20 ??????? ?? ???? ?????.
?? ??? ??????????? ??? ??????
200220
190210
180 ????200
170190
160180 ????
150170
t-Test: ????? ?????? ?? ?????? ????????? ?????????
??????? 1????? 2
?????175195
?????350350
?????????66
?????????? ????? hypothesized0
df10
t ????-1.8516402
P(T<=t) ???? ????0.046896275
t ???? ???? ????1.812461102
P(T<=t) two-tail0.093792549
t two-tail "????2.228138842
?????? ??? ??? ??? ?????? ?? ???? ??? Excel ???? ??? ???? ?????? ????? ? ?? ???? ??? ????? ????? ??????. ?? ??????? ????? ?????? ???? ?? ????? ?????? ??? ????????? ??????? ??? ?????? ?? ????? Excel ???? ???? ???????:
  • ?? Microsoft Office Excel 2007? ???? ??? ????? ??????? ?????? ???????? ???? ??? ????? ?? ???????? ????? ?? ???? ??? ?????? ?????? ???? ??????.
  • ?? Excel 2003? ??? ??? ???? ?? ??????? ????? ?? ???? ??? ?????? ?????? ???????.
?????? ???????? ??? A1:B6 ???????. ????? ??????? A8:C20 ??????? ???? ???? ????? t-Test ?????? ????? ????? ??? ??????? ??? ???????. ???? ????? ????? ??? ??? ?? ????? ?????. ?? ????? ???? ??????? ??????? ???? ?????? ???????? ?? ??? ??????; ????? ??????? ??? ?? ?????? ?????? ?? ???? ????? (?????? ?? ????? ??? ?? ?????? ??????). ???? ?????? ?? ??? ??????? ??????? ??? ???? ???? ????????.

???? ??????? ?? ??? ??????? ??? ??? ????????? ?? ???? 16 ??? 20. ?? ?? ???? ???? ??????? t ?????? t, ? ????? ?? "t ????" ?? ????? ???????. ???????? ??? ???????? ?? ??? ?????? ?? t, ???? ?? ???? ????? ?? ??? ????. ??? ????? ????? ????? ??????? ??????? ??? ??? t ??? ?? 0 "P(T <= t) ????- tail" ???? ???????? ???? ???? ??????? t ???? ???????? ???? ????? ???? ?? t. ??? ???? t ???? ?? ?? ????? 0 ???? "P(T <= t) ????- tail" ?????? ?????? ???? ??????? t ?? ?????? ???? ?? t. ????? ??? ??? ??? ??????? ??????? ?? ??? ???? ??? ? ????? ??????? "P(T > |t|) ???? ?????".

???? "t ???? ????- tail" ???? cutoff ???? ???? ?????? ?? observation ?? ????? t ?? df ????? ?????? ???? ?? ?? ????? "t ?????? ????- tail" Alpha. ??????? ????????? ???? 0.05 ?? ???? ???? ??? ???? ????? ?? ???? ?????? ???????. ???? ?????? ??? ???? t ???? ????- tail ????? ???????? ?????? TINV(2*Alpha, df) ?? Excel. ????? ??? ???? TINV ?? ???? ?????? ????? t-test ? ??????? 2 * Alpha ????? ?? ????. ???? ???????? ????? ????? ?? ???? t ???? ?? ?????? ??????? ?? ??? ???? ??? 0.10 ???????? ???? ????? ?? ???? t ???? ?? ??? ???? ?? 0.05 (??? ???????? ???? ????? ?? ???? t ??? ?? ????? ??? ????).

???? "P(T <= t) two-tail" ?????? ?? ???? t ?? ???? ???? ???????? ???? ???? ?? ?????? ??????? ?? t. ????? ??? ??? ??? ??????? ??????? ?? ??? ???? ??? ? ????? ??????? "P(|T| > |t|) ????? ????".

???? "t ?????? two-tail" ???? cutoff ???? ???????? ???? ??? ???????? t-??????? ???? ?? ?????? ??????? ?? "t ???? two-tail" Alpha. ???? ?????? ??? ???? t ???? two-tail ????? ???????? ?????? TINV(Alpha, df) ?? Excel.

???????

???? ???????: 829247 - ????? ??? ??????: 27/?? ?????/1427 - ??????: 3.2
????? ???
  • Microsoft Office Excel 2007
  • Microsoft Office Excel 2003
  • Microsoft Excel 2004 for Mac
????? ??????: 
kbmt kbexpertisebeginner kbfuncstat kbfunctions kbinfo KB829247 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????829247

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

 

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