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

?????? ????????? ?????? ?????????
???? ???????: 828236 - ??? ???????? ???? ????? ????? ??? ???????.
????? ???? | ?? ????

?? ??? ??????

??????

???? ??? ??????? ?????? ?? Microsoft Excel. ?????? ??? ??????? ????? ??????? ??????. ????? ??? ?????? ???? ????? ?? ??????? ?? Microsoft Office Excel 2003 ?????????? ??????? ?? Excel ?? ????? ?????? ?? ????????? ??????? ?? Excel.

??????? ????

???? ?????? FORECAST (x known_y 's? ? known_x's) ?????? ???????? ??????? ?????? (????? ?? ???????? ?? ??? known_y 's) ????? ?????? x? ???? ??????? ??????? (????? ?? ???????? ?? ??? ?? known_x's) ???????? ???? ?????? ???????? ????? (????????) ?????? ?????? y ?? ??? ?.

??? ???? ?????? ?? ???? ????? ???????? ??? ?? ???? ????? ?? x ????? ???? ??? ???? ??? ?????? ???? ?????? ?? ??? ? ???? ??? ?????? ??? ?????? ???????? ?????? ?????? ?? ???????? ?????? ???? ????? ????? x ??? ?????? ??????. ??? ????? ???? y ???? ???? ?????? ???????? ??? ?? ???? x ??? ???????? (????? ?????? ?????? ?? ? ??????? ???? ?????? ???? ???????? Excel ????? ??????? ???????).

???? ??????

FORECAST(x, known_y's,known_x's)
??????? x ??? ????? ??? ???? ?????? ??? ?? ???? known_y's ? known_x's ????? ?? ????? ?? ?????? ??????? ???? ????? ??? ??? ????? ?? ??? ???????? ???????.

?????? ?????? ??????? ?????? ????? ???? ? ????? ???????? ??? 2 ?????? ?? ??????? ???? ????? ??? ????????? ??? ?????? (125? a1: a100, b1: b100).

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

?????? ?????? FORECAST? ???? ??????? ???????:
  1. ????? ???? ??? Excel ?????? ?? ?? ???? ?? ??? ????.
    ?? ??? ??????????? ??? ??????
    ??? ???? ?
    1= 3 + 10 ^ $D$ 3???? 10 ??? ????? ??? ????????
    2= 4 + 10 ^ $D$ 30
    3= 2 + 10 ^ $D$ 3X ???????
    4= 5 + 10 ^ $D$ 36
    5= 4 + 10 ^ $D$ 3X ???????? + ??? 10
    6= 7 + 10 ^ $D$ 3= D5 + 10 ^ $D$ 3
    =SLOPE(A2:A7,B2:B7)Excel 2002 ?????????? ???????
    =INTERCEPT(A2:A7,B2:B7)??? D3 = 7.5
    =FORECAST(D7,A2:A7,B2:B7)4.875
    = A10 + A9 * D7??? D3 = 8
    #DIV/0!
  2. ??? ?????? A1 ?? ???? ??? Excel ?????? ??? ?? ??? ??????? ??? ???? ?????? ??????? A1:D13 ?? ????? ?? ???? ??? Excel.
  3. ???? ??? ?????? ????? ????? ??? ?? ???? ??? ?????? ????? ??????. ?? ??????? ????? ?????? ???? ?? ????? ?????? ??? ????????? ???????? ??? ?????? ?? ????? Excel ???? ???? ???????:
    • ?? Microsoft Office Excel 2007? ???? ??? ?????? ???????? ? ???? ??? ????? ?? ??????? ????? ??? ?? ???? ??? ??? ?????? ????? ???.
    • ?? Excel 2003 ??? ????????? ??????? ?? Excel? ??? ??????? ??? ????? ???????? ??? ?? ???? ????????? ?????? ???????.
?????? ?? ???? ?? ????? ??????? b2: b7 ???? ???? 0 ???????? ? A9:D13 ??????? ???? ?? ??????? ??????? 6.

A2: a7 ??????? ?????? b2: b7 ??? ?? ?? ??? y ? x-????? ???? ??? ????????? ???????? ?????? ?? ?????? A10. ???? ? ?? ?????? D7.

