{"id":311574,"date":"2025-07-17T16:34:27","date_gmt":"2025-07-17T16:34:27","guid":{"rendered":"https:\/\/pocketoption.com\/blog\/news-events\/data\/how-to-calculate-variance-in-excel-2\/"},"modified":"2025-07-17T16:34:27","modified_gmt":"2025-07-17T16:34:27","slug":"how-to-calculate-variance-in-excel","status":"publish","type":"post","link":"https:\/\/pocketoption.com\/blog\/vt\/knowledge-base\/learning\/how-to-calculate-variance-in-excel\/","title":{"rendered":"C\u00e1ch T\u00ednh Ph\u01b0\u01a1ng Sai trong Excel"},"content":{"rendered":"<div id=\"root\"><div id=\"wrap-img-root\"><\/div><\/div>","protected":false},"excerpt":{"rendered":"","protected":false},"author":5,"featured_media":220498,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[17],"tags":[],"class_list":["post-311574","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-learning"],"acf":{"h1":"C\u00e1ch T\u00ednh Ph\u01b0\u01a1ng Sai trong Excel","h1_source":{"label":"H1","type":"text","formatted_value":"C\u00e1ch T\u00ednh Ph\u01b0\u01a1ng Sai trong Excel"},"description":"N\u1eafm v\u1eefng c\u00e1c b\u01b0\u1edbc \u0111\u1ec3 t\u00ednh to\u00e1n ph\u01b0\u01a1ng sai trong Excel m\u1ed9t c\u00e1ch hi\u1ec7u qu\u1ea3 v\u00e0 c\u1ea3i thi\u1ec7n k\u1ef9 n\u0103ng ph\u00e2n t\u00edch d\u1eef li\u1ec7u c\u1ee7a b\u1ea1n.","description_source":{"label":"Description","type":"textarea","formatted_value":"N\u1eafm v\u1eefng c\u00e1c b\u01b0\u1edbc \u0111\u1ec3 t\u00ednh to\u00e1n ph\u01b0\u01a1ng sai trong Excel m\u1ed9t c\u00e1ch hi\u1ec7u qu\u1ea3 v\u00e0 c\u1ea3i thi\u1ec7n k\u1ef9 n\u0103ng ph\u00e2n t\u00edch d\u1eef li\u1ec7u c\u1ee7a b\u1ea1n."},"intro":"Hi\u1ec3u v\u1ec1 ph\u01b0\u01a1ng sai l\u00e0 r\u1ea5t quan tr\u1ecdng \u0111\u1ed1i v\u1edbi b\u1ea5t k\u1ef3 ai tham gia v\u00e0o ph\u00e2n t\u00edch d\u1eef li\u1ec7u, v\u00ec n\u00f3 \u0111o l\u01b0\u1eddng m\u1ee9c \u0111\u1ed9 kh\u00e1c bi\u1ec7t c\u1ee7a c\u00e1c con s\u1ed1 trong m\u1ed9t t\u1eadp h\u1ee3p so v\u1edbi trung b\u00ecnh. Excel, m\u1ed9t c\u00f4ng c\u1ee5 \u0111a n\u0103ng cho vi\u1ec7c x\u1eed l\u00fd d\u1eef li\u1ec7u, l\u00e0m cho vi\u1ec7c t\u00ednh to\u00e1n ph\u01b0\u01a1ng sai tr\u1edf n\u00ean \u0111\u01a1n gi\u1ea3n. Cho d\u00f9 b\u1ea1n l\u00e0 sinh vi\u00ean, nh\u00e0 ph\u00e2n t\u00edch d\u1eef li\u1ec7u, hay ng\u01b0\u1eddi \u0111am m\u00ea giao d\u1ecbch, bi\u1ebft c\u00e1ch t\u00ednh to\u00e1n ph\u01b0\u01a1ng sai trong Excel c\u00f3 th\u1ec3 n\u00e2ng cao k\u1ef9 n\u0103ng ph\u00e2n t\u00edch d\u1eef li\u1ec7u c\u1ee7a b\u1ea1n, d\u1eabn \u0111\u1ebfn c\u00e1c quy\u1ebft \u0111\u1ecbnh th\u00f4ng minh h\u01a1n. Trong b\u00e0i vi\u1ebft n\u00e0y, ch\u00fang ta s\u1ebd kh\u00e1m ph\u00e1 c\u00e1c b\u01b0\u1edbc \u0111\u1ec3 t\u00ednh to\u00e1n ph\u01b0\u01a1ng sai trong Excel v\u00e0 th\u1ea3o lu\u1eadn v\u1ec1 c\u00e1ch ki\u1ebfn th\u1ee9c n\u00e0y c\u00f3 th\u1ec3 mang l\u1ea1i l\u1ee3i \u00edch cho giao d\u1ecbch nhanh v\u1edbi c\u00e1c n\u1ec1n t\u1ea3ng nh\u01b0 Pocket Option.","intro_source":{"label":"Intro","type":"text","formatted_value":"Hi\u1ec3u v\u1ec1 ph\u01b0\u01a1ng sai l\u00e0 r\u1ea5t quan tr\u1ecdng \u0111\u1ed1i v\u1edbi b\u1ea5t k\u1ef3 ai tham gia v\u00e0o ph\u00e2n t\u00edch d\u1eef li\u1ec7u, v\u00ec n\u00f3 \u0111o l\u01b0\u1eddng m\u1ee9c \u0111\u1ed9 kh\u00e1c bi\u1ec7t c\u1ee7a c\u00e1c con s\u1ed1 trong m\u1ed9t t\u1eadp h\u1ee3p so v\u1edbi trung b\u00ecnh. Excel, m\u1ed9t c\u00f4ng c\u1ee5 \u0111a n\u0103ng cho vi\u1ec7c x\u1eed l\u00fd d\u1eef li\u1ec7u, l\u00e0m cho vi\u1ec7c t\u00ednh to\u00e1n ph\u01b0\u01a1ng sai tr\u1edf n\u00ean \u0111\u01a1n gi\u1ea3n. Cho d\u00f9 b\u1ea1n l\u00e0 sinh vi\u00ean, nh\u00e0 ph\u00e2n t\u00edch d\u1eef li\u1ec7u, hay ng\u01b0\u1eddi \u0111am m\u00ea giao d\u1ecbch, bi\u1ebft c\u00e1ch t\u00ednh to\u00e1n ph\u01b0\u01a1ng sai trong Excel c\u00f3 th\u1ec3 n\u00e2ng cao k\u1ef9 n\u0103ng ph\u00e2n t\u00edch d\u1eef li\u1ec7u c\u1ee7a b\u1ea1n, d\u1eabn \u0111\u1ebfn c\u00e1c quy\u1ebft \u0111\u1ecbnh th\u00f4ng minh h\u01a1n. Trong b\u00e0i vi\u1ebft n\u00e0y, ch\u00fang ta s\u1ebd kh\u00e1m ph\u00e1 c\u00e1c b\u01b0\u1edbc \u0111\u1ec3 t\u00ednh to\u00e1n ph\u01b0\u01a1ng sai trong Excel v\u00e0 th\u1ea3o lu\u1eadn v\u1ec1 c\u00e1ch ki\u1ebfn th\u1ee9c n\u00e0y c\u00f3 th\u1ec3 mang l\u1ea1i l\u1ee3i \u00edch cho giao d\u1ecbch nhanh v\u1edbi c\u00e1c n\u1ec1n t\u1ea3ng nh\u01b0 Pocket Option."},"body_html":"<div class=\"custom-html-container\">\n<h2>T\u00ednh ph\u01b0\u01a1ng sai trong Excel<\/h2>\n\u0110\u1ec3 ph\u00e2n t\u00edch d\u1eef li\u1ec7u hi\u1ec7u qu\u1ea3, t\u00ednh ph\u01b0\u01a1ng sai l\u00e0 m\u1ed9t k\u1ef9 n\u0103ng c\u1ea7n thi\u1ebft. Excel \u0111\u01a1n gi\u1ea3n h\u00f3a qu\u00e1 tr\u00ecnh n\u00e0y, l\u00e0m cho n\u00f3 d\u1ec5 ti\u1ebfp c\u1eadn v\u1edbi ng\u01b0\u1eddi d\u00f9ng \u1edf m\u1ecdi c\u1ea5p \u0111\u1ed9.\n<h3>Hi\u1ec3u v\u1ec1 ph\u01b0\u01a1ng sai<\/h3>\nPh\u01b0\u01a1ng sai l\u00e0 m\u1ed9t ph\u00e9p \u0111o th\u1ed1ng k\u00ea m\u00f4 t\u1ea3 s\u1ef1 ph\u00e2n t\u00e1n gi\u1eefa c\u00e1c s\u1ed1 trong m\u1ed9t t\u1eadp d\u1eef li\u1ec7u. N\u00f3 ch\u1ec9 ra m\u1ee9c \u0111\u1ed9 kh\u00e1c bi\u1ec7t c\u1ee7a c\u00e1c s\u1ed1 so v\u1edbi gi\u00e1 tr\u1ecb trung b\u00ecnh. Ph\u01b0\u01a1ng sai cao h\u01a1n bi\u1ec3u th\u1ecb s\u1ef1 kh\u00e1c bi\u1ec7t l\u1edbn h\u01a1n gi\u1eefa c\u00e1c s\u1ed1, trong khi ph\u01b0\u01a1ng sai th\u1ea5p h\u01a1n c\u00f3 ngh\u0129a l\u00e0 ch\u00fang g\u1ea7n v\u1edbi gi\u00e1 tr\u1ecb trung b\u00ecnh h\u01a1n.\n<ul>\n \t<li>M\u1edf Excel v\u00e0 nh\u1eadp t\u1eadp d\u1eef li\u1ec7u c\u1ee7a b\u1ea1n v\u00e0o m\u1ed9t c\u1ed9t ho\u1eb7c h\u00e0ng. S\u1eafp x\u1ebfp d\u1eef li\u1ec7u c\u1ee7a b\u1ea1n \u0111\u1ec3 \u0111\u01a1n gi\u1ea3n h\u00f3a c\u00e1c ph\u00e9p t\u00ednh.<\/li>\n \t<li>Ch\u1ecdn m\u1ed9t \u00f4 tr\u1ed1ng \u0111\u1ec3 nh\u1eadp c\u00f4ng th\u1ee9c ph\u01b0\u01a1ng sai. \u00d4 n\u00e0y s\u1ebd hi\u1ec3n th\u1ecb k\u1ebft qu\u1ea3 c\u1ee7a b\u1ea1n.<\/li>\n \t<li>S\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c <code>=VAR.P(range)<\/code> cho ph\u01b0\u01a1ng sai t\u1ed5ng th\u1ec3 ho\u1eb7c <code>=VAR.S(range)<\/code> cho ph\u01b0\u01a1ng sai m\u1eabu. Thay th\u1ebf \"range\" b\u1eb1ng ph\u1ea1m vi \u00f4 c\u1ee7a b\u1ea1n, ch\u1eb3ng h\u1ea1n nh\u01b0 A1:A10.<\/li>\n \t<li>Nh\u1ea5n Enter \u0111\u1ec3 th\u1ef1c hi\u1ec7n c\u00f4ng th\u1ee9c. Excel s\u1ebd t\u00ednh to\u00e1n v\u00e0 hi\u1ec3n th\u1ecb ph\u01b0\u01a1ng sai.<\/li>\n \t<li>Xem x\u00e9t k\u1ebft qu\u1ea3 \u0111\u1ec3 hi\u1ec3u s\u1ef1 ph\u00e2n t\u00e1n d\u1eef li\u1ec7u. Th\u00f4ng tin n\u00e0y h\u1ed7 tr\u1ee3 trong vi\u1ec7c \u0111\u01b0a ra quy\u1ebft \u0111\u1ecbnh d\u1ef1a tr\u00ean d\u1eef li\u1ec7u.<\/li>\n<\/ul>\n<h2>\u1ee8ng d\u1ee5ng th\u1ef1c t\u1ebf c\u1ee7a ph\u01b0\u01a1ng sai<\/h2>\nHi\u1ec3u v\u00e0 t\u00ednh to\u00e1n ph\u01b0\u01a1ng sai kh\u00f4ng ch\u1ec9 l\u00e0 m\u1ed9t b\u00e0i t\u1eadp h\u1ecdc thu\u1eadt; n\u00f3 c\u00f3 c\u00e1c \u1ee9ng d\u1ee5ng th\u1ef1c t\u1ebf c\u00f3 th\u1ec3 n\u00e2ng cao qu\u00e1 tr\u00ecnh ra quy\u1ebft \u0111\u1ecbnh c\u1ee7a b\u1ea1n.\n<h3>Ph\u01b0\u01a1ng sai trong giao d\u1ecbch nhanh<\/h3>\nTrong giao d\u1ecbch nhanh, ch\u1eb3ng h\u1ea1n nh\u01b0 tr\u00ean n\u1ec1n t\u1ea3ng Pocket Option, ph\u00e2n t\u00edch ph\u01b0\u01a1ng sai c\u00f3 th\u1ec3 gi\u00fap \u0111\u00e1nh gi\u00e1 s\u1ef1 bi\u1ebfn \u0111\u1ed9ng c\u1ee7a t\u00e0i s\u1ea3n. Ph\u01b0\u01a1ng sai cao c\u00f3 th\u1ec3 ch\u1ec9 ra r\u1ee7i ro l\u1edbn h\u01a1n, trong khi ph\u01b0\u01a1ng sai th\u1ea5p cho th\u1ea5y s\u1ef1 \u1ed5n \u0111\u1ecbnh. B\u1eb1ng c\u00e1ch t\u00edch h\u1ee3p ph\u00e2n t\u00edch ph\u01b0\u01a1ng sai, c\u00e1c nh\u00e0 giao d\u1ecbch c\u00f3 th\u1ec3 \u0111i\u1ec1u ch\u1ec9nh chi\u1ebfn l\u01b0\u1ee3c c\u1ee7a h\u1ecd \u0111\u1ec3 c\u00e2n b\u1eb1ng r\u1ee7i ro v\u00e0 l\u1ee3i nhu\u1eadn m\u1ed9t c\u00e1ch hi\u1ec7u qu\u1ea3.\n\n[cta_button text=\"B\u1eaft \u0111\u1ea7u giao d\u1ecbch\"]\n\nS\u1ef1 th\u1eadt th\u00fa v\u1ecb: B\u1ea1n c\u00f3 bi\u1ebft r\u1eb1ng kh\u00e1i ni\u1ec7m ph\u01b0\u01a1ng sai l\u1ea7n \u0111\u1ea7u ti\u00ean \u0111\u01b0\u1ee3c gi\u1edbi thi\u1ec7u b\u1edfi nh\u00e0 th\u1ed1ng k\u00ea Ronald Fisher v\u00e0o \u0111\u1ea7u th\u1ebf k\u1ef7 20? C\u00f4ng tr\u00ecnh c\u1ee7a \u00f4ng \u0111\u00e3 \u0111\u1eb7t n\u1ec1n m\u00f3ng cho ph\u00e2n t\u00edch th\u1ed1ng k\u00ea hi\u1ec7n \u0111\u1ea1i.\n\n<\/div>","body_html_source":{"label":"Body HTML","type":"wysiwyg","formatted_value":"<div class=\"custom-html-container\">\n<h2>T\u00ednh ph\u01b0\u01a1ng sai trong Excel<\/h2>\n<p>\u0110\u1ec3 ph\u00e2n t\u00edch d\u1eef li\u1ec7u hi\u1ec7u qu\u1ea3, t\u00ednh ph\u01b0\u01a1ng sai l\u00e0 m\u1ed9t k\u1ef9 n\u0103ng c\u1ea7n thi\u1ebft. Excel \u0111\u01a1n gi\u1ea3n h\u00f3a qu\u00e1 tr\u00ecnh n\u00e0y, l\u00e0m cho n\u00f3 d\u1ec5 ti\u1ebfp c\u1eadn v\u1edbi ng\u01b0\u1eddi d\u00f9ng \u1edf m\u1ecdi c\u1ea5p \u0111\u1ed9.<\/p>\n<h3>Hi\u1ec3u v\u1ec1 ph\u01b0\u01a1ng sai<\/h3>\n<p>Ph\u01b0\u01a1ng sai l\u00e0 m\u1ed9t ph\u00e9p \u0111o th\u1ed1ng k\u00ea m\u00f4 t\u1ea3 s\u1ef1 ph\u00e2n t\u00e1n gi\u1eefa c\u00e1c s\u1ed1 trong m\u1ed9t t\u1eadp d\u1eef li\u1ec7u. N\u00f3 ch\u1ec9 ra m\u1ee9c \u0111\u1ed9 kh\u00e1c bi\u1ec7t c\u1ee7a c\u00e1c s\u1ed1 so v\u1edbi gi\u00e1 tr\u1ecb trung b\u00ecnh. Ph\u01b0\u01a1ng sai cao h\u01a1n bi\u1ec3u th\u1ecb s\u1ef1 kh\u00e1c bi\u1ec7t l\u1edbn h\u01a1n gi\u1eefa c\u00e1c s\u1ed1, trong khi ph\u01b0\u01a1ng sai th\u1ea5p h\u01a1n c\u00f3 ngh\u0129a l\u00e0 ch\u00fang g\u1ea7n v\u1edbi gi\u00e1 tr\u1ecb trung b\u00ecnh h\u01a1n.<\/p>\n<ul>\n<li>M\u1edf Excel v\u00e0 nh\u1eadp t\u1eadp d\u1eef li\u1ec7u c\u1ee7a b\u1ea1n v\u00e0o m\u1ed9t c\u1ed9t ho\u1eb7c h\u00e0ng. S\u1eafp x\u1ebfp d\u1eef li\u1ec7u c\u1ee7a b\u1ea1n \u0111\u1ec3 \u0111\u01a1n gi\u1ea3n h\u00f3a c\u00e1c ph\u00e9p t\u00ednh.<\/li>\n<li>Ch\u1ecdn m\u1ed9t \u00f4 tr\u1ed1ng \u0111\u1ec3 nh\u1eadp c\u00f4ng th\u1ee9c ph\u01b0\u01a1ng sai. \u00d4 n\u00e0y s\u1ebd hi\u1ec3n th\u1ecb k\u1ebft qu\u1ea3 c\u1ee7a b\u1ea1n.<\/li>\n<li>S\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c <code>=VAR.P(range)<\/code> cho ph\u01b0\u01a1ng sai t\u1ed5ng th\u1ec3 ho\u1eb7c <code>=VAR.S(range)<\/code> cho ph\u01b0\u01a1ng sai m\u1eabu. Thay th\u1ebf &#8220;range&#8221; b\u1eb1ng ph\u1ea1m vi \u00f4 c\u1ee7a b\u1ea1n, ch\u1eb3ng h\u1ea1n nh\u01b0 A1:A10.<\/li>\n<li>Nh\u1ea5n Enter \u0111\u1ec3 th\u1ef1c hi\u1ec7n c\u00f4ng th\u1ee9c. Excel s\u1ebd t\u00ednh to\u00e1n v\u00e0 hi\u1ec3n th\u1ecb ph\u01b0\u01a1ng sai.<\/li>\n<li>Xem x\u00e9t k\u1ebft qu\u1ea3 \u0111\u1ec3 hi\u1ec3u s\u1ef1 ph\u00e2n t\u00e1n d\u1eef li\u1ec7u. Th\u00f4ng tin n\u00e0y h\u1ed7 tr\u1ee3 trong vi\u1ec7c \u0111\u01b0a ra quy\u1ebft \u0111\u1ecbnh d\u1ef1a tr\u00ean d\u1eef li\u1ec7u.<\/li>\n<\/ul>\n<h2>\u1ee8ng d\u1ee5ng th\u1ef1c t\u1ebf c\u1ee7a ph\u01b0\u01a1ng sai<\/h2>\n<p>Hi\u1ec3u v\u00e0 t\u00ednh to\u00e1n ph\u01b0\u01a1ng sai kh\u00f4ng ch\u1ec9 l\u00e0 m\u1ed9t b\u00e0i t\u1eadp h\u1ecdc thu\u1eadt; n\u00f3 c\u00f3 c\u00e1c \u1ee9ng d\u1ee5ng th\u1ef1c t\u1ebf c\u00f3 th\u1ec3 n\u00e2ng cao qu\u00e1 tr\u00ecnh ra quy\u1ebft \u0111\u1ecbnh c\u1ee7a b\u1ea1n.<\/p>\n<h3>Ph\u01b0\u01a1ng sai trong giao d\u1ecbch nhanh<\/h3>\n<p>Trong giao d\u1ecbch nhanh, ch\u1eb3ng h\u1ea1n nh\u01b0 tr\u00ean n\u1ec1n t\u1ea3ng Pocket Option, ph\u00e2n t\u00edch ph\u01b0\u01a1ng sai c\u00f3 th\u1ec3 gi\u00fap \u0111\u00e1nh gi\u00e1 s\u1ef1 bi\u1ebfn \u0111\u1ed9ng c\u1ee7a t\u00e0i s\u1ea3n. Ph\u01b0\u01a1ng sai cao c\u00f3 th\u1ec3 ch\u1ec9 ra r\u1ee7i ro l\u1edbn h\u01a1n, trong khi ph\u01b0\u01a1ng sai th\u1ea5p cho th\u1ea5y s\u1ef1 \u1ed5n \u0111\u1ecbnh. B\u1eb1ng c\u00e1ch t\u00edch h\u1ee3p ph\u00e2n t\u00edch ph\u01b0\u01a1ng sai, c\u00e1c nh\u00e0 giao d\u1ecbch c\u00f3 th\u1ec3 \u0111i\u1ec1u ch\u1ec9nh chi\u1ebfn l\u01b0\u1ee3c c\u1ee7a h\u1ecd \u0111\u1ec3 c\u00e2n b\u1eb1ng r\u1ee7i ro v\u00e0 l\u1ee3i nhu\u1eadn m\u1ed9t c\u00e1ch hi\u1ec7u qu\u1ea3.<\/p>\n    <div class=\"po-container po-container_width_article\">\n        <a href=\"\/en\/quick-start\/\" class=\"po-line-banner po-article-page__line-banner\">\n            <svg class=\"svg-image po-line-banner__logo\" fill=\"currentColor\" width=\"auto\" height=\"auto\"\n                 aria-hidden=\"true\">\n                <use href=\"#svg-img-logo-white\"><\/use>\n            <\/svg>\n            <span class=\"po-line-banner__btn\">B\u1eaft \u0111\u1ea7u giao d\u1ecbch<\/span>\n        <\/a>\n    <\/div>\n    \n<p>S\u1ef1 th\u1eadt th\u00fa v\u1ecb: B\u1ea1n c\u00f3 bi\u1ebft r\u1eb1ng kh\u00e1i ni\u1ec7m ph\u01b0\u01a1ng sai l\u1ea7n \u0111\u1ea7u ti\u00ean \u0111\u01b0\u1ee3c gi\u1edbi thi\u1ec7u b\u1edfi nh\u00e0 th\u1ed1ng k\u00ea Ronald Fisher v\u00e0o \u0111\u1ea7u th\u1ebf k\u1ef7 20? C\u00f4ng tr\u00ecnh c\u1ee7a \u00f4ng \u0111\u00e3 \u0111\u1eb7t n\u1ec1n m\u00f3ng cho ph\u00e2n t\u00edch th\u1ed1ng k\u00ea hi\u1ec7n \u0111\u1ea1i.<\/p>\n<\/div>\n"},"faq":[{"question":"S\u1ef1 kh\u00e1c bi\u1ec7t gi\u1eefa VAR.P v\u00e0 VAR.S trong Excel l\u00e0:\n\n- VAR.P: H\u00e0m n\u00e0y \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 t\u00ednh to\u00e1n ph\u01b0\u01a1ng sai d\u1ef1a tr\u00ean to\u00e0n b\u1ed9 t\u1eadp h\u1ee3p d\u1eef li\u1ec7u. N\u00f3 gi\u1ea3 \u0111\u1ecbnh r\u1eb1ng d\u1eef li\u1ec7u b\u1ea1n c\u00f3 l\u00e0 to\u00e0n b\u1ed9 d\u00e2n s\u1ed1.\n\n- VAR.S: H\u00e0m n\u00e0y \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 t\u00ednh to\u00e1n ph\u01b0\u01a1ng sai d\u1ef1a tr\u00ean m\u1ed9t m\u1eabu c\u1ee7a t\u1eadp h\u1ee3p d\u1eef li\u1ec7u. N\u00f3 gi\u1ea3 \u0111\u1ecbnh r\u1eb1ng d\u1eef li\u1ec7u b\u1ea1n c\u00f3 ch\u1ec9 l\u00e0 m\u1ed9t m\u1eabu c\u1ee7a to\u00e0n b\u1ed9 d\u00e2n s\u1ed1.\n\nN\u00f3i c\u00e1ch kh\u00e1c, VAR.P \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng khi b\u1ea1n c\u00f3 t\u1ea5t c\u1ea3 d\u1eef li\u1ec7u c\u00f3 th\u1ec3 c\u00f3, trong khi VAR.S \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng khi b\u1ea1n ch\u1ec9 c\u00f3 m\u1ed9t ph\u1ea7n c\u1ee7a d\u1eef li\u1ec7u.","answer":"VAR.P t\u00ednh to\u00e1n ph\u01b0\u01a1ng sai cho to\u00e0n b\u1ed9 d\u00e2n s\u1ed1, trong khi VAR.S \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng cho m\u1ed9t m\u1eabu c\u1ee7a d\u00e2n s\u1ed1."},{"question":"L\u00e0m th\u1ebf n\u00e0o ph\u01b0\u01a1ng sai gi\u00fap \u00edch trong ph\u00e2n t\u00edch d\u1eef li\u1ec7u?","answer":"Ph\u01b0\u01a1ng sai cung c\u1ea5p c\u00e1i nh\u00ecn s\u00e2u s\u1eafc v\u1ec1 s\u1ef1 bi\u1ebfn \u0111\u1ed9ng d\u1eef li\u1ec7u, gi\u00fap c\u00e1c nh\u00e0 ph\u00e2n t\u00edch hi\u1ec3u r\u00f5 ph\u00e2n ph\u1ed1i d\u1eef li\u1ec7u v\u00e0 \u0111\u01b0a ra d\u1ef1 \u0111o\u00e1n c\u00f3 c\u01a1 s\u1edf."},{"question":"T\u1ea1i sao ph\u01b0\u01a1ng sai quan tr\u1ecdng trong giao d\u1ecbch?","answer":"Ph\u01b0\u01a1ng sai gi\u00fap c\u00e1c nh\u00e0 giao d\u1ecbch \u0111\u00e1nh gi\u00e1 s\u1ef1 bi\u1ebfn \u0111\u1ed9ng c\u1ee7a t\u00e0i s\u1ea3n, h\u1ed7 tr\u1ee3 trong vi\u1ec7c \u0111\u00e1nh gi\u00e1 r\u1ee7i ro v\u00e0 ph\u00e1t tri\u1ec3n chi\u1ebfn l\u01b0\u1ee3c."}],"faq_source":{"label":"FAQ","type":"repeater","formatted_value":[{"question":"S\u1ef1 kh\u00e1c bi\u1ec7t gi\u1eefa VAR.P v\u00e0 VAR.S trong Excel l\u00e0:\n\n- VAR.P: H\u00e0m n\u00e0y \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 t\u00ednh to\u00e1n ph\u01b0\u01a1ng sai d\u1ef1a tr\u00ean to\u00e0n b\u1ed9 t\u1eadp h\u1ee3p d\u1eef li\u1ec7u. N\u00f3 gi\u1ea3 \u0111\u1ecbnh r\u1eb1ng d\u1eef li\u1ec7u b\u1ea1n c\u00f3 l\u00e0 to\u00e0n b\u1ed9 d\u00e2n s\u1ed1.\n\n- VAR.S: H\u00e0m n\u00e0y \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 t\u00ednh to\u00e1n ph\u01b0\u01a1ng sai d\u1ef1a tr\u00ean m\u1ed9t m\u1eabu c\u1ee7a t\u1eadp h\u1ee3p d\u1eef li\u1ec7u. N\u00f3 gi\u1ea3 \u0111\u1ecbnh r\u1eb1ng d\u1eef li\u1ec7u b\u1ea1n c\u00f3 ch\u1ec9 l\u00e0 m\u1ed9t m\u1eabu c\u1ee7a to\u00e0n b\u1ed9 d\u00e2n s\u1ed1.\n\nN\u00f3i c\u00e1ch kh\u00e1c, VAR.P \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng khi b\u1ea1n c\u00f3 t\u1ea5t c\u1ea3 d\u1eef li\u1ec7u c\u00f3 th\u1ec3 c\u00f3, trong khi VAR.S \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng khi b\u1ea1n ch\u1ec9 c\u00f3 m\u1ed9t ph\u1ea7n c\u1ee7a d\u1eef li\u1ec7u.","answer":"VAR.P t\u00ednh to\u00e1n ph\u01b0\u01a1ng sai cho to\u00e0n b\u1ed9 d\u00e2n s\u1ed1, trong khi VAR.S \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng cho m\u1ed9t m\u1eabu c\u1ee7a d\u00e2n s\u1ed1."},{"question":"L\u00e0m th\u1ebf n\u00e0o ph\u01b0\u01a1ng sai gi\u00fap \u00edch trong ph\u00e2n t\u00edch d\u1eef li\u1ec7u?","answer":"Ph\u01b0\u01a1ng sai cung c\u1ea5p c\u00e1i nh\u00ecn s\u00e2u s\u1eafc v\u1ec1 s\u1ef1 bi\u1ebfn \u0111\u1ed9ng d\u1eef li\u1ec7u, gi\u00fap c\u00e1c nh\u00e0 ph\u00e2n t\u00edch hi\u1ec3u r\u00f5 ph\u00e2n ph\u1ed1i d\u1eef li\u1ec7u v\u00e0 \u0111\u01b0a ra d\u1ef1 \u0111o\u00e1n c\u00f3 c\u01a1 s\u1edf."},{"question":"T\u1ea1i sao ph\u01b0\u01a1ng sai quan tr\u1ecdng trong giao d\u1ecbch?","answer":"Ph\u01b0\u01a1ng sai gi\u00fap c\u00e1c nh\u00e0 giao d\u1ecbch \u0111\u00e1nh gi\u00e1 s\u1ef1 bi\u1ebfn \u0111\u1ed9ng c\u1ee7a t\u00e0i s\u1ea3n, h\u1ed7 tr\u1ee3 trong vi\u1ec7c \u0111\u00e1nh gi\u00e1 r\u1ee7i ro v\u00e0 ph\u00e1t tri\u1ec3n chi\u1ebfn l\u01b0\u1ee3c."}]}},"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v24.8 (Yoast SEO v27.2) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>C\u00e1ch T\u00ednh Ph\u01b0\u01a1ng Sai trong Excel<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/pocketoption.com\/blog\/vt\/knowledge-base\/learning\/how-to-calculate-variance-in-excel\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"C\u00e1ch T\u00ednh Ph\u01b0\u01a1ng Sai trong Excel\" \/>\n<meta property=\"og:url\" content=\"https:\/\/pocketoption.com\/blog\/vt\/knowledge-base\/learning\/how-to-calculate-variance-in-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Pocket Option blog\" \/>\n<meta property=\"article:published_time\" content=\"2025-07-17T16:34:27+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/pocketoption.com\/blog\/wp-content\/uploads\/2025\/04\/1742025062295-917501635-17.webp\" \/>\n\t<meta property=\"og:image:width\" content=\"1840\" \/>\n\t<meta property=\"og:image:height\" content=\"700\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/webp\" \/>\n<meta name=\"author\" content=\"Tatiana OK\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Tatiana OK\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/pocketoption.com\/blog\/vt\/knowledge-base\/learning\/how-to-calculate-variance-in-excel\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/pocketoption.com\/blog\/vt\/knowledge-base\/learning\/how-to-calculate-variance-in-excel\/\"},\"author\":{\"name\":\"Tatiana OK\",\"@id\":\"https:\/\/pocketoption.com\/blog\/vt\/#\/schema\/person\/7021606f7d6abf56a4dfe12af297820d\"},\"headline\":\"C\u00e1ch T\u00ednh Ph\u01b0\u01a1ng Sai trong Excel\",\"datePublished\":\"2025-07-17T16:34:27+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/pocketoption.com\/blog\/vt\/knowledge-base\/learning\/how-to-calculate-variance-in-excel\/\"},\"wordCount\":9,\"commentCount\":0,\"image\":{\"@id\":\"https:\/\/pocketoption.com\/blog\/vt\/knowledge-base\/learning\/how-to-calculate-variance-in-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/pocketoption.com\/blog\/wp-content\/uploads\/2025\/04\/1742025062295-917501635-17.webp\",\"articleSection\":[\"Learning\"],\"inLanguage\":\"vt-VT\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/pocketoption.com\/blog\/vt\/knowledge-base\/learning\/how-to-calculate-variance-in-excel\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/pocketoption.com\/blog\/vt\/knowledge-base\/learning\/how-to-calculate-variance-in-excel\/\",\"url\":\"https:\/\/pocketoption.com\/blog\/vt\/knowledge-base\/learning\/how-to-calculate-variance-in-excel\/\",\"name\":\"C\u00e1ch T\u00ednh Ph\u01b0\u01a1ng Sai trong Excel\",\"isPartOf\":{\"@id\":\"https:\/\/pocketoption.com\/blog\/vt\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/pocketoption.com\/blog\/vt\/knowledge-base\/learning\/how-to-calculate-variance-in-excel\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/pocketoption.com\/blog\/vt\/knowledge-base\/learning\/how-to-calculate-variance-in-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/pocketoption.com\/blog\/wp-content\/uploads\/2025\/04\/1742025062295-917501635-17.webp\",\"datePublished\":\"2025-07-17T16:34:27+00:00\",\"author\":{\"@id\":\"https:\/\/pocketoption.com\/blog\/vt\/#\/schema\/person\/7021606f7d6abf56a4dfe12af297820d\"},\"breadcrumb\":{\"@id\":\"https:\/\/pocketoption.com\/blog\/vt\/knowledge-base\/learning\/how-to-calculate-variance-in-excel\/#breadcrumb\"},\"inLanguage\":\"vt-VT\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/pocketoption.com\/blog\/vt\/knowledge-base\/learning\/how-to-calculate-variance-in-excel\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"vt-VT\",\"@id\":\"https:\/\/pocketoption.com\/blog\/vt\/knowledge-base\/learning\/how-to-calculate-variance-in-excel\/#primaryimage\",\"url\":\"https:\/\/pocketoption.com\/blog\/wp-content\/uploads\/2025\/04\/1742025062295-917501635-17.webp\",\"contentUrl\":\"https:\/\/pocketoption.com\/blog\/wp-content\/uploads\/2025\/04\/1742025062295-917501635-17.webp\",\"width\":1840,\"height\":700},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/pocketoption.com\/blog\/vt\/knowledge-base\/learning\/how-to-calculate-variance-in-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/pocketoption.com\/blog\/vt\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"C\u00e1ch T\u00ednh Ph\u01b0\u01a1ng Sai trong Excel\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/pocketoption.com\/blog\/vt\/#website\",\"url\":\"https:\/\/pocketoption.com\/blog\/vt\/\",\"name\":\"Pocket Option blog\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/pocketoption.com\/blog\/vt\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"vt-VT\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/pocketoption.com\/blog\/vt\/#\/schema\/person\/7021606f7d6abf56a4dfe12af297820d\",\"name\":\"Tatiana OK\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"vt-VT\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/0e5382d258c3e430c69c7fcf955c3ccdee2ae00777d8745ed09f129ffca77c26?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/0e5382d258c3e430c69c7fcf955c3ccdee2ae00777d8745ed09f129ffca77c26?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/0e5382d258c3e430c69c7fcf955c3ccdee2ae00777d8745ed09f129ffca77c26?s=96&d=mm&r=g\",\"caption\":\"Tatiana OK\"},\"url\":\"https:\/\/pocketoption.com\/blog\/vt\/author\/tatiana\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"C\u00e1ch T\u00ednh Ph\u01b0\u01a1ng Sai trong Excel","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/pocketoption.com\/blog\/vt\/knowledge-base\/learning\/how-to-calculate-variance-in-excel\/","og_locale":"en_US","og_type":"article","og_title":"C\u00e1ch T\u00ednh Ph\u01b0\u01a1ng Sai trong Excel","og_url":"https:\/\/pocketoption.com\/blog\/vt\/knowledge-base\/learning\/how-to-calculate-variance-in-excel\/","og_site_name":"Pocket Option blog","article_published_time":"2025-07-17T16:34:27+00:00","og_image":[{"width":1840,"height":700,"url":"https:\/\/pocketoption.com\/blog\/wp-content\/uploads\/2025\/04\/1742025062295-917501635-17.webp","type":"image\/webp"}],"author":"Tatiana OK","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Tatiana OK"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/pocketoption.com\/blog\/vt\/knowledge-base\/learning\/how-to-calculate-variance-in-excel\/#article","isPartOf":{"@id":"https:\/\/pocketoption.com\/blog\/vt\/knowledge-base\/learning\/how-to-calculate-variance-in-excel\/"},"author":{"name":"Tatiana OK","@id":"https:\/\/pocketoption.com\/blog\/vt\/#\/schema\/person\/7021606f7d6abf56a4dfe12af297820d"},"headline":"C\u00e1ch T\u00ednh Ph\u01b0\u01a1ng Sai trong Excel","datePublished":"2025-07-17T16:34:27+00:00","mainEntityOfPage":{"@id":"https:\/\/pocketoption.com\/blog\/vt\/knowledge-base\/learning\/how-to-calculate-variance-in-excel\/"},"wordCount":9,"commentCount":0,"image":{"@id":"https:\/\/pocketoption.com\/blog\/vt\/knowledge-base\/learning\/how-to-calculate-variance-in-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/pocketoption.com\/blog\/wp-content\/uploads\/2025\/04\/1742025062295-917501635-17.webp","articleSection":["Learning"],"inLanguage":"vt-VT","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/pocketoption.com\/blog\/vt\/knowledge-base\/learning\/how-to-calculate-variance-in-excel\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/pocketoption.com\/blog\/vt\/knowledge-base\/learning\/how-to-calculate-variance-in-excel\/","url":"https:\/\/pocketoption.com\/blog\/vt\/knowledge-base\/learning\/how-to-calculate-variance-in-excel\/","name":"C\u00e1ch T\u00ednh Ph\u01b0\u01a1ng Sai trong Excel","isPartOf":{"@id":"https:\/\/pocketoption.com\/blog\/vt\/#website"},"primaryImageOfPage":{"@id":"https:\/\/pocketoption.com\/blog\/vt\/knowledge-base\/learning\/how-to-calculate-variance-in-excel\/#primaryimage"},"image":{"@id":"https:\/\/pocketoption.com\/blog\/vt\/knowledge-base\/learning\/how-to-calculate-variance-in-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/pocketoption.com\/blog\/wp-content\/uploads\/2025\/04\/1742025062295-917501635-17.webp","datePublished":"2025-07-17T16:34:27+00:00","author":{"@id":"https:\/\/pocketoption.com\/blog\/vt\/#\/schema\/person\/7021606f7d6abf56a4dfe12af297820d"},"breadcrumb":{"@id":"https:\/\/pocketoption.com\/blog\/vt\/knowledge-base\/learning\/how-to-calculate-variance-in-excel\/#breadcrumb"},"inLanguage":"vt-VT","potentialAction":[{"@type":"ReadAction","target":["https:\/\/pocketoption.com\/blog\/vt\/knowledge-base\/learning\/how-to-calculate-variance-in-excel\/"]}]},{"@type":"ImageObject","inLanguage":"vt-VT","@id":"https:\/\/pocketoption.com\/blog\/vt\/knowledge-base\/learning\/how-to-calculate-variance-in-excel\/#primaryimage","url":"https:\/\/pocketoption.com\/blog\/wp-content\/uploads\/2025\/04\/1742025062295-917501635-17.webp","contentUrl":"https:\/\/pocketoption.com\/blog\/wp-content\/uploads\/2025\/04\/1742025062295-917501635-17.webp","width":1840,"height":700},{"@type":"BreadcrumbList","@id":"https:\/\/pocketoption.com\/blog\/vt\/knowledge-base\/learning\/how-to-calculate-variance-in-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/pocketoption.com\/blog\/vt\/"},{"@type":"ListItem","position":2,"name":"C\u00e1ch T\u00ednh Ph\u01b0\u01a1ng Sai trong Excel"}]},{"@type":"WebSite","@id":"https:\/\/pocketoption.com\/blog\/vt\/#website","url":"https:\/\/pocketoption.com\/blog\/vt\/","name":"Pocket Option blog","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/pocketoption.com\/blog\/vt\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"vt-VT"},{"@type":"Person","@id":"https:\/\/pocketoption.com\/blog\/vt\/#\/schema\/person\/7021606f7d6abf56a4dfe12af297820d","name":"Tatiana OK","image":{"@type":"ImageObject","inLanguage":"vt-VT","@id":"https:\/\/secure.gravatar.com\/avatar\/0e5382d258c3e430c69c7fcf955c3ccdee2ae00777d8745ed09f129ffca77c26?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/0e5382d258c3e430c69c7fcf955c3ccdee2ae00777d8745ed09f129ffca77c26?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/0e5382d258c3e430c69c7fcf955c3ccdee2ae00777d8745ed09f129ffca77c26?s=96&d=mm&r=g","caption":"Tatiana OK"},"url":"https:\/\/pocketoption.com\/blog\/vt\/author\/tatiana\/"}]}},"po_author":null,"po__editor":null,"po_last_edited":null,"wpml_current_locale":"vt_VT","wpml_translations":{"pt_AA":{"locale":"pt_AA","id":311569,"slug":"how-to-calculate-variance-in-excel","post_title":"Como Calcular a Vari\u00e2ncia no Excel","href":"https:\/\/pocketoption.com\/blog\/pt\/knowledge-base\/learning\/how-to-calculate-variance-in-excel\/"}},"_links":{"self":[{"href":"https:\/\/pocketoption.com\/blog\/vt\/wp-json\/wp\/v2\/posts\/311574","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/pocketoption.com\/blog\/vt\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/pocketoption.com\/blog\/vt\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/pocketoption.com\/blog\/vt\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/pocketoption.com\/blog\/vt\/wp-json\/wp\/v2\/comments?post=311574"}],"version-history":[{"count":0,"href":"https:\/\/pocketoption.com\/blog\/vt\/wp-json\/wp\/v2\/posts\/311574\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/pocketoption.com\/blog\/vt\/wp-json\/wp\/v2\/media\/220498"}],"wp:attachment":[{"href":"https:\/\/pocketoption.com\/blog\/vt\/wp-json\/wp\/v2\/media?parent=311574"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/pocketoption.com\/blog\/vt\/wp-json\/wp\/v2\/categories?post=311574"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/pocketoption.com\/blog\/vt\/wp-json\/wp\/v2\/tags?post=311574"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}