??????? ????????? ?? Excel: TREND

?????? ????????? ?????? ?????????
???? ???????: 828801 - ??? ???????? ???? ????? ????? ??? ???????.
????? ???? | ?? ????

?? ??? ??????

??????

?????? ??? ??????? ?????? TREND ?? ??????? Excel 2003 ?????????? ?????? ?? ?????? Excel? ??? ???? ????? ??????? ?????? ?????? ??? ????? ?????? ?? ????????? ?????? ?? ?????? Excel ?????? ?????? TREND ?? ????????? ??????? ?? ?????? Microsoft Excel.

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

??????? ??????? Microsoft Excel 2004 ?????? ??????? Macintosh (???????)

?? ????? ??????? ????????? ?? ??????? Microsoft Excel 2004 ?????? ??????? Macintosh (???????) ???????? ??? ??????????? ????????? ?? ??????? Excel 2003 ?????????? ?????? ?? ?????? Excel. ????? ??? ??????? ????? ???? ??????? ??? ????? ??? ???? ?? ????? ??????? ??? ??????? Excel 2003 ?????????? ?????? ?? ?????? Excel ????? ??? ??????? Excel 2004 ?????? ??????? Macintosh (???????).

??????? ????

??? ??????? ???? TREND(known_y's, known_x's, new_x's, constant) ???? ?????? ???. ??? ??????? ??????? ???????? ?????? ??? ????? ???? TREND ????? ?? ???? ???? ??? ??? ???????. ???? ???? Known_y's ???????? ???????? ?? "??????? ??????" ????? known_x's ???????? ???????? ?? "????????? ????????". ???? ??? ??????? TREND ??????? ??????? ???? ???? ?? ???? ???? ??????? ??????? ?? ??????? ??????? ??????.

?? ???? ????? ??????? ??????? "constant" ??? ?????? TRUE? ???? ???? ???? ?? ????? ????? ???????? ??? ????? ??????? ??????? ?? ????? ????????. ?? ???? ????? ??????? ??????? ??? ?????? FALSE? ?? ??? ????? ???? ???????? ??? ???? ???????? ??????? ??? ???????? ??????. ????? ??????? ??????? ????????? ??? ???? ????? ???? ??????? ??? ?????? TRUE.

??????? ????? ?? ???? ???????? ????? ??? ?? ????? ???????? ?? ????? ??? ?? known_y's ???? ??? ????? ?????? y ?known_x's ?? ???? ?? ???? ?? ????? ?????? x. ??????? ??? ?? ???? ????? (?????) ??? ??????? ???????. ?? ??????? ?? ??? ????? New_x's ?? ????? ??? ??? ?? ???? ??? ????? new_x's ??????? ?? known_x's. ????? ?? ????????? ???????? ?? ??? ??????? ????? ??? ?? ??? ????? ???????? ?? ?????? ???? ?? ????? ?????? ??? ?????? ??????? (?????? ?????????).

???? ?????? ???? ????? ?????? (?? ???? ??????? ???? LINEST ?? Excel)? ???? ???? TREND ?????? ????? ???????? ???????? ?? new_x's.

?????? ??? ??????? ????? ???? ????? ?????? ???? TREND ????? LINEST ???????? ??? ???????? ???? ???? ?? ?????? LINEST ?? ??????? Microsoft Excel 2002 ?????????? ??????? ?? ?????? Excel. ???? ??? ???????? ??? ???? ?????? ??? ??????? ?????? TREND. ???? ????? ?? ??? ?? ??? ????? ????? ???????? ???????? ?????? ????? TREND ??????? Excel 2003 ?????????? ?????? ?? ?????? Excel? ?? ????? ??????? ????? (????????) ?? ???????? ???????? ????? LINEST.

???? ???? TREND ???????? ???? LINEST ???????? ?? ?????? ??????? ???????? ?? ????? LINEST ???? ????? ???? ??? y ???????? ???????? ??? ?? ?? ???? new_x's? ?? ???? ???? ??? y ????????. ????? ??? ?????? ??? ???????? ???? ???? ????? ????? LINEST.

????????? ??? ????? ??? ???????? ????? ???? ???????? ??? ??????? ??????? ?????? ????? LINEST. ????? ??? ??????? ??? ?????? ?? ??????? ????????? ???? ???? ?? ????????? ??? ??????? ?????? LINEST ?? ??????? Excel 2002 ?????????? ??????? ?? ?????? Excel.

?????? ??? ??????? ??????? ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft" (?? ????? ??? ??????? ??? ???????? ??? ????? ?????? ?????????? (????? ?? ??? ?????? ???)):
828533 ??? ???? LINEST ?? Excel 2003 ??? ????????? ?????? ?? ?????? Excel


????? ??? ??????? ??? ??? ???????? ??????? ???? ???? ?? ??????? Excel 2002 ?????????? ??????? ?? ?????? Excel? ?? ????? ??? ??????? ?????? ?? ??????? ??????? ??? ????? ??????? ?????? TREND. ????? ??? ??????? TREND ??? ????? ?????.

???? ??????

TREND(known_y's, known_x's, new_x's, constant)
??? ?? ???? ???????? known_y's ?known_x's ?new_x's ????? ?? ????? ?? ?????? ????? ??? ????? ??????. ??? ??? known_y's ???? ?????? ?????? ????? ??? ??? ???? known_x's ?? c ???? ????? ??? m ?? ??? ???? ???? c ???? ?? ???? ?? ?????? ??. ???? ?? c ???? ??? ??????? ?????? ????? ???? m ??? ???? ????????. ??? ?? ???? New_x's ?? c ???? ????? ??? r ?? ??? ???? ???? r ???? ?? ???? ?? ?????? ??. (??? ???????? ????????? ????????? ?? ??????? ???? ??? ???? ???????? ?? ???? ????? ?? ?????.) Constant ?? ????? ?????? ??? ??????? ??? ?????? TRUE ?? ?????? FALSE (?? ??? ?????? ? ?? ? ??? ????? Excel ????? ???????? ??? FALSE ?? TRUE? ??? ???????). ????? ???????? ??????? ??????? ?? TREND ?????? ????????? ???? ??? ??????? TREND ??????? ??? ?????? ??? ??????? ??????? ?? ??????? ??????? ?? ??????. ???????? ???? ??????? ??????? ???? ?????? ??? ???? TRUE.

????? ????????? ?????? ?????? ????? TREND ???? ?????? ?? ??????? ???? ????? ??? ????????? ??? TREND(A1:A100, B1:F100, B101:F108, TRUE). ???? ??? ????? ????? ???? ?? ????? ????? ????? ??????? ??????? ???????? ?? ??? ?????? ??? ????? ??????. ?? ??? ??????? ???? ???? ?????? ????? ????? ???? (known_y) ??? ????? ???????? ??? ??? ??? ??????? ????? (known_x's) ??? ?????. ???? ???? ??????? ???????? ?????? ??? ????? ??????? ???? TREND ????? ??? y ????????.

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

?? ????? ???? ??? ???? ??? Excel ?????? ????????? ????????? ????????:
  • ????? ????? ???? TREND ?? ???? LINEST
  • ???????? ???? ???? ????? ????? ???? known_x's ???? ?????? ????? ???? ??????? ??????? TREND (?? ?????? LINEST) ?? ??????? Excel 2002 ?????????? ??????? ?? ?????? Excel
???? ?????? ?????? ??????? ?? ???? ???? LINEST ???? ?????? ?? ????? LINEST.

?????? ??????? ?????? ????????? ?????? TREND? ?? ?????? ???? ??? Excel ?????? ?? ???? ?????? ??????? ?? ??? ?????? A1 ?? ???? ??? Excel ??????? ?????? ??? ?? ?? ???? ????????? ??? ???? ?????? ?????? ??????? ?? A1 ??? K35 ?? ???? ????? ?????? ??.
?? ??? ??????????? ??? ??????
y:x's:
????
????
????
????
????
new x's:???
????
????? ???? TREND ??? ????? B ?C:????? ???????? ??? Excel 2003:????? ???? ???? ?? Excel 2003 ?????????? ?????? ?? Excel:
=TREND(A2:A6,B2:C6,B7:C8,TRUE)#NUM!6.15789473684211
=TREND(A2:A6,B2:C6,B7:C8,TRUE)#NUM!8.13157894736842
????? ???? TREND ??? ???? B ???
=TREND(A2:A6,B2:B6,B7:B8,TRUE)6.15789473684216.15789473684211
=TREND(A2:A6,B2:B6,B7:B8,TRUE)8.131578947368428.13157894736842
????? ???????? ?????? ?????? LINEST ?? Excel 2003 ?????????? ?????? ?? Excel
??????? ??? ????? B ?C??????? ??? ???? B
= K24*1 + J24*B7 + I24*C7=J31*1+I31*B7
=K24*1 + J24*B8 + I24*C8=J31*1 +I31*B8
????? LINEST ??? ????? B ?C:????? ???????? ??? Excel 2003:????? ???? ???? ?? Excel 2003 ?????????? ?????? ?? Excel:
=LINEST(A2:A6,B2:C6,TRUE,TRUE)=LINEST(A2:A6,B2:C6,TRUE,TRUE)=LINEST(A2:A6,B2:C6,TRUE,TRUE)#NUM!#NUM!#NUM!00.6578947368421050.236842105263158
=LINEST(A2:A6,B2:C6,TRUE,TRUE)=LINEST(A2:A6,B2:C6,TRUE,TRUE)=LINEST(A2:A6,B2:C6,TRUE,TRUE)#NUM!#NUM!#NUM!00.0438596491228070.206652964726136
=LINEST(A2:A6,B2:C6,TRUE,TRUE)=LINEST(A2:A6,B2:C6,TRUE,TRUE)=LINEST(A2:A6,B2:C6,TRUE,TRUE)#NUM!#NUM!#NUM!0.9868421052631580.209426954145848#N/A
=LINEST(A2:A6,B2:C6,TRUE,TRUE)=LINEST(A2:A6,B2:C6,TRUE,TRUE)=LINEST(A2:A6,B2:C6,TRUE,TRUE)#NUM!#NUM!#NUM!2253#N/A
=LINEST(A2:A6,B2:C6,TRUE,TRUE)=LINEST(A2:A6,B2:C6,TRUE,TRUE)=LINEST(A2:A6,B2:C6,TRUE,TRUE)#NUM!#NUM!#NUM!9.868421052631580.131578947368421#N/A
????? LINEST ??? ???? B ???
=LINEST(A2:A6,B2:B6,TRUE,TRUE)=LINEST(A2:A6,B2:B6,TRUE,TRUE)0.6578947368421050.2368421052631590.6578947368421050.236842105263158
=LINEST(A2:A6,B2:B6,TRUE,TRUE)=LINEST(A2:A6,B2:B6,TRUE,TRUE)0.04385964912280710.2066529647261360.0438596491228070.206652964726136
=LINEST(A2:A6,B2:B6,TRUE,TRUE)=LINEST(A2:A6,B2:B6,TRUE,TRUE)0.9868421052631580.2094269541458480.9868421052631580.209426954145848
=LINEST(A2:A6,B2:B6,TRUE,TRUE)=LINEST(A2:A6,B2:B6,TRUE,TRUE)224.99999999999932253
=LINEST(A2:A6,B2:B6,TRUE,TRUE)=LINEST(A2:A6,B2:B6,TRUE,TRUE)9.868421052631580.1315789473684219.868421052631580.131578947368421
??? ??? ??? ?????? ?? ???? ??? Excel ???????? ???? ??? ?????? ?????? ?? ???? ??? ????? ????? ??????. ?? ??????? ????? ?????? ???? ?? ????? ?????? ??? ????????? ????????? ????? ?????? Excel ???? ???? ???????:
  • ?? ??????? Microsoft Office Excel 2007? ???? ??? ????? ??????? ?????? ????????? ?? ???? ??? ????? ?? ???????? ?????? ?? ???? ??? ?????? ?????? ???? ??????.
  • ?? ??????? Excel 2003? ??? ??? ???? ?? ??????? ?????? ?? ???? ??? ?????? ?????? ???????.
???? ???????? ?????? ????? TREND ?? ??????? ?? A1 ??? C8. (?? ??? ????????? ???????? ?? ???? ??????? ?? D2 ??? D6 ????? ?? ????????? ???? ??? ????????? ??????? ???? ??? ?? ??? ???????.) ??? ??? ????? ?????? TREND ???????? ??????? ????????? ??????? ?????????? ?????? ?? ?????? Excel ?? ??????? ?? E10 ??? E16 ???????? ?? I10 ??? I16 ??? ???????. ?????? ????? ??????? ?? A10 ??? A16 ?? ????? Excel ????????. ?????? ???? ??? ??????? ??? ????? ??????? Excel 2003 ?????????? ?????? ?? ?????? Excel ??? ???? ????? ??????? ?????? TREND ?????? LINEST ?????? ????????? ?????? LINEST.

??? ??? ????? ????? TREND ?LINEST ??? ???:
  1. ??? ??????? ???? TREND(known_y's, known_x's, new_x's, constant).
  2. ???? ???? TREND ???????? ???? LINEST(known_y's, known_x's, constant, TRUE).
  3. ??? ?????? ??? ??????? ???????? ???? ???? ?? ??????? ???? LINEST? ????? ??? ????????? ?? ???? ????? ?? ???? ????? ?????? LINEST.
  4. ???????? ??? ?? ?? ???? new_x's? ??? ???? ???? y ???????? ???????? ??? ??????? LINEST ???? new_x's ???????? ?? ??? ????.
  5. ???? ?????? ???????? ?? ?????? ? ?? ?????? ???????? ?????? ???? TREND ??????? ??? new_x's.
??? ?? ???? LINEST ????? ?????? ?? ?????? ? ??? ????? ???? TREND ?????? ????? ??????. ????? ???????? ?? ????? ?????? ???? ?????? ????? ???? ???????.

????? ????? ?????? (known_x's) ????? ?????? ????? ???? ??????? ???? ????? ???? ???? ??????? ??????? ?? ???? ???? ??? ????? ??? ???? c ?????? ??????? ??? ??????? ?????? ??? ????? c1 ?c2. ????? ?????? c ?????? ?????? ???? ????? ??? ??????? ???? ?????? ????? ?? ???? ????? c1 ?c2 ?????? ????. ??????? ??????? ????? ????? ???? ??????? ?? ??? ???? ??????? ?????? ?? ????? ???? ???? ?? ???????? ???????. ?????? ??? ?????? LINEST ?? ??????? Excel 2002 ?????????? ??????? ?? ?????? Excel ?? ???? ?? ????? ???? ???????? ??? ?????? ??? ?????? ??????. ????? ????? ?????? ????? ?????? ????? ???? ??????? ???? ????? ???? ??????? ?? ???? ???? ??? ????? ??? ???? c ???? ????? ??????? ????? ??????? ??? ??????? ?????? ??? ????? c1 ?c2 ???????? ??????. ?? ??? ??????? ??? ????? "????? ???????" ???? ?? ???? ????? ???? ???? ?? ?????????? ????????? ????????? ?? ?????? c ????? ???? ?? ????????? ???????? ?? ??????? ?????? ?????? c? ?c? ???????? ??????? ??? ????? "???? ????" ????? ??? ?? ???? ??? ?? ??^ (-??) ??? ???? ??????.

????? ??????? ?????? ??????? ?? ???? ?? ??? ??? ??? ????? B ?C ?????? ???? ????? ?? Excel ????? ????? ?????? constant (????? ??????? ??????? ??? ?????? TRUE). ??? ???? ???? Excel ???? ???? ????? ???? ??????? ?? D2 ??? D6 ??????. ?? ????? ?????? ?? ??????? ???? C ?? ?????? ?? ? ??? ? ????? ?????? ????? ????????? ???????? ?? ????? B ?D. ????? ?? ???? ????? ???? ??????? ????? ??? ?????? C ?? ????? ???????:
  • ?????? B
  • ?? ??? ?????? ??????? 1s ??????? Excel ???? ?? ?????? ????? ???? ??????? ??????? ?????? LINEST (????? ??? ??????? ??????? ?????? TREND) ?? ?? ?????? ??? ?????? TRUE (??? ?????? "???????").
????? ??? ??? ???? ?????? ????? ??? ?? ????? ??????? Excel 2002 ?????????? ??????? ?? ?????? Excel ?? ???? ??????? ???? ????? ???? ????? TREND ??????? #NUM!.

?????? ??????? ??????? ??????? ?? ?????? ?? ?? ??? ??? ??? ??????? ???? ???? ??? ????? ?? ??????? Excel ??????? ???? ?????. ?? ???? ????? ???? ???????? ?????? ????? ?? ?????? Excel ????? ????? ?????? constant. ?? ????? ??? ??????? ??? ??????.

?????? ?? ???? ?????? ?????? ??????? ???????: ?? ???? ????? ???? ???????. ??? ?????? ??? ??????? ???? ??? ?? ???? ??????? Excel. ??? ??? ???? ????? ???? ?? ?????? Excel? ?? ??????? ??? ???? ??? ???????? ??????? ?? ???? ????? ?? ???? ??????? ??????? ???????.

??????? ?? ??????? ??? ?????? ???????? ??? ???? ??????? Excel 2003 ?????????? ?????? ?? ?????? Excel ?? ?????????. ???? ???? ????? ????????? ???????? ??? ????? ??????? ?????? ????????? ?????? ?????? ???? ???? ????? ??????? ??????? ?????? ?? ??????? ??????? ?????? ??? "?????? C ?? ???? ??? ?????? ?????? ?????? ???? ?????? ?? ???????."

?? ??????? Excel 2003 ?????????? ?????? ?? ?????? Excel? ?? ??? ??? ??? ??????? ?? ????? ?? ????? ????? ??? ??? ????? ?? ???? ????? LINEST. ??? ????? TREND ???? ???? ??? ??? ???????. ?? ???? ????? ?????? LINEST? ?????? ????? ???????? ???? ????? ??? ?????? ??????? ????? ?? ???? ????? ??? ?? ????? ???? ??? ?????? ?? ???????. ???? ????? ????? ?????? LINEST ?? ?????? ?? ?? ??? ?? ????????? ?? ????? ?????? TREND ?? ?????? ?? ?? ??? ??. ???? ????????? ?? ???????? I24 ?I25 ???? ???? ???? ?????. ?? ??? ??????? ????? ???? LINEST ????? ?????? C (?????? ????????? ???????? ?? ??????? I24 ?J24 ?K24 ?? ???????? C ?B ??????? ?????? ?? Excel? ??? ???????). ??? ???? ????? ???? ???????? ???? ????? ?? ???? ?? ??????? ???????? ????? ???????? ????????.

?? ??????? ?????? ?? ?????? ?? ?? ??? ??? ?? ???? ????? ???? ??????? ??? ??? ????? ?? ?????. ????? ?? ??? ?? ??? y ???????? ?? ??? ????? ?? ??? ?????????. ???? ??? ??????? ????? ??? ????? ???? ???? ???? ????? ??????? ??????? ?????? ?? ???? ??? ????? ?????? ??????? ??????. ??? ????? ??? ??? ??????? ?????? ????? ?? ???? ??? ??? ????? ??? ?????? ????? ?? ???? ??? ??????? ???? ??????.

????? ??? ??? ????? LINEST ??????? ?? ??????? ?? I23 ??? K35? ???? ?? ??????? Excel 2003 ?????????? ?????? ?? ?????? Excel? ?????? ?? ??????? ???? ??????? ?? ????? ??????? ??????? ??? ????????? ?? ??????? ?? I31 ??? J32 ??? ??????? ?? J24 ??? K25 ???????. ????? ??? ??? ??? ?????? ??? ??? ??????? ??? ????? ?????? C ?? ???????? ???? ????? (??????? ?? ??????? ?? I24 ??? K28) ??? ????? ?????? C ??? ????? ???? LINEST (??????? ?? ??????? ?? I31 ??? J35). ???? ??? ??????? ??????? ?? ???? ????? ???? ???????.

?? ??????? ?? A18 ??? C21? ?????? ??? ??????? ?????? ??????? Excel 2003 ?????????? ?????? ?? ?????? Excel ?????? ????? ???? ?????? TREND ??? ???? ?????? LINEST ????? ??? y ???????? ????????. ?? ???? ??? ????????? ?? ??????? ?? A20 ??? A21 ??? ??????? ?? C20 ??? C21? ????? ?????? ??? ????? ??? ??????? ???? LINEST ?? ?????? new_x's ?? ??????? ?? B7 ??? C8 ??? ?? ????????? (???????? ???????? B ?C ?????? ???? ?? ???????? ?????? B ??? ????? ????).

??? ????? ??????? ?????? ????????? ?????? LINEST ?? ??????? Excel 2003 ??? ????????? ?????? ?? ?????? Excel ???? ???? ????? ????? ?????? ??? ???????? ????????. ????? ??? ??? ??????? ??? "????? QR". ?????? ????? ?????? LINEST ????? ?????? ???????? ????? QR ?? ???? ????.

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

????? ????? ?????? TREND ????? ????? ?? ??????? Excel 2002 ?????????? ??????? ?? ?????? Excel ???????? ??? ??????? ?? ?????? LINEST.

?? ???? ???? LINEST ???????? ??? ???????? ???? ?????? ?????? ??????? ?????? ?????????. ????? ???? ????? ???? ??????? ?? ???? ????? ????? ?????? ?????? ??? ?????? ????????? ???????? ?????? ???? ??? ??????. ?? ??? ??????? ??? ?????? ??????? ??? ???? ????? ?? ??????? ??? ???? ???? LINEST ???? ?????? ???? ??????? ??????? #NUM!.

???? ???? ?? ???? ??????? ???????? ??? ??? ??????? ?? ??? ???? ????? ???? ?????? ????? ???? ??????? (?? ??????? ???????)? ???? ???? LINEST ????? ??????. ????? ?? ???? ??????? ???? TREND? ????? ????????? ?? ???? ?????? ?? ??? ???? ????? ???? ?????? ????? ???? ??????? (?? ??????? ???????).

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

????? ????????? ???? ?? ??????? ??? ???? LINEST ??????? ??? ????? ????? QR ?????? ???????? ????????. ?????? ???????? ????????? ?? ????? QR:
  • ??????? ???? ???? (???? ???? ???? ??? ??? ?? ????? ???????)
  • ????? ?????? ??????? ?????? ?????????
???? ???????? ???????? ???????? Excel 2002 ?????????? ??????? ?? ?????? Excel ???????? ?? ??? ??????? ?? ??????? ?? ??????? Excel 2003 ?????????? ?????? ?? ?????? Excel.

???????

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

?? ???? ?????? ???????? ?? ??? ??????? ??? ????? LINEST? ???? ????? ??????? ???????? ??????? Excel 2002 ?????????? ??????? ?? ?????? Excel. ???? ????? ?? ???? ???? ?? ????? ??????? ?????? ????????? ???? ?? ???? ????? ?? ???????. ??? ???? ????????? ??????? ?? Excel ????? ?????? ????? TREND ??? ??? ???? ????? ???? ???????.

???? ????? ???? ????? ????????? ???? ?? ??????? ??? ?????? LINEST ????? ??????? ??? ???? ???????? ????? ?? Analysis ToolPak (???? ????? ???????) (???? ?????? ?????? LINEST) ???? ????? Excel ???????? ??????????: LOGEST ?GROWTH.

???????

???? ???????: 828801 - ????? ??? ??????: 01/???? ?????/1428 - ??????: 4.0
????? ???
  • Microsoft Office Excel 2007
  • Microsoft Office Excel 2003
  • Microsoft Excel 2004 for Mac
????? ??????: 
kbformula kbexpertisebeginner kbinfo KB828801

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

 

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