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

?????? ????????? ?????? ?????????
???? ???????: 829252 - ??? ???????? ???? ????? ????? ??? ???????.
????? ???? | ?? ????

?? ??? ??????

??????

???? ??? ??????? ?? Analysis ToolPak t-Test ???? "????? ?????? ??????" ????? ????. ?? ??? ????? ??? ?????? ?????? ??? Microsoft Office Excel 2003 ??????? ??? ?????????? ??????? ?? Excel. ??? ???? ???? ??? ?????? ????? flawed ??? ???? ?????? ??????. ???????? ??? ???? ?? ??? ??? ???? ?????? ?????? ?? ?? ???? ?????? ????? ?? ????? ??????.

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

?? ????? ??????? ????????? ?? Excel 2004 ?? Mac ???????? ??? ??????????? ???? ?? ????????? ?????? ??????? ????????? ?? Excel 2003 ?????????? ??????? ?? Excel. ????? ??? ??????? ?? ??? ??????? ?????? ????? ??? ???? ?? ????? ????? ???? ??????? Excel 2003 ?????????? ??????? ?? Excel ??????? ' ????? ??? Excel 2004 ?? Mac.

??????? ????

???? ???? ????? ????? ?? "?????? ?????? ?????" t-Test (???? ?? ??? ??????? "????? ?????" t-Test) ????? ???? ???? ??? ? ??? ???????? ??? ????? ??? ?????? ??? ????????. ??? ???? ??????? ?? ???? ????? ??? ????????? ??? ???? ??? ?????? ????? 30 ???.

???? ???? ????? ?????? ?? ???????? ??? ?? ????? ????? ??? ?????? ?? ??? ?????? ?????. ???? ???????? ??? ????? ??? ????? ??? ??????? ??? ??? ??????? ??? ?????. ?????? ??? ?????? Analysis ToolPak ???? ????? ??????? ?????? ?????????. ?????? ??? ?????? Analysis ToolPak ????? ??? ????????? ?? ??? ???????? ???? ????????? ?? ??? ????????. ??? ???? ??? ?????????? ??????? ???? ????? ??? ??????? ??? ?????? Analysis ToolPak ??. ????? ??? ???? ??????? ??? ??? ???? ???????? 49 ????? ???? ??? ? ??? ???????? ? fiftieth ???? ????? ??? ??? ???? ? ???? Analysis ToolPak ?? ???????.

??? ??? ??? ???????? ???? ?????? ??? ???????? ????? ??? ???????? ???? ?????? ??? ?????? ??? ????? ?????? ?????? ????? ????? ??? ??????. ??? ???? ??????? ????? ?? ???? ???????? 50. ????? A ??????? ?????? ??? B ??????? ????? ???? ??? ?? ???????? 48 ???? ?? ????? ??? ????? ??????. ?????? ????? 49 ??? ???????? ? 49 ??? ????????; ????? ?????? ??? ?? ?? 49 ????????? ?? ????? ????????. ??? ?????? ??? ?????? ???? ?????? ?? ?? ????? ????? ???? ??? ?? ???? ??? ?????. ??? ?? ???? ??? ???????? ?? ??? ?????? 48 ?? 49. ????? ?????? ?????? ??? ??? ???? ?? ????? ??????. ???????? ??? ???? ????? ??? ?????? ?????? A ??????? ?? ????? ??? ?????? ??? B ??????? ??? ?????? ??? ????? ??? ???????? ????? ?? ???????? ???????? ???? ????? ????????? ?? ??????? t. ????? ??? ???? ???? ????? ??? ??? ??????.

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

?????? ?? ?????? "???? ?????????" ?? ??? ??????? ?????? ??? ???????? ????? ????? ?????? ???? ???????? ?? ????? ??????. ????? ??? "???? ??????" ?? ??? ??????? ???? ?? ???? ??? ????? ?????? ???? ????? ???????? ??? ??????? ??????.

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

