{"id":10997,"date":"2025-01-15T01:00:12","date_gmt":"2025-01-15T01:00:12","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/gioi-thieu-bieu-do-tan-suat-pareto-trong-excel\/"},"modified":"2025-01-15T01:00:12","modified_gmt":"2025-01-15T01:00:12","slug":"gioi-thieu-bieu-do-tan-suat-pareto-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/gioi-thieu-bieu-do-tan-suat-pareto-trong-excel\/","title":{"rendered":"Gi\u1edbi thi\u1ec7u bi\u1ec3u \u0111\u1ed3 t\u1ea7n su\u1ea5t (Pareto) trong Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-9212\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/pareto-chart.png\" width=\"600\" height=\"337\" title=\"pareto-chart\"><\/p>\n<p>H\u00f4m nay H\u1ecdc Excel Online xin gi\u1edbi thi\u1ec7u v\u1edbi c\u00e1c b\u1ea1n v\u1ec1 bi\u1ec3u \u0111\u1ed3 t\u1ea7n su\u1ea5t hay c\u00f2n \u0111\u01b0\u1ee3c g\u1ecdi l\u00e0 bi\u1ec3u \u0111\u1ed3 Pareto. \u0110\u00e2y l\u00e0 d\u1ea1ng bi\u1ec3u \u0111\u1ed3 bi\u1ebfn th\u1ec3 c\u1ee7a bi\u1ec3u \u0111\u1ed3 histogram, \u0111\u01b0\u1ee3c s\u1eafp x\u1ebfp theo th\u1ee9 t\u1ef1 gi\u1ea3m d\u1ea7n \u0111\u1ec3 d\u1ec5 ph\u00e2n t\u00edch h\u01a1n. Vi\u1ec7c ghi nh\u1edb c\u00e1c\u00a0chu\u1ed7i \u0111\u01b0\u1ee3c th\u1ef1c hi\u1ec7n t\u1ef1 \u0111\u1ed9ng v\u00e0 s\u1ebd c\u00f3 th\u00eam 1 tr\u1ee5c tung ph\u1ee5 n\u1eb1m \u1edf b\u00ean ph\u1ea3i bi\u1ec3u \u0111\u1ed3 c\u00f3 t\u00e1c d\u1ee5ng minh h\u1ecda c\u01a1 c\u1ea5u c\u1ee7a t\u1eebng nh\u00f3m d\u1eef li\u1ec7u trong to\u00e0n th\u1ec3.<\/p>\n<p>Bi\u1ec3u \u0111\u1ed3 Pareto c\u00f3 kh\u1ea3 n\u0103ng minh h\u1ecda nh\u1eefng n\u00e9t \u0111\u1eb7c tr\u01b0ng nh\u1ea5t c\u1ee7a m\u1ed9t b\u1ea3ng d\u1eef li\u1ec7u b\u1ea5t k\u1ef3. Tu\u00e2n theo quy t\u1eafc ph\u00e2n t\u00edch 80\/20, ch\u1ec9 c\u1ea7n 20% nh\u00f3m s\u1ed1 li\u1ec7u l\u00e0 c\u00f3 th\u1ec3\u00a0minh h\u1ecda \u0111\u01b0\u1ee3c\u00a080% l\u01b0\u1ee3ng d\u1eef li\u1ec7u hi\u1ec7n c\u00f3. \u00a0Bi\u1ec3u \u0111\u1ed3 n\u00e0y th\u01b0\u1eddng \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng trong vi\u1ec7c c\u1ea3i ti\u1ebfn quy tr\u00ecnh l\u00e0m vi\u1ec7c, t\u1eeb \u0111\u00f3 ph\u00e1t hi\u1ec7n ra y\u1ebfu t\u1ed1 n\u00e0o c\u1ea7n ph\u1ea3i \u0111\u01b0\u1ee3c ch\u00fa \u00fd th\u00fac \u0111\u1ea9y v\u00e0 ph\u00e1t tri\u1ec3n h\u01a1n n\u1eefa.<\/p>\n<p><strong>\u0110i\u1ec3m c\u1ed9ng:<\/strong><\/p>\n<ul>\n<li>Th\u1ec3 hi\u1ec7n r\u00f5 y\u1ebfu t\u1ed1 n\u00e0o l\u00e0 n\u1ed5i b\u1eadt nh\u1ea5t, chi\u1ebfm vai tr\u00f2 ch\u1ee7 \u0111\u1ea1o<\/li>\n<li>Excel c\u00f3 kh\u1ea3 n\u0103ng t\u1ef1 \u0111\u1ed9ng t\u1ea1o l\u1eadp bi\u1ec3u \u0111\u1ed3 histogram c\u0169ng nh\u01b0\u00a0ch\u00e8n th\u00eam \u0111\u01b0\u1eddng Pareto v\u00e0o h\u00ecnh minh h\u1ecda<\/li>\n<\/ul>\n<p><strong>\u0110i\u1ec3m tr\u1eeb:<\/strong><\/p>\n<ul>\n<li>Nhi\u1ec1u ng\u01b0\u1eddi s\u1ebd c\u1ea3m th\u1ea5y l\u1ea1 l\u1eabm v\u1edbi bi\u1ec3u \u0111\u1ed3 Pareto v\u00ec \u0111\u00e2y kh\u00f4ng ph\u1ea3i l\u00e0 d\u1ea1ng bi\u1ec3u \u0111\u1ed3 th\u00f4ng d\u1ee5ng<\/li>\n<li>Bi\u1ec3u \u0111\u1ed3 h\u1ed7n h\u1ee3p th\u01b0\u1eddng d\u1ec5 t\u00f9y ch\u1ec9nh h\u01a1n so v\u1edbi bi\u1ec3u \u0111\u1ed3 Pareto \u0111\u01b0\u1ee3c c\u00e0i s\u1eb5n trong Excel<\/li>\n<\/ul>\n<p><strong>Tham kh\u1ea3o c\u00e1c d\u1ea1ng bi\u1ec3u \u0111\u1ed3 kh\u00e1c:<\/strong><\/p>\n<p><a href=\"https:\/\/exceljet.net\/chart-type\/scatter-plot\">Bi\u1ec3u \u0111\u1ed3 ph\u00e2n t\u00e1n<\/a><\/p>\n<p><a href=\"https:\/\/exceljet.net\/chart-type\/bar-chart\">Bi\u1ec3u \u0111\u1ed3 c\u1ed9t ngang<\/a><\/p>\n<div class=\"code-block code-block-1\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/ex101_92019-nho-249.gif\" title=\"ex101_92019-nho-249\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p><a href=\"https:\/\/exceljet.net\/chart-type\/column-chart\">Bi\u1ec3u \u0111\u1ed3 c\u1ed9t \u0111\u1ee9ng<\/a><\/p>\n<p><a href=\"https:\/\/exceljet.net\/chart-type\/area-chart\">Bi\u1ec3u \u0111\u1ed3 mi\u1ec1n<\/a><\/p>\n<\/div>\n<div class=\"uk-panel uk-margin uk-width-xlarge\">\n<p>Click \u0111\u0103ng k\u00fd h\u1ecdc t\u1ea1i:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc\" target=\"_blank\" rel=\"noopener\">T\u1ea5t c\u1ea3 kho\u00e1 h\u1ecdc\u00a0<span>\ud83d\udcd6<\/span><\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-kich-hoat-khoa-hoc-tai-hoc-excel-online.html\" target=\"_blank\" rel=\"noopener\">H\u01b0\u1edbng d\u1eabn k\u00edch ho\u1ea1t<\/a><\/p>\n<p>HKD H\u1ecdc Excel Online<br \/>S\u1ed1 \u0110K: 17A80048102<\/p>\n<\/div>\n<div class=\"uk-panel uk-text-small uk-margin uk-margin-remove-bottom uk-text-center\">\n<p>\u00a9  document.currentScript.insertAdjacentHTML(&#8216;afterend&#8217;, &#8221; + new Intl.DateTimeFormat(document.documentElement.lang, {year: &#8216;numeric&#8217;}).format() + &#8221;);  H\u1ecdc Excel Online. All rights reserved.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/ex101_92019-nho-249.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":10998,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-10997","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-co-ban"],"_links":{"self":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/10997","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/comments?post=10997"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/10997\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/10998"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=10997"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=10997"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=10997"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}