HOW TO: ?????? STDEV ?? STDEVP ?? PivotTable ?? Excel 2000

?????? ????????? ?????? ?????????
???? ???????: 213914 - ??? ???????? ???? ????? ????? ??? ???????.
????? ???? | ?? ????

?? ??? ??????

??????

???? ??? ??????? ???? ????? ??? ????? ??????? ?????? STDEV ? ?????? STDEVP ?? PivotTable ?? Excel 2000.

PivotTable STDEV ? STDEVP ??????? ?? Microsoft Excel ???? ???????? ???????? ???????? ??? ?????? ?? ????????. ????? ??????? STDEV ??? ???????? ???????? ???????? ??? ???? ?? ???????? ????????. ????? ??????? STDEVP ??? ???????? ???????? ???????? ??? ??????? ?????? ?????? ??????? ????????.

????? ??????? ???????? ???????? ???? dispersal ????? ?? ??????? (?????). ????? ???????? ???????? ????? ???? ????? ????? ???????? ??? ???? ????? ???????? ?? ????? forecasting ?? ???????.

???? ??? ??????? ??? ???? ??? ????? ??????? ?????? STDEVP ?? PivotTable. ???????? ????? ?????? ?????? ???????? ?????? ??? ????? ????? ???? ???? ?? ???? ?????. ????? ???????? ??? ????? ????? ?? ??? ????? sake ?? ???? ???????? ?????? ????. ????? PivotTable ??????? ???????? ?? ?? ??? ??? ???????? ??? ???? ???????? ???????. ???? ????? ?? STDEVP ??? ??????? ???????? ????? ???? ???? ??? ???? ??????? ????? ?????? ??????? ????????? ??? ??? ??? ????? ???????.

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

???????? ???? ???? ????? STDEVP ????? ???????? ???????? ??????? ?????? ???? ??????? ???????:
  1. ?? ???? ??? Microsoft Excel ?????? ???? ????? ???????:
        A1: Year   B1: Quarter  C1: Month   D1: Net Revenue
        A2: 98     B2: 1        C2: Jan     D2: $514,731
        A3: 98     B3: 1        C3: Feb     D3: $514,850
        A4: 98     B4: 1        C4: Mar     D4: $515,816
        A5: 98     B5: 2        C5: Apr     D5: $516,057
        A6: 98     B6: 2        C6: May     D6: $516,920
        A7: 98     B7: 2        C7: Jun     D7: $517,082
        A8: 99     B8: 1        C8: Jan     D8: $520,945
        A9: 99     B9: 1        C9: Feb     D9: $521,751
       A10: 99    B10: 1       C10: Mar    D10: $522,098
       A11: 99    B11: 2       C11: Apr    D11: $522,921
       A12: 99    B12: 2       C12: May    D12: $523,324
       A13: 99    B13: 2       C13: Jun    D13: $523,594
       A14: 00    B14: 1       C14: Jan    D14: $527,254
       A15: 00    B15: 1       C15: Feb    D15: $527,431
       A16: 00    B16: 1       C16: Mar    D16: $528,162
       A17: 00    B17: 2       C17: Apr    D17: $528,851
       A18: 00    B18: 2       C18: May    D18: $528,996
       A19: 00    B19: 2       C19: Jun    D19: $529,536
    					
  2. ??? ?? ???? ?? ??????.
  3. ?? ??????? ?????? ? ???? ??? ????? PivotTable ? PivotChart.
  4. ?? ?????? 1 ?? ??????? ???? ????????? ?????????? ?? ???? ??? ??????.
  5. ?? ?????? 2 ?? ??????? ???? ?? ?? ???? $ A $ 1: $ D $ 19 ? ?? ???? ??? ??????.
  6. ?? ?????? 3 ?? ???????? ???? ??? ?????.
  7. ???? ??? "?????" (??) ??? ???? PivotTable ??????? ROW.
  8. ???? ??? YEAR ??? ?????? PivotTable ??????? COLUMN.
  9. ???? ??? ????? NET ??? ?????? PivotTable ????? ??????.
  10. ??? ????? ???? ??? ????? NET ??? ?????? PivotTable ????? ??????.

    SUM ??????? NET ????? ??????? ????? SUM ??????? NET REVENUE2 ???? ?? ???? ????????.
  11. ???? ????? ??????? ??? ???? ????? SUM ??????? NET ??????.

    ??? ???? ?????? ??? PivotTable.
  12. ?? ?????? ????? ? ???? ??? ??? "???????? FROM ???????".
  13. ?? ??????? ??????? ??? ? ???? ??? ???????? ???????? ???????. ???? ??? ??????.
  14. ?? ??????? ????? ???????? ?? ? ???? ??? % "????? ??".
  15. ?? ?????? ??? ??????? ? ???? ??? ?????? ?? ???? ??? (previous) ?? ?????? ???? ???????.
  16. ???? ??? ??? ? ???? 0 ?? ?????? ??????? ??????? ?? ???? ??? ????? ?????.
  17. ???? ????? ??????? ??? ???? ????? SUM ??????? REVENUE2 NET.

    ??? ???? ?????? ??? PivotTable.
  18. ?? ???? ?????? ??? PivotTable? ???? ????? ????? ????? ?? ?????? ??? ??? ?? ???? ??? ?????.
  19. ???? ??? ????? ?????? ??? ?????? 3 ?? ??????? ?? ???? ??? ?????. PivotTable ????? ?????? ???????? ????????.

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

?? ??? ?????? STDEVP ?????? ?????????? ?? ??????? ?? ????? ???????? ??? ???????? ??????? ???????? ??? ?????. ????? ???????? ????????? ?? ???? ???????? ???? ??? ??? ???????; ??? ??? ?????? ???? ???? ????? STDEVP ????? ?? STDEV.

?? ??? ??????? ????? ?????? ?????????? ??? ??? ?? ??? ????? ???????? ?????? % "????? ??". ???? Excel ???? STDEVP ??? ???? ??????. ??? ???? ??? ??????? ?????? % "????? ??" ???? ?? ??? ????? ??????? ?????? ????? ?????. ????? ????? ????? ??? ??? ????.

?????

?????? ??? ???? ?? ????????? ??? ??????? PivotTables ????? ????? ? ???? ??? ??????? Microsoft ?? ??????? ??????????? ????? ???? ???????? ?? ????? pivottable ?? pivotchart ?? ????? Office "??" ????? ??????? ?? ???? ??? ??? ???? ???????? ???? ?? ???????.

???????

???? ???????: 213914 - ????? ??? ??????: 11/?????/1424 - ??????: 4.1
????? ???
  • Microsoft Excel 2000 Standard Edition
????? ??????: 
kbmt kbhowto kbhowtomaster KB213914 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????213914

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

 

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