????? ????? ????? ????????, ????? ???? ??? Excel ????? ?? ?? ???? ?????? ??????. ??? ?????? A1 ?? ???? ??? Excel ????? ?? ?? ???? ????????? ???? ???? ?????? A1:I52 ??????? ?? ???? ?????.
?? ??? ??????????? ??? ??????
????? 1???????? 2????? 3????? ?????? ????? 3
??????????????????????????? ?? ?????? ??????
200170200170200170200170
190180 ????190180 ????190180 ????190180 ????
180 ????175180 ????175180 ????175180 ????175
170175170175170175170175
160165160165160165160165
150140150140150140150140
140130140130130130125
130125130125130125120125
120125120125120125110100
110100110100110100
100100100100
???? t-test ????? 2
= ttest(a3:a13, b3:b13,2,1)= ttest(c3:c13, d3:d13, 2, 1)= ttest(e3:e13, f3:f13, 2, 1)
= ttest(c3:c12, d3:d12, 2, 1)= ttest(g3:g11, h3:h11, 2, 1)
???? ATP ?? ????? 1:
t-Test: ?????? ????? ?????? ?? ????
??????? 1????? 2
?????150144.090909090909
?????1100914.090909090909
?????????1111
????? Pearson ???????? ????? ????????0.952384533866487
????? ????? hypothesized0
df10
t ????1.92092590483801
P(T<=t) ???? ????0.0418403929085198
t ???? ???? ????1.81246110219722
P(T<=t) two-tail0.0836807858170396
t two-tail "????2.22813884242587
???? ATP ?? ????? 2:
??? ?? ????? ????? ????? datapoints ??? ???????
???? ATP ?? ????? 3:
t-Test: ?????? ????? ?????? ?? ????
??????? 1????? 2
?????151148.5
?????1210778.055555555556
?????????1010
????? Pearson ???????? ????? ????????0.936537537274845
????? ????? hypothesized0
df9
t ????0.141327169509421
P(T<=t) ???? ????0.445362157564494
t ???? ???? ????1.83311292255007
P(T<=t) two-tail0.890724315128988
t two-tail "????2.26215715817358
??? ??? ?????? ?? ???? ??? Excel ? ???? ??? ???? ?????? ????? ? ?? ???? ??? ????? ????? ??????. ?? ??????? ????? ?????? ???? ?? ????? ?????? ??? ????????? ??????? ??? ?????? ?? ????? Excel ???? ???? ???????:
  • ?? Microsoft Office Excel 2007? ???? ??? ????? ??????? ?????? ???????? ???? ??? ????? ?? ???????? ????? ?? ???? ??? ?????? ?????? ???? ??????.
  • ?? Excel 2003? ??? ??? ???? ?? ????? ??????? ? ?? ???? ??? ?????? ?????? ???????.
??????? ???? ??? ??????? ????? TTEST ???? Excel ???????? ???? Analysis ToolPak. ???? ????? 1 ?????? ????? ??? ?????? ???? ??? ?????. ???? TTEST ?? ?????? A16 ???????? ???? t ?? ???? ???? ?? ???? ??? ???????? ?? ?????? t-????? ?? ???? ????? ??????. ??? ??? ??? ?????? 0.837 ? ????? ?? ????? ?????? ?? ?????? B32. ??? ??????? ?? ?????? ???? ????? A32 "P(T >= |t|) two-tail" ?? "P(T<=t) two-tail" ???? ??????? ??????? ???? ?? ???? ??? ?????? ?????? ?? ????? 1. ????? ?????? ??????? ?? ?????? A30 ??? ????? "P(T >= |t|) ????- tail" ? ?? "P(T<=t) ????- tail". "t ????" ??? cutoffs. ???? ?????? ?? ????? ??????? ????????? 0.05, ?? ?????? ????? ?????? ?? ?????? ?????? 10.

????? ????? 2 ?????? ????? ??? ?????? ??? ????? ???? "?" ?? ???? ?????? ???? ??????. ???? ?????? ?????. ??? TTEST ?? ??????? A16 ? A17 ?? ?????. ?? ?????? A16 ??????? C3:D13 ???? ?????? ????????; ????? ??? ??????? ??? ???? ??? ?? ?????? ??????. ?? ?????? ??????? A17 C3:D12 ???? ?????? ????????; ??? ????? ????? ?? ???????? ?????? ?????? "?" ????? ????????. ????? ?? ??????? ?? ??? ???? ??? ??? ????? ??? ??????? TTEST ?? ?????? A16 TTEST ???? ????? ?????? ??????? ?? ?????? ??????.

????? ????? 3 ?????? ????? ??? ?????? ? ?????? ????? ??? ?????? ??? ?????? ?????? ?????. ????? ????? 3 ???? ???????? ???????? ???? ?? ????? ????????. ????? TTEST ?? ??????? E16 ? E17 ?? ?????. ?? ?????? E16 ???? TTEST ??? ?????? 3 ????? ?? E3:F13 ???????. ?? ?????? E17 ???? TTEST ??? ?????? 3 ????? ????? ?? G3:H11 ???????. ???? ??? ??????? ???? TTEST ???? ????? ?????? ???????? ?????? ? eleventh ?? "????? 3?" ?????? ?? ?????? ??????. ?? ???? ??? ????? ?????? ?? 3 ????? ????? ?? ??? ? ??? ????????? ?? ??????? B44 ? C44 10 ?? ?? ????. ??? ?? ????? ??? ?????? ?? ?? ??? SUM(E3:E13) 1510 ?? ??? SUM(F3:F13) 1485; ????? ????????? 10 ?? ?? ???? ???? ??????? 151 ? 148.5 ???? ?? ??????? B42 ? C42. ????? ?????? ?? ????? ??? ??????? ?? ????? ? ???? ??? ??????? ?????? ? ???? ??? ??????? eleventh ?? ???????. ??? ????? ?????? ?? ?????? B47 ??? ?????, ???? ??? ?? ???? ???? ???? ??????? ? df ??????. ??? ???? ????????? ??? ????? ?? cutoff ????? ?? ??????? B50 ? B52 (???????? ??? ????? ?????? ????????? ?? ??????? A50 ? A52.)

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

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

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