??? ??? ???? ????? ?? Excel ???? ?? Excel 2003? ?? ???? ?????? ?? ????? ??????? ?? ????????? ???????. ?? ????? ??? ?????? ??????? ??????? Excel 2003 ?????????? ??????? ?? Excel. ??????? ???? ??? ?????? ????? ????? ??? ??????? (?? known_y 's? ? known_x's) ??? ????? ????????? ???????:
INTERCEPT(known_y's,known_x's) + SLOPE(known_y's,known_x's) * x.
????? ?? ??? ????? ????????? ???????? ?????? ?????? ????? Excel 2003 ?????????? ??????? ?? Excel? ???? ?????? ????? ???????? ?????? ????? ????. ????????? ???????? ??????? ???? ?? ??? ?????? ?????? ???? ????? ????? ??? ?????? ????? ????.

?? ??????? Excel ???? ?? ???? ?? Excel 2003? ?????? ?? ???? ????? ???????. ??? ??? ?????? ???? ????? ??? ?? ?? ????????? ?? b2: b7? ?????? ?? ??? ???? ??? x ?? ??? ?????? ???? ??? ?? ?? ???? ??? ???? ??????. If ??? ???? ????? x, y ????? ?? x ??? ?????? ?????? ??? y ??? ?????? ???????? ???????? ????? ?????? ??? ?????? ??? ??? ?????? ???? ???? ??? ???? x. ??? ??? x ?? ????? ??? ?????? ???? ???????? ??? ?? ???? ???? ?????? ??? ?? ?????. ?? ???????? ?????? ???? ?? ???? ????? ??? ?????. ??? ???? ????? ????? ???????? ??????? ???????.

?? ?????? ?????????? 0 ?? D3? ????? ?? A9 0.775280899. ????? ??????? A10:A11 ??? ??????? ???????. ?????? A12 ????? ??? ??????? ?????? ???? ??? ?????? ??? ???? ??????:
INTERCEPT(known_y's,known_x's) + SLOPE(known_y's,known_x's) * x
????? ????? ?? ??????? A11 ? A12 ?????? ??? ?????? ?? A12 ?????? ?? ???? ??????. ??? ?? ?? ????? ????? ???? ???? ?????? ????? ????? ?????? ??? ? known_x's.

??? ??? ?????? ?????? ?? D3? ??? ????? ???? ???? ??? b2: b7? ???? ???? ??? ????? ??? ??????? ?????? ??????. ??? D3<= 7,="" there="" are="" no="" round-off="" errors="" that="" appear="" in="" the="" first="" six="" decimal="" places="" of="" slope.="" as="" a="" result,="" intercept="" and="" forecast="" are="" well-behaved.="" now="" change="" the="" value="" in="" d3="" to="" 7.25,="" 7.5,="" 7.75,="" and="" 8.="" you="" will="" notice="" that="" slope="" in="" a9="" changes.="" this="" causes="" variations="" in="" the="" values="" in="" cells="" a11:a12.="" these="" values="" should="" remain="" constant="" throughout="" the=""></=>

????? D7:D13 ??????? ???? ????? ?? ??????? ?????? ?????? ?????? ???? ?? ??????? ??? ?? ??????? ????? (????????) ?? ?????. ??? ??? ??? ??????? ?? ????? ??????? ???? D3 = 7.5 ? 8? ??? ???????.

???? ?? ??????? ????? ????? ??? ??? ???? ???? ???? ?????? 0 ??? D3 = 8.

??? ??? ???? ????????? ?? Excel ???? ?????? ??? ????? ?? ??? ??????? ??? ????????? ?? ????? ??????? ?? ???? ????? ?????? ?????? ???????? ????????? ?? ??? ??? ?????????. ??? ???? ???? ?? ???? ??????? ????????? ?? ??? ??????? ??? ???? ?????.

??? ??? ???? Excel 2003 ?? ????? ???? ?? Excel? ?? ???? ??? ??????? ?? ????? ???????? ?? A11 ? A12 ??? ????? ???????. ??? ???? ??????? ????? D7:D13 ????? ??????? ???? ?? ???? ?? ????????? ??????? ?? Excel.

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

