???? ???????: 214269 - ??? ???????? ???? ????? ????? ??? ???????.
????? ???? | ?? ????

?? ??? ??????

??????

???? ??? ??????? ???? ????? ????? ????? ???? ?????? ????? ?? ?????? ????? ?? ????????. ????? "???? ????? ???????" Analysis ToolPak ??????? ?? ?????? Microsoft Excel ??? ???? "?????? ????????" Histogram.

?????? ?? ????? ???? ????? ??????? Analysis ToolPak

??? ??????? ???? "?????? ????????"? ??? ?????? ?? ????? ??????? ???????? "???? ????? ???????" Analysis ToolPak. ?????? ?? ??? ???? "???? ????? ???????" ????? ?? ??? ???? ??????? ???????:
  1. ?? ?????? Microsoft Office Excel 2003 ?????????? ??????? ?? Excel? ???? ??? ??????? ???????? ?? ??????? ?????.

    ?? ?????? Microsoft Office Excel 2007? ???? ??????? ???????:
    1. ???? ??? ?? Microsoft Office? ?? ???? ??? ?????? Excel.
    2. ???? ??? ????? ??????? ????????.
    3. ?? ??????? ?????? ??? ????? Excel ????????? ?? ???? ??? ??????.
  2. ?? ???? ?????? ??????? ????????? ???? ?? ????? ???? ???????? Analysis ToolPak (???? ????? ???????) ???????? ??? ??????? ???????? ????????. ???? ??? ?????.
??????: ??? ??? ??? Analysis ToolPak (???? ????? ???????) ?? ???? ?????? ??????? ????????? ??? ?? ???? ????? ??? ???? ????????? ????? ??. ?? ???? ??? ???? Analysis ToolPak (???? ????? ???????) ?? ???? ?????? ??????? ????????? ?? ?????? "????? Microsoft Excel" ??? ?????? ??? ?????? ??? ????? ??????? ???????.

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

  1. ???? ?? ??? ?? ???? ??? ?????:
        A1:  87      B1: 20
        A2:  27      B2: 40
        A3:  45      B3: 60
        A4:  62      B4: 80
        A5:   3      B5:
        A6:  52      B6:
        A7:  20      B7:
        A8:  43      B8:
        A9:  74      B9:
       A10:  61     B10:
    					
  2. ?? ?????? Excel 2003 ?????????? ??????? ?? Excel? ???? ??? Data Analysis (????? ????????) ?? ??????? ?????.

    ?? ?????? Excel 2007? ???? ??? Data Analysis (????? ????????) ?? ???????? Analysis (?????) ?? ????? ??????? ??????.
  3. ?? ???? ?????? Data Analysis (????? ????????)? ???? ??? Histogram (???? ??????)? ?? ???? ??? ?????.
  4. ?? ?????? Input Range (???? ???????)? ???? A1:A10.
  5. ?? ?????? Bin Range (???? ??????)? ???? B1:B4.
  6. ??? Output Options (?????? ???????)? ???? ??? New Workbook (???? ????)? ???? ???? ???????? Chart Output (????? ??????)? ?? ???? ??? ?????.
??? ????? ???? ???? ????? ??? ???? "???? ??????" ???? ????? ???? ????.

????? ??? ????? ???????? ?? ?????? 1? ???? ???? "?????? ????????" ????? ????? ?????? ??????:
   A1: Bin     B1: Frequency
   A2:  20     B2:        2
   A3:  40     B3:        1
   A4:  60     B4:        3
   A5:  80     B5:        3
   A6: More    B6:        1
				
?????? ?????? ????? ?? ????? ?? ???? ????? ???? ???????? ???????? ?? ???? "?????? ????????" ???.

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

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

??????: ?? ????? ?? ????? ???? "?????? ????????" ?? ???? ????? ???????? (???? ??????? ?? ???? ???? ??? ?????) ?????? ?????? ?????? ???? "?????? ????????" ?? ??? ?????? ????????? ?????? ??.

????? ?? ?????????? ???? ??? ??? ??????? ?????? ?????? ?? "????? ????? Microsoft" (?? ????? ??? ??????? ??? ???????? ??? ????? ?????? ?????????? (????? ?? ??? ?????? ???)):
214029 ??????? ???? ????? ???????? ??????? ??????? ?? ?????? ?????? ??? ?? ???? ????? ????? ??? ???????? ?? Excel

???????

???? ???????: 214269 - ????? ??? ??????: 12/???? ?????/1429 - ??????: 5.1
????? ???
  • Microsoft Office Excel 2007
  • Microsoft Office Excel 2003
  • Microsoft Excel 2002 Standard Edition
  • Microsoft Excel 97 Standard Edition
  • Microsoft Excel 2000 Standard Edition
????? ??????: 
kbfunctions kbfuncstat kbaddin kbhowtomaster KB214269

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

 

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