????? ?????? ?? ??????? ?? ????? ???????? ??? ??????? ??????. ??? ???? ?? ?? ???? ?? ????? ???? ??? Excel ???? ???????. ??? ????? ????? ???? ?? ??? ????? ????????? ?? ?????? ?????? ?? ??????? ???????. ?????? ?? ????????? ?? ?????? ?????? ???? ??????? ???????:
  1. ??? ?????? ?????? ??? ????? ????? ?? ???? ????? ?????? ??.
  2. ??? ???????? ??? ???? ?? ???? ?????? ???????.
    1. ??? ????? ???? ?????? ??? ????? ????????, ?? ?????? ????? ???? ??????. ???? ??? ??? ????? ???? ????????. ????? ??? ?????? 3.
    2. ????? ?? r ???? ???? ?????? ???? ?????? ??? ?????? ?? ??? ??????.
      1. ??? ???? ???????? ???????? ???? ???? r.
      2. ??? r ?? ?? ?? ??? ???????? ???????? ??.
      3. ?? ?????? ????? ???? ?????? ?? ???????? (???? ???? ???? ????? ????? ?? ???????? ??????). ???? ??? ??? ????? ???? ????????.
  3. ??? ?????? 2 ??? ?? ???? ???????? ????????.
?????? ????? ??????? ?????? ??? ???? ?? ???? ?? ????????? ????????.

????? ????? ???? ???? ??? ???? ?????? ????? ????? ??? ????? ????????. ?? ???? ?????? ??? ????? ???????? ?? Mean ? ??????? ????????? ??? ???? ?? ??????? ". ???? ?????? ??? ??? ??? ?????? ?? ???? ??? ??? ? ??? ???????? ???? ?????. df ?????? ?????? ??????? ?? ????????? ???? ????; ????? ???? ????? ??? ?????? ??? ??? ???? ?????? ??????. ????? ?????? t ???? ???? ???? ?? ?????, ???? ???? ???? ??? ? ??? ???????? ?? ??? ?????.

??? ???? ????? ????? ?? "?????? ????? Pearson ????????" ?????? ????? PEARSON ?? CORREL ??? ?????? ????????. ?? ?? ????? Excel ??? ?????? ????? ???????? ???? ?????. ??? ????? ????? ?? ?????????? t ????- tail "?" two-tail ???????? ???????? ?? ???? ??????? ?????? TTEST Excel ?????? ?? ????? ???????? ???? ?????. ?????? ??? ???????? ???? ? ????? ????? ?? ????? 3 ?? ??????? TTEST(E3:E13, F3:F13, 1, 1) ? TTEST(E3:E13, F3:F13, 2, 1) ??? ???????. ???? ????? ?? ????? ????? ??? ??????? ?? ??? ?????? ?? "????? 1?" ??? ???? ?????? ???? ????? ???????? ???? ?????. ???? ????????? ??????? ?? 1 ????? TTEST(A3:A13, B3:B13, 1, 1) ? TTEST(A3:A13, B3:B13, 2, 1) ??? ???????.

??? ?? ???? ?????? ??? ????? ?????? cutoffs ??????. ?? ????? 1 ?2 ?3 ??????? ??????? ????? ?????? ???? ???? ? 8 ??? ???????. ???? ??? ??????? ?????? ??? ??? ?? ??? ???????? ????? ?? ???????? ?????? ?? ???? ????? ??? ?? ??? ????????. ?????? ??? ????? 3 ??? ???? ??????? ???? ?? ????? ?? ???? J3, = IF(OR(ISBLANK(E3) ? ISBLANK(F3)), 0, 1), ?? ????? ????? ??? ?????? ?? ??????? J4:J13 df ?????? ?? ???? ????? ?? ?????? J14: =SUM(J3:J13) ? 1.

??? ????? df ????? ??????? TINV ???? Excel. ????? ??????? 0.05, ????????? "????? 1?" 2 ? 3 ???? TINV(0.05, 10) ? TINV(0.05, 9) TINV(0.05, 8) ??? ???????. ??? ?????? ??? "t ???? two-tail". ?????? ??? "t ?????? ????- tail ?????" ? ??????? ????????? ????? ?? ????? ??????? ?????? ? ??? TINV(0.10, 10) ? TINV(0.10, 9) TINV(0.10, 8) ??? ???????.

??????

?? ?????? Analysis ToolPak t-Test ????? Paired ?????? ?????? ??? ?????? ???? ??? ??? ????? ?????? ?? ???? ?? ?? ???? ???????? ????????. ???? ??? ??????? ???????? ????? ???? ????? ?????? ???????? ????? Excel ????? ?? Analysis ToolPak.

???? ?????? ????? ???????? "P(T<=t)" ?????. ???? ??? ??????? interpretations ??????.

???????

???? ???????: 829252 - ????? ??? ??????: 03/????/1428 - ??????: 3.2
????? ???
  • Microsoft Office Excel 2007
  • Microsoft Office Excel 2003
  • Microsoft Excel 2004 for Mac
????? ??????: 
kbmt kbformula kbexpertisebeginner kbprb kbfunctions kbfuncstat KB829252 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????829252

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

 

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