???? ??? ??????? ????? ?????? ??? ?????? ???????? ????????? ?? ??????? Excel ???????. ????? ???? ???? ??? ?? ???? ????????. ??? ???? ???? ????? ?? ??? ????????? ??????? ?? Excel ???? ???? ?????? ???? ???? ????? ???????-????? ??????? ?? ??????? ??????.

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

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

???????

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

??? ???? ?? ??? ??????? ?????? ??? ??? ??????? ?? ????????? ??????? ?? Excel ???????? ?? ??? ???? ??????? Excel ?? ??????? ?????? ??? ??????. ???? ??? ???? ???????? ????????? ?? ??? ??????? ?? ???? ????? ???? ????????? ?? ??? ??????? ????. ??????? ??????? ?????? ???????? ?? ???? ?? ????????? ??????? ?? Excel ????? ????? ???????? ??? ??? ???? ?? ??????? ???????? ???? ??? ??? ?? ????? ????? ????? ??? ??? ????????.

??????? ?? ????? ?????? ??? ????? ?????????? ????????? ??? ????? ???? ?? Excel 2003 ?????????? ??????? ?? Excel. ??????? ??????? ?????? ????????? ???????:
  • ???? ?? ????? ??????
  • ???? ?? ???? ????????
  • ??? ?????????? ?????????
??? ??????? ???? ??? ?? ????? ????. ??? ????? ???? ????? "??????? ??????" ???? ????? ????????? ?? ??????? ??? ??? ???? ?? ???? ????????. ????? ???? ?????? ????????? ???????:
  • ????? ?? ????? ?????? ???? ?????????? ?????? ????? ?????? ???? ?????????
  • ???? ????? ?????? ?? ???? ????????? ???? ((??????? ???? ?????????) ^ 2)/??? ??????)
???? ?????? ?? ??????? ?????? ???? ?? ????? ? Excel 2003 ?????????? ??????? ?? Excel ???? ??? ??????? ??? ??????? ???? ???? ?????? ?????? ??????? ?????. ??????? ????? ???? ?? ????? ?????? ??? ??????? ????? ????? ??????? ????? ???????? ??? ??? ??????? ??? ??????? ??????.

??????? ??????? ????? ??????? ???? ?? ????? ?? Excel 2003 ?????????? ??????? ?? Excel ???? ???????:
  • VAR
  • VARP
  • STDEV
  • STDEVP
  • DVAR
  • DVARP
  • DSTDEV
  • DSTDEVP
  • ??????
  • ???
  • ???????
  • ????? PEARSON
  • RSQ
  • STEYX
?? ????? ??????? ?????? ?? ?? ?? ????? ????? ????? ????? ?? Analysis ToolPak.

???????

???? ???????: 828236 - ????? ??? ??????: 28/???/1434 - ??????: 3.0
????? ???
  • Microsoft Office Excel 2007
????? ??????: 
kbexpertisebeginner kbfuncstat kbfunctions kbinfo kbmt KB828236 KbMtar
????? ????
???: ??? ????? ??? ??????? ???????? ????? ?????????? ??????? ?????? ??? ??????? ?? ??? ??????? ?? ??????? ??? ??? ?? ???? ????????? ???? ??????? ???????(CTF) ?? ?? ???? ????? ????. ???? ?? ???? ?????????? ??? ???????? ???????? ???? ??? ?? ???????? ??????? ?? ??? ??????? ???????? ?? ??? ??????? ??????? ??? ?????? ?? ?????? ??? ???? ???????? ???????? ?? ????? ??????? ????? ????? ??????. ??? ?? ???????? ???????? ?? ????? ??? ????? ?? ???????? ?? ???? ????? ?? ?????. ?????? ??? ???? ?????????? ???? ?????? ?? ??? ????? ?? ??? ??? ?? ??????? ?? ??? ????? ?? ???? ????? ????? ?? ????? ??????? ???? ?? ???????? ?? ??? ???????.
???? ??? ????? ??????? ?????? ??????????828236

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

 

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