{"id":7875,"date":"2024-12-21T18:44:24","date_gmt":"2024-12-21T18:44:24","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/huong-dan-su-dung-excel-giai-bai-toan-ly-thuyet-thong-ke-don-gian\/"},"modified":"2024-12-21T18:44:24","modified_gmt":"2024-12-21T18:44:24","slug":"huong-dan-su-dung-excel-giai-bai-toan-ly-thuyet-thong-ke-don-gian","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/huong-dan-su-dung-excel-giai-bai-toan-ly-thuyet-thong-ke-don-gian\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng Excel gi\u1ea3i b\u00e0i to\u00e1n l\u00fd thuy\u1ebft th\u1ed1ng k\u00ea \u0111\u01a1n gi\u1ea3n"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p><em>Trong th\u1ef1c t\u1ebf nhu c\u1ea7u ti\u1ebfn h\u00e0nh nh\u1eefng c\u00f4ng t\u00e1c th\u1ed1ng k\u00ea l\u00e0 v\u00f4 c\u00f9ng l\u1edbn, qua \u0111\u00f3 ng\u01b0\u1eddi ta c\u00f3 th\u1ec3 thu th\u1eadp, t\u1ed5 ch\u1ee9c, ph\u00e2n t\u00edch v\u00e0 di\u1ec5n gi\u1ea3i d\u1eef li\u1ec7u \u0111\u1ec3 \u0111\u01b0a ra quy\u1ebft \u0111\u1ecbnh h\u1ee3p l\u00fd. V\u1edbi b\u00e0i vi\u1ebft n\u00e0y, <a href=\"http:\/\/blog.ezworkapp.com\/\"><strong>H\u1ecdc Excel Online<\/strong><\/a> s\u1ebd h\u01b0\u1edbng d\u1eabn b\u1ea1n c\u00e1ch gi\u1ea3i b\u00e0i to\u00e1n l\u00fd thuy\u1ebft th\u1ed1ng k\u00ea \u0111\u01a1n gi\u1ea3n:\u00a0T\u00ednh t\u1ea7n s\u1ed1 v\u00e0 t\u1ea7n su\u1ea5t m\u1eabu.<\/em><\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_61 counter-hierarchy ez-toc-counter ez-toc-transparent ez-toc-container-direction\">\n<p class=\"ez-toc-title\">Xem nhanh<\/p>\n<p><label for=\"ez-toc-cssicon-toggle-item-67670c8801d05\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><\/span><\/span><\/label><\/p>\n<nav>\n<ul class=\"ez-toc-list ez-toc-list-level-1 \">\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/bai-toan-ly-thuyet-thong-ke.html#Bai_toan_ly_thuyet_thong_ke_voi_tan_so_Frequency_va_tan_suat_Relative_Frequency\" title=\"B\u00e0i to\u00e1n l\u00fd thuy\u1ebft th\u1ed1ng k\u00ea v\u1edbi t\u1ea7n s\u1ed1 (Frequency) v\u00e0 t\u1ea7n su\u1ea5t (Relative Frequency)\">B\u00e0i to\u00e1n l\u00fd thuy\u1ebft th\u1ed1ng k\u00ea v\u1edbi t\u1ea7n s\u1ed1 (Frequency) v\u00e0 t\u1ea7n su\u1ea5t (Relative Frequency)<\/a>\n<ul class=\"ez-toc-list-level-3\">\n<li class=\"ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/bai-toan-ly-thuyet-thong-ke.html#Dat_van_de\" title=\"\u0110\u1eb7t v\u1ea5n \u0111\u1ec1\">\u0110\u1eb7t v\u1ea5n \u0111\u1ec1<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/bai-toan-ly-thuyet-thong-ke.html#Su_dung_Excel_trinh_bay_bai_toan\" title=\"S\u1eed d\u1ee5ng Excel tr\u00ecnh b\u00e0y b\u00e0i to\u00e1n\">S\u1eed d\u1ee5ng Excel tr\u00ecnh b\u00e0y b\u00e0i to\u00e1n<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Bai_toan_ly_thuyet_thong_ke_voi_tan_so_Frequency_va_tan_suat_Relative_Frequency\"><\/span>B\u00e0i to\u00e1n l\u00fd thuy\u1ebft th\u1ed1ng k\u00ea v\u1edbi t\u1ea7n s\u1ed1 (Frequency) v\u00e0 t\u1ea7n su\u1ea5t (Relative Frequency)<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3><span class=\"ez-toc-section\" id=\"Dat_van_de\"><\/span>\u0110\u1eb7t v\u1ea5n \u0111\u1ec1<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Ta c\u00f3 b\u00e0i to\u00e1n sau:<\/p>\n<p><em>30 h\u1ecdc sinh trung h\u1ecdc ng\u1eabu nhi\u00ean \u0111\u00e3 \u0111\u01b0\u1ee3c ch\u1ecdn ra \u0111\u1ec3 l\u00e0m kh\u1ea3o s\u00e1t tr\u1ea3 l\u1eddi cho c\u00e2u h\u1ecfi: B\u1ea1n d\u00e0nh trung b\u00ecnh bao nhi\u00eau th\u1eddi gian tr\u00ean Internet m\u1ed9t tu\u1ea7n? K\u1ebft qu\u1ea3 \u0111\u01b0\u1ee3c li\u1ec7t k\u00ea trong b\u1ea3ng d\u01b0\u1edbi \u0111\u00e2y:<\/em><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-30420 size-large\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ly-thuyet-thong-ke-1-1024x97-1.png\" alt=\"huong-dan-su-dung-excel-giai-quyet-bai-toan-thong-ke-don-gian-1\" width=\"1024\" height=\"97\" title=\"ly-thuyet-thong-ke-1-1024x97-1\"><\/p>\n<p>Y\u00eau c\u1ea7u: T\u1eeb b\u1ea3ng tr\u00ean, h\u00e3y th\u1ec3 hi\u1ec7n t\u1ea7n s\u1ed1 (frequency) v\u00e0 t\u1ea7n su\u1ea5t (relative frequency) c\u1ee7a d\u1eef li\u1ec7u.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Su_dung_Excel_trinh_bay_bai_toan\"><\/span>S\u1eed d\u1ee5ng Excel tr\u00ecnh b\u00e0y b\u00e0i to\u00e1n<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u0110\u1ec3 th\u1ec3 hi\u1ec7n t\u1ea7n s\u1ed1 v\u00e0 t\u1ea7n su\u1ea5t, tr\u01b0\u1edbc ti\u00ean ta c\u1ea7n \u0111\u01b0a ra c\u00e1c m\u1eabu ri\u00eang bi\u1ec7t. Excel ho\u00e0n to\u00e0n c\u00f3 th\u1ec3 l\u00e0m \u0111i\u1ec1u n\u00e0y b\u1eb1ng vi\u1ec7c s\u1eed d\u1ee5ng\u00a0<strong>Text to column<\/strong>, c\u00e1c h\u00e0m nh\u01b0\u00a0<strong>Unique<\/strong> ho\u1eb7c ti\u1ebfn h\u00e0nh th\u1ee7 c\u00f4ng. Sau khi th\u1ef1c hi\u1ec7n, ta c\u00f3 danh s\u00e1ch sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-30421 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ly-thuyet-thong-ke-2.png\" alt=\"huong-dan-su-dung-excel-giai-quyet-bai-toan-thong-ke-don-gian-2\" width=\"667\" height=\"284\" title=\"ly-thuyet-thong-ke-2\"><\/p>\n<div class=\"code-block code-block-2\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/vba101-tu-dong-hoa-excel-voi-lap-trinh-vba-cho-nguoi-moi-bat-dau\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/vba101_92019-nho-322.gif\" title=\"vba101_92019-nho-322\"><br \/>\n<\/a>\n<\/div>\n<\/div>\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\/2024\/12\/ex101_92019-nho-708.gif\" title=\"ex101_92019-nho-708\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p>\u00a0<\/p>\n<p><strong>T\u1ea7n s\u1ed1 (Frequency)\u00a0<\/strong>bi\u1ec3u th\u1ecb s\u1ed1 l\u1ea7n xu\u1ea5t hi\u1ec7n c\u1ee7a gi\u00e1 tr\u1ecb X. \u0110\u1ec3 t\u00ednh t\u1ea7n s\u1ed1 xu\u1ea5t hi\u1ec7n c\u1ee7a m\u1eabu, h\u00e0m\u00a0<strong>COUNTIF<\/strong>\u00a0\u0111\u01a1n gi\u1ea3n s\u1ebd gi\u1ea3i quy\u1ebft v\u1ea5n \u0111\u1ec1:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-30422 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ly-thuyet-thong-ke-3.png\" alt=\"huong-dan-su-dung-excel-giai-quyet-bai-toan-thong-ke-don-gian-3\" width=\"667\" height=\"281\" title=\"ly-thuyet-thong-ke-3\"><\/p>\n<p>Ngo\u00e0i ra, ta c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/chuc-nang-va-cu-phap-ham-frequency-trong-excel.html\"><strong>h\u00e0m FREQUENCY t\u00ednh s\u1ed1 l\u1ea7n xu\u1ea5t hi\u1ec7n c\u1ee7a gi\u00e1 tr\u1ecb trong m\u1ea3ng<\/strong><\/a><\/p>\n<p><strong>T\u1ea7n su\u1ea5t (Relative Frequency)\u00a0<\/strong>cho th\u1ea5y t\u1ec9 l\u1ec7 xu\u1ea5t hi\u1ec7n c\u1ee7a gi\u00e1 tr\u1ecb X. B\u1eb1ng c\u00e1ch l\u1ea5y t\u1ea7n s\u1ed1 \u0111\u01a1n l\u1ebb c\u1ee7a t\u1eebng gi\u00e1 tr\u1ecb chia cho k\u00edch th\u01b0\u1edbc m\u1eabu, ta c\u00f3 th\u1ec3 t\u00ednh \u0111\u01b0\u1ee3c t\u1ea7n su\u1ea5t. C\u00f4ng th\u1ee9c trong h\u00ecnh:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-30423 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ly-thuyet-thong-ke-4.png\" alt=\"huong-dan-su-dung-excel-giai-quyet-bai-toan-thong-ke-don-gian-4\" width=\"703\" height=\"343\" title=\"ly-thuyet-thong-ke-4\"><\/p>\n<p>V\u1eady l\u00e0 ta \u0111\u00e3 gi\u1ea3i quy\u1ebft \u0111\u01b0\u1ee3c y\u00eau c\u1ea7u c\u01a1 b\u1ea3n nh\u1ea5t c\u1ee7a m\u1ed9t b\u00e0i to\u00e1n l\u00fd thuy\u1ebft th\u1ed1ng k\u00ea. Tuy nhi\u00ean \u0111\u1ec3 th\u1ec3 hi\u1ec7n d\u1eef li\u1ec7u m\u1ed9t c\u00e1ch tr\u1ef1c quan, ta s\u1ebd s\u1eed d\u1ee5ng bi\u1ec3u \u0111\u1ed3 \u0111i k\u00e8m.<\/p>\n<p>\u0110\u1ed1i v\u1edbi d\u1eef li\u1ec7u v\u1ec1 t\u1ea7n s\u1ed1 v\u00e0 t\u1ea7n su\u1ea5t, <a href=\"http:\/\/blog.ezworkapp.com\/gioi-thieu-ve-bieu-phan-tan-trong-excel.html\"><strong>bi\u1ec3u \u0111\u1ed3 ph\u00e2n t\u00e1n X Y (Scatter Diagram)<\/strong><\/a><\/p>\n<p><strong>Bi\u1ec3u \u0111\u1ed3 th\u1ec3 hi\u1ec7n t\u1ea7n s\u1ed1:<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-30426 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ly-thuyet-thong-ke-5.png\" alt=\"huong-dan-su-dung-excel-giai-quyet-bai-toan-thong-ke-don-gian-5\" width=\"502\" height=\"286\" title=\"ly-thuyet-thong-ke-5\"><\/p>\n<p><strong>Bi\u1ec3u \u0111\u1ed3 th\u1ec3 hi\u1ec7n t\u1ea7n su\u1ea5t:<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-30427 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ly-thuyet-thong-ke-6.png\" alt=\"huong-dan-su-dung-excel-giai-quyet-bai-toan-thong-ke-don-gian-6\" width=\"481\" height=\"289\" title=\"ly-thuyet-thong-ke-6\"><\/p>\n<p>\u00a0<\/p>\n<p>\u0110\u00e2y ch\u1ec9 l\u00e0 b\u01b0\u1edbc \u0111\u1ea7u trong qu\u00e1 tr\u00ecnh t\u00ednh to\u00e1n th\u1ed1ng k\u00ea. T\u1eeb nh\u1eefng con s\u1ed1 tr\u00ean ta c\u00f2n c\u00f3 th\u1ec3 \u0111\u01b0a ra <strong>h\u1ec7 s\u1ed1 t\u01b0\u01a1ng quan (<\/strong><span style=\"font-weight: 400\"><strong>correlation coefficient)<\/strong>,\u00a0<strong>dao \u0111\u1ed9ng d\u01b0 (Residuals)<\/strong>\u2026 Ch\u00fang ta s\u1ebd t\u00ecm hi\u1ec3u nh\u1eefng gi\u00e1 tr\u1ecb tr\u00ean trong nh\u1eefng b\u00e0i vi\u1ebft ti\u1ebfp theo.<\/span><\/p>\n<hr>\n<p>Ngo\u00e0i \u1ee9ng d\u1ee5ng Excel trong gi\u1ea3i b\u00e0i to\u00e1n l\u00fd thuy\u1ebft th\u1ed1ng k\u00ea \u0111\u01a1n gi\u1ea3n, c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o th\u00eam nh\u1eefng n\u1ed9i dung t\u01b0\u01a1ng t\u1ef1 sau:<\/p>\n<p><strong><a href=\"http:\/\/blog.ezworkapp.com\/flappy-bird-tren-scattered-chart-cua-excel.html\">FlappyBird tr\u00ean Scatter Chart trong Excel<\/a><\/strong><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-ve-duong-xu-trendline-trong-excel.html\"><strong>V\u1ebd \u0111\u01b0\u1eddng trendline trong Excel<\/strong><\/a><\/p>\n<p>\u00a0<\/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\/vba101-tu-dong-hoa-excel-voi-lap-trinh-vba-cho-nguoi-moi-bat-dau\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/vba101_92019-nho-322.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":7876,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-7875","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\/7875","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=7875"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/7875\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/7876"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=7875"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=7875"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=7875"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}