{"id":77420,"date":"2022-08-15T20:03:55","date_gmt":"2022-08-15T13:03:55","guid":{"rendered":"http:\/\/httl.com.vn\/wiki\/percentile-la-gi\/"},"modified":"2022-08-15T20:03:55","modified_gmt":"2022-08-15T13:03:55","slug":"percentile-la-gi","status":"publish","type":"post","link":"https:\/\/httl.com.vn\/wiki\/percentile-la-gi\/","title":{"rendered":"Percentile l\u00e0 g\u00ec? C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m PERCENTILE trong Excel"},"content":{"rendered":"

Ph\u1ea7n tr\u0103m l\u00e0 g\u00ec <\/strong> kh\u00f4ng ph\u1ea3i l\u00e0 m\u1ed9t kh\u00e1i ni\u1ec7m xa l\u1ea1 trong th\u1ed1ng k\u00ea. n\u00f3 c\u00f3 li\u00ean quan g\u00ec v\u1edbi h\u00e0m ph\u00e2n v\u1ecb <\/strong> sau \u0111\u00e2y? h\u00e3y c\u00f9ng thuthuatoffice <\/strong> t\u00ecm hi\u1ec3u percentile <\/strong> l\u00e0 g\u00ec v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng percentile function trong excel <\/strong> nh\u01b0 th\u1ebf n\u00e0o nh\u00e9. <\/p>\n

\"Percentile<\/p>\n

ph\u00e2n v\u1ecb l\u00e0 g\u00ec? <\/h2>\n

percentile c\u00f3 ngh\u0129a l\u00e0 ph\u00e2n v\u1ecb trong ti\u1ebfng Vi\u1ec7t. Trong x\u00e1c su\u1ea5t th\u1ed1ng k\u00ea, kh\u00e1i ni\u1ec7m ph\u00e2n v\u1ecb l\u00e0 \u01b0\u1edbc t\u00ednh t\u1ef7 l\u1ec7 d\u1eef li\u1ec7u trong t\u1eadp d\u1eef li\u1ec7u n\u1eb1m trong ph\u1ea1m vi tr\u00ean ho\u1eb7c d\u01b0\u1edbi cho m\u1ed9t gi\u00e1 tr\u1ecb nh\u1ea5t \u0111\u1ecbnh. <\/p>\n

\"Percentile<\/p>\n

ph\u01b0\u01a1ng ph\u00e1p x\u1ebfp h\u1ea1ng theo ph\u00e2n v\u1ecb l\u00e0 g\u00ec? <\/h2>\n

Nh\u01b0 \u0111\u00e3 \u0111\u1ec1 c\u1eadp trong ph\u1ea7n ph\u00e2n v\u1ecb l\u00e0 g\u00ec, ph\u00e2n v\u1ecb c\u00f3 li\u00ean quan ch\u1eb7t ch\u1ebd v\u1edbi t\u1ef7 l\u1ec7, c\u1ee5 th\u1ec3 l\u00e0 100%. ph\u01b0\u01a1ng ph\u00e1p x\u1ebfp h\u1ea1ng ph\u1ea7n tr\u0103m l\u00e0 m\u1ed9t ph\u01b0\u01a1ng ph\u00e1p x\u00e1c \u0111\u1ecbnh v\u1ecb tr\u00ed c\u1ee7a m\u1ed9t \u0111\u1ed1i t\u01b0\u1ee3ng c\u1ee5 th\u1ec3 so v\u1edbi m\u1eb7t b\u1eb1ng chung. <\/p>\n

\u1ee9ng d\u1ee5ng c\u1ee7a ph\u00e2n v\u1ecb l\u00e0 g\u00ec? <\/h2>\n

Ph\u1ea7n tr\u0103m \u00e1p d\u1ee5ng trong nhi\u1ec1u tr\u01b0\u1eddng. B\u1ea5t c\u1ee9 l\u00fac n\u00e0o b\u1ea1n c\u1ea7n chia t\u1eadp d\u1eef li\u1ec7u th\u00e0nh c\u00e1c ph\u1ea7n nh\u1ecf h\u01a1n, c\u00e1c ph\u00e2n v\u1ecb s\u1ebd c\u00f3 \u00edch. th\u01b0\u1eddng \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 th\u1ed1ng k\u00ea \u0111i\u1ec3m c\u1ee7a b\u00e0i ki\u1ec3m tra. <\/p>\n

v\u00ed d\u1ee5: trong b\u00e0i ki\u1ec3m tra sat, b\u00ean c\u1ea1nh \u0111i\u1ec3m ki\u1ec3m tra (th\u01b0\u1eddng t\u1eeb 400 \u0111\u1ebfn 1600) l\u00e0 \u0111i\u1ec3m d\u1ef1a tr\u00ean gi\u00e1 tr\u1ecb ph\u1ea7n tr\u0103m \u0111\u01b0\u1ee3c g\u1ecdi l\u00e0 ph\u00e2n v\u1ecb \u0111i\u1ec3m sat. ph\u1ea7n tr\u0103m c\u1ee7a \u0111i\u1ec3m s\u1ed1 v\u1ec7 tinh l\u00e0 bao nhi\u00eau? l\u00e0 con s\u1ed1 so s\u00e1nh k\u1ebft qu\u1ea3 c\u1ee7a \u1ee9ng vi\u00ean \u0111\u00f3 v\u1edbi c\u00e1c \u1ee9ng vi\u00ean c\u00f2n l\u1ea1i trong k\u1ef3 thi \u0111\u00f3. <\/p>\n

\"Percentile<\/p>\n

M\u1ed9t v\u00ed d\u1ee5 kh\u00e1c v\u1ec1 t\u1ef7 l\u1ec7 ph\u1ea7n tr\u0103m \u0111\u01b0\u1ee3c t\u00ecm th\u1ea5y trong bi\u1ec3u \u0111\u1ed3 t\u0103ng tr\u01b0\u1edfng c\u1ee7a tr\u1ebb em. Ngo\u00e0i vi\u1ec7c cung c\u1ea5p th\u01b0\u1edbc \u0111o chi\u1ec1u cao ho\u1eb7c c\u00e2n n\u1eb7ng th\u1ec3 ch\u1ea5t, b\u00e1c s\u0129 nhi khoa th\u01b0\u1eddng bi\u1ec3u th\u1ecb th\u00f4ng tin n\u00e0y d\u01b0\u1edbi d\u1ea1ng ph\u00e2n v\u1ecb. <\/p>\n

Ph\u1ea7n tr\u0103m \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 so s\u00e1nh chi\u1ec1u cao ho\u1eb7c c\u00e2n n\u1eb7ng c\u1ee7a m\u1ed9t \u0111\u1ee9a tr\u1ebb v\u1edbi nh\u1eefng \u0111\u1ee9a tr\u1ebb kh\u00e1c \u1edf c\u00f9ng \u0111\u1ed9 tu\u1ed5i. \u0111i\u1ec1u n\u00e0y cho ph\u00e9p m\u1ed9t ph\u01b0\u01a1ng ti\u1ec7n so s\u00e1nh hi\u1ec7u qu\u1ea3 \u0111\u1ec3 cha m\u1eb9 c\u00f3 th\u1ec3 bi\u1ebft \u0111\u01b0\u1ee3c s\u1ef1 ph\u00e1t tri\u1ec3n c\u1ee7a con m\u00ecnh l\u00e0 b\u00ecnh th\u01b0\u1eddng hay b\u1ea5t th\u01b0\u1eddng. <\/p>\n

\"Percentile<\/p>\n

c\u00e1ch t\u00ednh ph\u1ea7n tr\u0103m? <\/h2>\n

Ph\u1ea7n tr\u0103m trong m\u1ed9t t\u1eadp d\u1eef li\u1ec7u nh\u1ea5t \u0111\u1ecbnh c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c t\u00ednh b\u1eb1ng c\u00f4ng th\u1ee9c: <\/p>\n

n = (p \/ 100) x n <\/strong> <\/p>\n

\u1edf \u0111\u00e2u: <\/p>\n

    \n
  • n <\/strong> = s\u1ed1 l\u01b0\u1ee3ng gi\u00e1 tr\u1ecb trong t\u1eadp d\u1eef li\u1ec7u. <\/li>\n
  • p <\/strong> = ph\u1ea7n tr\u0103m. <\/li>\n
  • n <\/strong> = x\u1ebfp h\u1ea1ng th\u1ee9 t\u1ef1 c\u1ee7a m\u1ed9t gi\u00e1 tr\u1ecb nh\u1ea5t \u0111\u1ecbnh (v\u1edbi c\u00e1c gi\u00e1 tr\u1ecb trong t\u1eadp d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c s\u1eafp x\u1ebfp t\u1eeb nh\u1ecf nh\u1ea5t \u0111\u1ebfn l\u1edbn nh\u1ea5t). <\/li>\n<\/ul>\n

    V\u00ed d\u1ee5: l\u1ea5y m\u1ed9t l\u1edbp g\u1ed3m 20 sinh vi\u00ean c\u00f3 c\u00e1c \u0111i\u1ec3m sau trong b\u00e0i ki\u1ec3m tra g\u1ea7n \u0111\u00e2y nh\u1ea5t c\u1ee7a h\u1ecd: 75, 77, 78, 78, 80, 81, 81, 82, 83, 84, 84, 84, 85, 87 , 87, 88, 88, 88, 89, 90. <\/p>\n

    C\u00e1c \u0111i\u1ec3m s\u1ed1 n\u00e0y c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c bi\u1ec3u di\u1ec5n d\u01b0\u1edbi d\u1ea1ng t\u1eadp d\u1eef li\u1ec7u v\u1edbi 20 gi\u00e1 tr\u1ecb: {75, 77, 78, 78, 80, 81, 81, 82, 83, 84, 84, 84, 85, 87, 87, 88, 88 , 88, 89, 90}. <\/p>\n

    ch\u00fang ta c\u00f3 th\u1ec3 t\u00ecm th\u1ea5y \u0111i\u1ec3m \u0111\u00e1nh d\u1ea5u ph\u1ea7n tr\u0103m th\u1ee9 20 b\u1eb1ng c\u00e1ch th\u00eam c\u00e1c gi\u00e1 tr\u1ecb \u0111\u00e3 bi\u1ebft v\u00e0o c\u00f4ng th\u1ee9c v\u00e0 gi\u1ea3i cho n: <\/p>\n

    n = (20\/100) x 20 <\/p>\n

    n = 4 <\/p>\n

    Gi\u00e1 tr\u1ecb th\u1ee9 t\u01b0 trong t\u1eadp d\u1eef li\u1ec7u (t\u00ednh t\u1eeb d\u01b0\u1edbi l\u00ean) l\u00e0 \u0111i\u1ec3m 78. \u0110i\u1ec1u n\u00e0y c\u00f3 ngh\u0129a l\u00e0 s\u1ed1 78 \u0111\u00e1nh d\u1ea5u ph\u1ea7n tr\u0103m th\u1ee9 20 c\u1ee7a s\u1ed1 h\u1ecdc sinh trong l\u1edbp, t\u1ee9c l\u00e0 20 ph\u1ea7n tr\u0103m \u0111i\u1ec3m cao nh\u1ea5t. 78 . d\u01b0\u1edbi \u0111\u00e2y. <\/p>\n

    c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m ph\u00e2n v\u1ecb trong excel <\/h2>\n

    Trong excel, h\u00e0m ph\u00e2n v\u1ecb <\/strong> \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 t\u00ednh to\u00e1n ph\u1ea7n tr\u0103m gi\u00e1 tr\u1ecb trong m\u1ed9t t\u1eadp d\u1eef li\u1ec7u c\u1ee5 th\u1ec3. h\u00e0m ph\u00e2n v\u1ecb s\u1ebd tr\u1ea3 v\u1ec1 ph\u00e2n v\u1ecb th\u1ee9 k c\u1ee7a c\u00e1c gi\u00e1 tr\u1ecb trong ph\u1ea1m vi. b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng ch\u1ee9c n\u0103ng n\u00e0y \u0111\u1ec3 \u0111\u1eb7t ng\u01b0\u1ee1ng ch\u1ea5p nh\u1eadn. v\u00ed d\u1ee5: b\u1ea1n c\u00f3 th\u1ec3 quy\u1ebft \u0111\u1ecbnh ki\u1ec3m tra nh\u1eefng \u1ee9ng vi\u00ean \u0111\u1ea1t \u0111i\u1ec3m tr\u00ean ph\u00e2n v\u1ecb th\u1ee9 90. <\/p>\n

    c\u00fa ph\u00e1p h\u00e0m ph\u00e2n v\u1ecb trong excel <\/h3>\n

    = ph\u00e2n v\u1ecb (m\u1ea3ng, k) <\/b> <\/p>\n

    \u1edf \u0111\u00e2u: <\/p>\n

      \n
    • array <\/strong>: b\u1eaft bu\u1ed9c. m\u1ea3ng ho\u1eb7c d\u1ea3i d\u1eef li\u1ec7u x\u00e1c \u0111\u1ecbnh v\u1ecb tr\u00ed t\u01b0\u01a1ng \u0111\u1ed1i. <\/li>\n
    • k <\/strong>: B\u1eaft bu\u1ed9c. gi\u00e1 tr\u1ecb ph\u00e2n v\u1ecb trong ph\u1ea1m vi 0..1, bao g\u1ed3m 0 v\u00e0 1. <\/li>\n<\/ul>\n

      l\u01b0u \u00fd: <\/p>\n

        \n
      • n\u1ebfu k kh\u00f4ng ph\u1ea3i l\u00e0 s\u1ed1, h\u00e0m ph\u00e2n v\u1ecb tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb l\u1ed7i #! . <\/li>\n
      • n\u1ebfu k & lt; 0 ho\u1eb7c n\u1ebfu k & gt; 1, h\u00e0m percentile tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb l\u1ed7i #num! . <\/li>\n
      • n\u1ebfu k kh\u00f4ng ph\u1ea3i l\u00e0 b\u1ed9i s\u1ed1 c\u1ee7a 1 \/ (n – 1), h\u00e0m ph\u00e2n v\u1ecb s\u1ebd n\u1ed9i suy \u0111\u1ec3 x\u00e1c \u0111\u1ecbnh gi\u00e1 tr\u1ecb c\u1ee7a ph\u00e2n v\u1ecb th\u1ee9 k. <\/li>\n<\/ul>\n

        v\u00ed d\u1ee5 s\u1eed d\u1ee5ng h\u00e0m ph\u00e2n v\u1ecb trong excel <\/h3>\n

        Trong v\u00ed d\u1ee5 n\u00e0y, ch\u00fang t\u00f4i s\u1ebd t\u00ecm ph\u1ea7n tr\u0103m th\u1ee9 30 c\u1ee7a danh s\u00e1ch trong c\u00e1c \u00f4 e2: e5. <\/p>\n

        Hi\u1ec7n t\u1ea1i, h\u00e0m ph\u00e2n v\u1ecb l\u00e0 m\u1ed9t trong s\u1ed1 \u00edt c\u00e1c h\u00e0m excel kh\u00f4ng c\u00f2n \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng ph\u1ed5 bi\u1ebfn n\u1eefa. Microsoft \u0111\u00e3 thay th\u1ebf h\u00e0m ph\u00e2n v\u1ecb b\u1eb1ng hai h\u00e0m m\u1edbi v\u1edbi \u0111\u1ed9 ch\u00ednh x\u00e1c t\u1ed1t h\u01a1n v\u00e0 t\u00ean ph\u1ea3n \u00e1nh t\u1ed1t h\u01a1n vi\u1ec7c s\u1eed d\u1ee5ng ch\u00fang, percentile.exc v\u00e0 percentile.inc. sau \u0111\u00e2y v\u0103n ph\u00f2ng thuthuat s\u1ebd gi\u1edbi thi\u1ec7u s\u01a1 qua v\u1ec1 hai ch\u1ee9c n\u0103ng n\u00e0y. <\/p>\n

        H\u00e0m <\/p>\n

        percentile.exc trong excel <\/h2>\n

        C\u00fa ph\u00e1p h\u00e0m <\/p>\n

        percentile.exc trong excel <\/h3>\n

        = ph\u00e2n v\u1ecb. exc (m\u1ea3ng, k) <\/b> <\/p>\n

        \u1edf \u0111\u00e2u: <\/p>\n

          \n
        • array <\/strong>: b\u1eaft bu\u1ed9c. m\u1ea3ng ho\u1eb7c d\u1ea3i d\u1eef li\u1ec7u x\u00e1c \u0111\u1ecbnh v\u1ecb tr\u00ed t\u01b0\u01a1ng \u0111\u1ed1i. <\/li>\n
        • k <\/strong>: B\u1eaft bu\u1ed9c. gi\u00e1 tr\u1ecb ph\u00e2n v\u1ecb trong ph\u1ea1m vi 0..1, bao g\u1ed3m 0 v\u00e0 1. <\/li>\n<\/ul>\n

          l\u01b0u \u00fd: <\/p>\n

            \n
          • n\u1ebfu \u0111\u1ed1i s\u1ed1 m\u1ea3ng tr\u1ed1ng, percentile.exc tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb l\u1ed7i #num! . <\/li>\n
          • n\u1ebfu k kh\u00f4ng ph\u1ea3i l\u00e0 s\u1ed1, percentile.exc tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb #! . <\/li>\n
          • n\u1ebfu k \u2264 0 ho\u1eb7c n\u1ebfu k \u2265 1, percentile.exc tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb l\u1ed7i #num! . <\/li>\n
          • n\u1ebfu k kh\u00f4ng ph\u1ea3i l\u00e0 b\u1ed9i s\u1ed1 c\u1ee7a 1 \/ (n + 1) th\u00ec l\u00e0 ph\u00e2n v\u1ecb. n\u1ed9i suy exc \u0111\u1ec3 x\u00e1c \u0111\u1ecbnh gi\u00e1 tr\u1ecb \u1edf ph\u00e2n v\u1ecb th\u1ee9 k. <\/li>\n
          • h\u00e0m percentile.exc s\u1ebd n\u1ed9i suy khi gi\u00e1 tr\u1ecb c\u1ee7a ph\u00e2n v\u1ecb \u0111\u01b0\u1ee3c ch\u1ec9 \u0111\u1ecbnh n\u1eb1m gi\u1eefa hai gi\u00e1 tr\u1ecb trong m\u1ea3ng. n\u1ebfu h\u00e0m kh\u00f4ng th\u1ec3 n\u1ed9i suy cho ph\u00e2n v\u1ecb th\u1ee9 k \u0111\u01b0\u1ee3c ch\u1ec9 \u0111\u1ecbnh, th\u00ec excel tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb l\u1ed7i #num! . <\/li>\n<\/ul>\n

            v\u00ed d\u1ee5 s\u1eed d\u1ee5ng h\u00e0m percentile.exc trong excel <\/h3>\n

            = percentile.inc (b2: b10,0,25) <\/p>\n

            description: T\u00ednh to\u00e1n ph\u1ea7n tr\u0103m th\u1ee9 25 c\u1ee7a danh s\u00e1ch trong ph\u1ea1m vi b2: b5. <\/p>\n

            k\u1ebft qu\u1ea3: 2,5. <\/p>\n

            \"Percentile<\/p>\n

            H\u00e0m <\/p>\n

            percentile.inc trong excel <\/h2>\n

            C\u00fa ph\u00e1p h\u00e0m <\/p>\n

            percentile.inc trong excel <\/h3>\n

            = percentile.inc (ma tr\u1eadn, k) <\/strong> <\/p>\n

            \u1edf \u0111\u00e2u: <\/p>\n

              \n
            • array <\/strong>: b\u1eaft bu\u1ed9c. m\u1ea3ng ho\u1eb7c d\u1ea3i d\u1eef li\u1ec7u x\u00e1c \u0111\u1ecbnh v\u1ecb tr\u00ed t\u01b0\u01a1ng \u0111\u1ed1i. <\/li>\n
            • k <\/strong>: B\u1eaft bu\u1ed9c. gi\u00e1 tr\u1ecb ph\u00e2n v\u1ecb trong ph\u1ea1m vi 0..1, bao g\u1ed3m 0 v\u00e0 1. <\/li>\n<\/ul>\n

              l\u01b0u \u00fd: <\/p>\n

                \n
              • n\u1ebfu \u0111\u1ed1i s\u1ed1 m\u1ea3ng tr\u1ed1ng, percentile.inc tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb l\u1ed7i #num! . <\/li>\n
              • n\u1ebfu k kh\u00f4ng ph\u1ea3i l\u00e0 s\u1ed1, percentile.inc tr\u1ea3 v\u1ec1 l\u1ed7i #value. . <\/li>\n
              • n\u1ebfu k & lt; 0 ho\u1eb7c n\u1ebfu k & gt; 1, h\u00e0m percentile.inc tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb l\u1ed7i #num! . <\/li>\n
              • n\u1ebfu k kh\u00f4ng ph\u1ea3i l\u00e0 b\u1ed9i s\u1ed1 c\u1ee7a 1 \/ (n – 1), h\u00e0m percentile.inc s\u1ebd n\u1ed9i suy \u0111\u1ec3 x\u00e1c \u0111\u1ecbnh gi\u00e1 tr\u1ecb c\u1ee7a ph\u00e2n v\u1ecb th\u1ee9 k. <\/li>\n<\/ul>\n

                v\u00ed d\u1ee5 s\u1eed d\u1ee5ng h\u00e0m percentile.inc trong excel <\/h3>\n

                = percentile.inc (b2: b5,0.3) <\/p>\n

                description: T\u00ednh to\u00e1n ph\u1ea7n tr\u0103m th\u1ee9 30 c\u1ee7a danh s\u00e1ch trong ph\u1ea1m vi b2: b5. <\/p>\n

                k\u1ebft qu\u1ea3: 1,9. <\/p>\n

                \u1edf tr\u00ean, thuthuatoffice \u0111\u00e3 \u0111\u01b0a ra c\u00e2u tr\u1ea3 l\u1eddi cho c\u00e2u h\u1ecfi ph\u00e2n v\u1ecb l\u00e0 g\u00ec v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m ph\u00e2n v\u1ecb trong excel. hi v\u1ecdng sau khi \u0111\u1ecdc xong b\u00e0i vi\u1ebft n\u00e0y c\u00e1c b\u1ea1n s\u1ebd th\u1ef1c h\u00e0nh c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m percentile trong excel \u0111\u1ec3 hi\u1ec3u r\u00f5 h\u01a1n v\u1ec1 h\u00e0m n\u00e0y. <\/p>\n

                xem th\u00eam: <\/p>\n

                  \n
                • h\u00e0m thay th\u1ebf trong excel <\/li>\n
                • h\u00e0m ph\u00e1t hi\u1ec7n c\u00e1c k\u00fd t\u1ef1 trong excel <\/li>\n
                • h\u00e0m hi\u1ec3n th\u1ecb danh s\u00e1ch trong excel <\/li>\n<\/ul>\n

                  \u0111\u1eebng qu\u00ean th\u00edch & amp; Chia s\u1ebb n\u1ebfu b\u1ea1n th\u1ea5y b\u00e0i vi\u1ebft n\u00e0y h\u1eefu \u00edch. H\u00e3y nh\u1edb th\u1ec9nh tho\u1ea3ng gh\u00e9 th\u0103m thuthuatoffice \u0111\u1ec3 bi\u1ebft th\u00eam th\u00f4ng tin th\u00fa v\u1ecb v\u1ec1 c\u00e1c ch\u1ee7 \u0111\u1ec1 li\u00ean quan \u0111\u1ebfn v\u0103n ph\u00f2ng. <\/p>\n

                    \n
                  • \n

                    7 c\u00e1ch c\u1ef1c k\u1ef3 h\u1eefu \u00edch \u0111\u1ec3 vi\u1ebft s\u1ed1 m\u0169 trong excel m\u00e0 b\u1ea1n n\u00ean bi\u1ebft <\/h3>\n

                    h\u01b0\u1edbng d\u1eabn 5 c\u00e1ch ng\u1eaft d\u00f2ng trong excel mac <\/h3>\n

                    h\u00e0m s\u1eafp x\u1ebfp trong excel v\u00e0 c\u00f4ng th\u1ee9c s\u1eafp x\u1ebfp c\u00f3 \u0111i\u1ec1u ki\u1ec7n <\/h3>\n

                    t\u00f3m t\u1eaft 7 c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m \u0111\u1ebfm k\u00fd t\u1ef1 len <\/h3>\n

                    c\u00e1ch xoay v\u0103n b\u1ea3n trong excel khi\u1ebfn ng\u01b0\u1eddi xem nghi\u00eang ng\u1ea3 khi nh\u00ecn v\u00e0o b\u1ea3ng t\u00ednh c\u1ee7a b\u1ea1n <\/h3>\n

                    4 c\u00e1ch nhanh ch\u00f3ng v\u00e0 d\u1ec5 d\u00e0ng \u0111\u1ec3 t\u00e1ch t\u00ean trong excel m\u00e0 b\u1ea1n n\u00ean bi\u1ebft <\/h3>\n

                    c\u00e1ch ch\u00e8n file pdf v\u00e0o excel \u0111\u1ea7y \u0111\u1ee7 v\u00e0 ti\u1ec7n l\u1ee3i cho d\u00e2n v\u0103n ph\u00f2ng <\/h3>\n","protected":false},"excerpt":{"rendered":"

                    Ph\u1ea7n tr\u0103m l\u00e0 g\u00ec kh\u00f4ng ph\u1ea3i l\u00e0 m\u1ed9t kh\u00e1i ni\u1ec7m xa l\u1ea1 trong th\u1ed1ng k\u00ea. n\u00f3 c\u00f3 li\u00ean quan g\u00ec v\u1edbi h\u00e0m ph\u00e2n v\u1ecb sau \u0111\u00e2y? h\u00e3y c\u00f9ng thuthuatoffice t\u00ecm hi\u1ec3u percentile l\u00e0 g\u00ec v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng percentile function trong excel nh\u01b0 th\u1ebf n\u00e0o nh\u00e9. ph\u00e2n v\u1ecb l\u00e0 g\u00ec? percentile c\u00f3 ngh\u0129a l\u00e0 ph\u00e2n…<\/p>\n","protected":false},"author":1,"featured_media":77421,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[44],"tags":[],"_links":{"self":[{"href":"https:\/\/httl.com.vn\/wiki\/wp-json\/wp\/v2\/posts\/77420"}],"collection":[{"href":"https:\/\/httl.com.vn\/wiki\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/httl.com.vn\/wiki\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/httl.com.vn\/wiki\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/httl.com.vn\/wiki\/wp-json\/wp\/v2\/comments?post=77420"}],"version-history":[{"count":0,"href":"https:\/\/httl.com.vn\/wiki\/wp-json\/wp\/v2\/posts\/77420\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/httl.com.vn\/wiki\/wp-json\/wp\/v2\/media\/77421"}],"wp:attachment":[{"href":"https:\/\/httl.com.vn\/wiki\/wp-json\/wp\/v2\/media?parent=77420"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/httl.com.vn\/wiki\/wp-json\/wp\/v2\/categories?post=77420"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/httl.com.vn\/wiki\/wp-json\/wp\/v2\/tags?post=77420"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}