{"id":190430,"date":"2023-02-21T15:11:55","date_gmt":"2023-02-21T15:11:55","guid":{"rendered":"https:\/\/datascientest.com\/?p=190430"},"modified":"2024-02-08T13:00:39","modified_gmt":"2024-02-08T13:00:39","slug":"ecart-type-excel","status":"publish","type":"post","link":"https:\/\/datascientest.com\/ecart-type-excel","title":{"rendered":"ECARTYPE sur Excel : \u00c0 quoi \u00e7a sert ? Comment le calculer ?"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"190430\" class=\"elementor elementor-190430\" data-elementor-post-type=\"post\">\n\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-99084be e-flex e-con-boxed e-con\" data-id=\"99084be\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-baf0398 elementor-widget elementor-widget-heading\" data-id=\"baf0398\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.15.0 - 02-08-2023 *\/\n.elementor-heading-title{padding:0;margin:0;line-height:1}.elementor-widget-heading .elementor-heading-title[class*=elementor-size-]>a{color:inherit;font-size:inherit;line-height:inherit}.elementor-widget-heading .elementor-heading-title.elementor-size-small{font-size:15px}.elementor-widget-heading .elementor-heading-title.elementor-size-medium{font-size:19px}.elementor-widget-heading .elementor-heading-title.elementor-size-large{font-size:29px}.elementor-widget-heading .elementor-heading-title.elementor-size-xl{font-size:39px}.elementor-widget-heading .elementor-heading-title.elementor-size-xxl{font-size:59px}<\/style><h2 class=\"elementor-heading-title elementor-size-default\">Pour analyser un ensemble de donn\u00e9es num\u00e9riques, c\u2019est souvent la moyenne qui est utilis\u00e9e. Mais ce param\u00e8tre pr\u00e9sente quelques insuffisances qui ne traduisent pas toujours la r\u00e9alit\u00e9 des donn\u00e9es. Heureusement, d\u2019autres outils statistiques permettent d\u2019approfondir l\u2019analyse. C\u2019est notamment le cas de l\u2019\u00e9cart type. Alors de quoi s\u2019agit-il ? \u00c0 quoi \u00e7a sert ? Et comment le calculer ? Les r\u00e9ponses sont ici.<\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-f502515 e-flex e-con-boxed e-con\" data-id=\"f502515\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-8097829 elementor-widget elementor-widget-heading\" data-id=\"8097829\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">\u00c0 quoi sert l\u2019\u00e9cart type ?<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-bd73c72 elementor-widget elementor-widget-text-editor\" data-id=\"bd73c72\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.15.0 - 02-08-2023 *\/\n.elementor-widget-text-editor.elementor-drop-cap-view-stacked .elementor-drop-cap{background-color:#69727d;color:#fff}.elementor-widget-text-editor.elementor-drop-cap-view-framed .elementor-drop-cap{color:#69727d;border:3px solid;background-color:transparent}.elementor-widget-text-editor:not(.elementor-drop-cap-view-default) .elementor-drop-cap{margin-top:8px}.elementor-widget-text-editor:not(.elementor-drop-cap-view-default) .elementor-drop-cap-letter{width:1em;height:1em}.elementor-widget-text-editor .elementor-drop-cap{float:left;text-align:center;line-height:1;font-size:50px}.elementor-widget-text-editor .elementor-drop-cap-letter{display:inline-block}<\/style>\t\t\t\t<p><span style=\"font-weight: 400;\">L\u2019\u00e9cart type est un <\/span><b>outil statistique permettant de mesurer la dispersion autour de la moyenne.<\/b><span style=\"font-weight: 400;\"> En effet, la moyenne ne refl\u00e8te pas toujours la r\u00e9alit\u00e9 d\u2019un ensemble de donn\u00e9es num\u00e9riques.\u00a0\u00a0<\/span><\/p><p><span style=\"font-weight: 400;\">Par exemple, une entreprise qui a une cible avec une moyenne d\u2019\u00e2ge de 35 ans peut repr\u00e9senter diff\u00e9rentes situations :\u00a0<\/span><\/p><ul><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Uniquement des clients ayant 35 ans.<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Ou des clients de tout \u00e2ge : 15, 25, 35, 45 et 55 ans. <\/span><\/li><\/ul>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-80fe634 elementor-widget elementor-widget-text-editor\" data-id=\"80fe634\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">Dans ce cadre, c\u2019est l\u2019\u00e9cart type, et non la moyenne, qui permet de pr\u00e9ciser les variations d\u2019\u00e2ge (ou non). Ainsi, dans la premi\u00e8re situation, l\u2019\u00e9cart type est de 0. C\u2019est-\u00e0-dire que la dispersion entre tous les clients par rapport \u00e0 la moyenne est nulle. En revanche, dans le second cas, l\u2019\u00e9cart type est de 20.\u00a0<\/span><\/p><p><span style=\"font-weight: 400;\">Il s\u2019agit \u00e9videmment d\u2019un exemple tr\u00e8s simpliste. Mais en r\u00e9alit\u00e9, l\u2019\u00e9cart type peut s\u2019appliquer pour une grande diversit\u00e9 de situations, telles que la d\u00e9finition du prix pour un lancement de produit, la comparaison du salaire des employ\u00e9s d\u2019une entreprise, etc. Pour les <a href=\"https:\/\/datascientest.com\/formation-data-analyst\">Data Analysts<\/a><\/span><span style=\"font-weight: 400;\">, cet outil statistique doit donc \u00eatre ma\u00eetris\u00e9. <\/span><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-bb12038 elementor-widget elementor-widget-image\" data-id=\"bb12038\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.15.0 - 02-08-2023 *\/\n.elementor-widget-image{text-align:center}.elementor-widget-image a{display:inline-block}.elementor-widget-image a img[src$=\".svg\"]{width:48px}.elementor-widget-image img{vertical-align:middle;display:inline-block}<\/style>\t\t\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"874\" height=\"542\" src=\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/02\/ecart-type-excel.jpg\" class=\"attachment-full size-full wp-image-190451\" alt=\"\" srcset=\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/02\/ecart-type-excel.jpg 874w, https:\/\/datascientest.com\/wp-content\/uploads\/2023\/02\/ecart-type-excel-300x186.jpg 300w, https:\/\/datascientest.com\/wp-content\/uploads\/2023\/02\/ecart-type-excel-768x476.jpg 768w\" sizes=\"(max-width: 874px) 100vw, 874px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-3081e7d elementor-align-center button-principale elementor-widget elementor-widget-button\" data-id=\"3081e7d\" data-element_type=\"widget\" data-widget_type=\"button.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-button-wrapper\">\n\t\t\t<a class=\"elementor-button elementor-button-link elementor-size-sm elementor-animation-grow\" href=\"https:\/\/datascientest.com\/formation-data-analyst\">\n\t\t\t\t\t\t<span class=\"elementor-button-content-wrapper\">\n\t\t\t\t\t\t<span class=\"elementor-button-text\">D\u00e9couvrir la formation Data Analyst<\/span>\n\t\t<\/span>\n\t\t\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-d2ff8e4 e-flex e-con-boxed e-con\" data-id=\"d2ff8e4\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-126aba6 elementor-widget elementor-widget-heading\" data-id=\"126aba6\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Comment calculer l\u2019\u00e9cart type ?<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-e790056 elementor-widget elementor-widget-heading\" data-id=\"e790056\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h4 class=\"elementor-heading-title elementor-size-default\">Le calcul de l\u2019\u00e9cart type<\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-9b305d3 elementor-widget elementor-widget-text-editor\" data-id=\"9b305d3\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">L\u2019\u00e9cart type correspond \u00e0 la <\/span><b>racine carr\u00e9e de la variance.<\/b><span style=\"font-weight: 400;\"> Il faut donc calculer la variance pour conna\u00eetre l\u2019\u00e9cart type d\u2019une moyenne.\u00a0<\/span><\/p><p><span style=\"font-weight: 400;\">La formule est la suivante :<\/span><\/p><p style=\"padding-left: 80px;\"><span class=\"katex-eq\" data-katex-display=\"false\">V=\\left( \\sum \\left( x_{i}-\\mu \\right) ^{2}\\right) \/N<\/span><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-4ef8d32 elementor-widget elementor-widget-text-editor\" data-id=\"4ef8d32\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">avec i repr\u00e9sentant la valeur de distribution, \u03bc la moyenne de la population et N la taille de la population.\u00a0<\/span><\/p><p><span style=\"font-weight: 400;\">\u00c9cart type =(V<\/span><span style=\"font-weight: 400;\">)\u00b2<\/span><span style=\"font-weight: 400;\">\u00a0<\/span><\/p><p><span style=\"font-weight: 400;\">Heureusement, il existe des m\u00e9thodes plus simples pour calculer l\u2019\u00e9cart type.\u00a0<\/span><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-825cc68 elementor-widget elementor-widget-heading\" data-id=\"825cc68\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h4 class=\"elementor-heading-title elementor-size-default\">L\u2019\u00e9cart type sur Excel<\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-6aa6533 elementor-widget elementor-widget-text-editor\" data-id=\"6aa6533\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">Excel vous propose plusieurs formules pour calculer l\u2019\u00e9cart type.\u00a0<\/span><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-b593c13 elementor-widget elementor-widget-heading\" data-id=\"b593c13\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h5 class=\"elementor-heading-title elementor-size-small\">\u00c9cart type P<\/h5>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-47d0037 elementor-widget elementor-widget-text-editor\" data-id=\"47d0037\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">Pour calculer l\u2019\u00e9cart type sur Excel, c\u2019est tr\u00e8s simple. Voici la d\u00e9marche \u00e0 suivre :\u00a0<\/span><\/p><ul><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">S\u00e9lectionnez une cellule vide ;\u00a0<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Tapez la formule : =ECARTTYPEP(plage de cellule \u00e0 analyser) ;<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Cliquez sur entr\u00e9e. <\/span><\/li><\/ul>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-738cdcd elementor-widget elementor-widget-text-editor\" data-id=\"738cdcd\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">Mais attention, avec cette formule, vous partez du postulat que <\/span><b>la plage s\u00e9lectionn\u00e9e repr\u00e9sente l\u2019ensemble des valeurs. <\/b><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-95f6633 elementor-widget elementor-widget-heading\" data-id=\"95f6633\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h5 class=\"elementor-heading-title elementor-size-small\">\u00c9cart type standard<\/h5>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-92e2249 elementor-widget elementor-widget-text-editor\" data-id=\"92e2249\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">Si <\/span><b>les donn\u00e9es ne repr\u00e9sentent qu\u2019un \u00e9chantillon de la population,<\/b><span style=\"font-weight: 400;\"> vous pouvez utiliser la formule \u00e9cart type standard.\u00a0<\/span><\/p><p><span style=\"font-weight: 400;\">La d\u00e9marche est quasiment identique :\u00a0<\/span><\/p><ul><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">S\u00e9lectionnez une cellule vide ;\u00a0<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Tapez la formule : =ECARTTYPE.STANDARD(plage de cellule \u00e0 analyser) ;\u00a0<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Cliquez sur entr\u00e9e.<\/span><\/li><\/ul>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-547a78d elementor-widget elementor-widget-text-editor\" data-id=\"547a78d\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">En plus de l\u2019\u00e9cart type, Excel vous permet de calculer le mode, la m\u00e9diane, la moyenne, l\u2019\u00e9tendue, le coefficient de variation, etc. <\/span><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-75ef147 elementor-widget elementor-widget-image\" data-id=\"75ef147\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"619\" height=\"395\" src=\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/02\/ecart-type-excel1.jpg\" class=\"attachment-full size-full wp-image-190452\" alt=\"\" srcset=\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/02\/ecart-type-excel1.jpg 619w, https:\/\/datascientest.com\/wp-content\/uploads\/2023\/02\/ecart-type-excel1-300x191.jpg 300w\" sizes=\"(max-width: 619px) 100vw, 619px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-f553cb5 elementor-align-center button-principale elementor-widget elementor-widget-button\" data-id=\"f553cb5\" data-element_type=\"widget\" data-widget_type=\"button.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-button-wrapper\">\n\t\t\t<a class=\"elementor-button elementor-button-link elementor-size-sm elementor-animation-grow\" href=\"https:\/\/datascientest.com\/formation-excel\">\n\t\t\t\t\t\t<span class=\"elementor-button-content-wrapper\">\n\t\t\t\t\t\t<span class=\"elementor-button-text\">D\u00e9marrer une formation Excel<\/span>\n\t\t<\/span>\n\t\t\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-d7ca956 e-flex e-con-boxed e-con\" data-id=\"d7ca956\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-4e57402 elementor-widget elementor-widget-heading\" data-id=\"4e57402\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Comment interpr\u00e9ter l\u2019\u00e9cart type ?<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-0a8af2e elementor-widget elementor-widget-text-editor\" data-id=\"0a8af2e\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">De mani\u00e8re g\u00e9n\u00e9rale, <\/span><b>plus l\u2019\u00e9cart type est faible, plus les valeurs sont concentr\u00e9es autour de la moyenne. <\/b><span style=\"font-weight: 400;\">Et inversement. \u00c0 ce titre, un \u00e9cart type sans moyenne n\u2019a pas forc\u00e9ment d&rsquo;int\u00e9r\u00eat. Dans le m\u00eame esprit, une moyenne sans \u00e9cart type n\u2019est pas toujours tr\u00e8s pertinente.<\/span><\/p><p><span style=\"font-weight: 400;\">Pour aller encore plus loin dans l\u2019interpr\u00e9tation de l\u2019\u00e9cart type, vous pouvez calculer le coefficient de variation. Cela permet ainsi d\u2019exprimer ce que repr\u00e9sente l\u2019\u00e9cart type dans la s\u00e9rie de donn\u00e9es.\u00a0<\/span><\/p><p><span style=\"font-weight: 400;\">La formule du coefficient de variation est : \u00e9cart type \/ moyenne. Sachez qu\u2019un \u00e9cart type commence \u00e0 \u00eatre fort d\u00e8s lors qu\u2019il repr\u00e9sente la moiti\u00e9 de la moyenne.\u00a0<\/span><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-60f67ad e-flex e-con-boxed e-con\" data-id=\"60f67ad\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-4fba814 elementor-widget elementor-widget-heading\" data-id=\"4fba814\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Ce qu\u2019il faut retenir<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-ca5ffde elementor-widget elementor-widget-text-editor\" data-id=\"ca5ffde\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<ul><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">L\u2019\u00e9cart type mesure la <strong>dispersion autour de la moyenne<\/strong>.\u00a0<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">L\u2019\u00e9cart type correspond \u00e0 <strong>la racine de la variance<\/strong>. Il faut donc calculer la variance pour conna\u00eetre cette mesure.\u00a0<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Mais le plus simple est d\u2019utiliser une formule sur Excel pour calculer l\u2019\u00e9cart type. <\/span><\/li><\/ul>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-25d0d87 e-flex e-con-boxed e-con\" data-id=\"25d0d87\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-2cd7fd9 elementor-widget elementor-widget-html\" data-id=\"2cd7fd9\" data-element_type=\"widget\" data-widget_type=\"html.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<script type=\"application\/ld+json\">\r\n{\r\n  \"@context\": \"https:\/\/schema.org\",\r\n  \"@type\": \"FAQPage\",\r\n  \"mainEntity\": [{\r\n    \"@type\": \"Question\",\r\n    \"name\": \"\u00c0 quoi sert l\u2019\u00e9cart type ?\",\r\n    \"acceptedAnswer\": {\r\n      \"@type\": \"Answer\",\r\n      \"text\": \"L\u2019\u00e9cart type est un outil statistique permettant de mesurer la dispersion autour de la moyenne. En effet, la moyenne ne refl\u00e8te pas toujours la r\u00e9alit\u00e9 d\u2019un ensemble de donn\u00e9es num\u00e9riques.\"\r\n    }\r\n  },{\r\n    \"@type\": \"Question\",\r\n    \"name\": \"Comment calculer l\u2019\u00e9cart type ?\",\r\n    \"acceptedAnswer\": {\r\n      \"@type\": \"Answer\",\r\n      \"text\": \"L\u2019\u00e9cart type correspond \u00e0 la racine carr\u00e9e de la variance. Il faut donc calculer la variance pour conna\u00eetre l\u2019\u00e9cart type d\u2019une moyenne.\"\r\n    }\r\n  }]\r\n}\r\n<\/script>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>Pour analyser un ensemble de donn\u00e9es num\u00e9riques, c\u2019est souvent la moyenne qui est utilis\u00e9e. Mais ce param\u00e8tre pr\u00e9sente quelques insuffisances qui ne traduisent pas toujours la r\u00e9alit\u00e9 des donn\u00e9es. Heureusement, d\u2019autres outils statistiques permettent d\u2019approfondir l\u2019analyse. C\u2019est notamment le cas de l\u2019\u00e9cart type. Alors de quoi s\u2019agit-il ? \u00c0 quoi \u00e7a sert ? Et comment [&hellip;]<\/p>\n","protected":false},"author":74,"featured_media":190431,"comment_status":"open","ping_status":"open","sticky":false,"template":"elementor_theme","format":"standard","meta":{"content-type":"","inline_featured_image":false},"categories":[2493],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.7 (Yoast SEO v21.7) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>ECARTYPE sur Excel : \u00c0 quoi \u00e7a sert ? Comment le calculer ?<\/title>\n<meta name=\"description\" content=\"Qu&#039;est-ce que l&#039;\u00c9cart Type ? \u00c0 quoi \u00e7a sert ? Et comment le calculer ? Les r\u00e9ponses sont ici.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/datascientest.com\/ecart-type-excel\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"ECARTYPE sur Excel : \u00c0 quoi \u00e7a sert ? Comment le calculer ?\" \/>\n<meta property=\"og:url\" content=\"https:\/\/datascientest.com\/ecart-type-excel\" \/>\n<meta property=\"og:site_name\" content=\"Formation Data Science | DataScientest.com\" \/>\n<meta property=\"article:published_time\" content=\"2023-02-21T15:11:55+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-02-08T13:00:39+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/02\/ecart-type.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"600\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Antoine Tardivon\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u00c9crit par\" \/>\n\t<meta name=\"twitter:data1\" content=\"Antoine Tardivon\" \/>\n\t<meta name=\"twitter:label2\" content=\"Dur\u00e9e de lecture estim\u00e9e\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/datascientest.com\/ecart-type-excel\",\"url\":\"https:\/\/datascientest.com\/ecart-type-excel\",\"name\":\"ECARTYPE sur Excel : \u00c0 quoi \u00e7a sert ? Comment le calculer ?\",\"isPartOf\":{\"@id\":\"https:\/\/datascientest.com\/#website\"},\"datePublished\":\"2023-02-21T15:11:55+00:00\",\"dateModified\":\"2024-02-08T13:00:39+00:00\",\"author\":{\"@id\":\"https:\/\/datascientest.com\/#\/schema\/person\/40cb5b6317e138be77b9dd23007cab57\"},\"description\":\"Qu'est-ce que l'\u00c9cart Type ? \u00c0 quoi \u00e7a sert ? Et comment le calculer ? Les r\u00e9ponses sont ici.\",\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/datascientest.com\/ecart-type-excel\"]}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/datascientest.com\/#website\",\"url\":\"https:\/\/datascientest.com\/\",\"name\":\"Formation Data Science | DataScientest.com\",\"description\":\"Leader de la formation en Data Science\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/datascientest.com\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"fr-FR\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/datascientest.com\/#\/schema\/person\/40cb5b6317e138be77b9dd23007cab57\",\"name\":\"Antoine Tardivon\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/datascientest.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/11\/antoine-tardivon.jpeg\",\"contentUrl\":\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/11\/antoine-tardivon.jpeg\",\"caption\":\"Antoine Tardivon\"},\"description\":\"Antoine Tardivon est Data Scientist chez DataScientest. Il a pr\u00e9c\u00e9demment effectu\u00e9 un stage en impl\u00e9mentation Python \u00e0 l'University of Helsinki et en recherche Machine Learning chez Thales. Dipl\u00f4m\u00e9 de l'Ecole centrale de Nantes et d'Audencia, il poss\u00e8de des comp\u00e9tences en ing\u00e9nierie et en finance.\",\"sameAs\":[\"https:\/\/www.linkedin.com\/in\/antoine-tardivon-385881204\/\",\"Business Intelligence\"],\"url\":\"https:\/\/datascientest.com\/author\/antoinetardivon\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"ECARTYPE sur Excel : \u00c0 quoi \u00e7a sert ? Comment le calculer ?","description":"Qu'est-ce que l'\u00c9cart Type ? \u00c0 quoi \u00e7a sert ? Et comment le calculer ? Les r\u00e9ponses sont ici.","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:\/\/datascientest.com\/ecart-type-excel","og_locale":"fr_FR","og_type":"article","og_title":"ECARTYPE sur Excel : \u00c0 quoi \u00e7a sert ? Comment le calculer ?","og_url":"https:\/\/datascientest.com\/ecart-type-excel","og_site_name":"Formation Data Science | DataScientest.com","article_published_time":"2023-02-21T15:11:55+00:00","article_modified_time":"2024-02-08T13:00:39+00:00","og_image":[{"width":1200,"height":600,"url":"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/02\/ecart-type.png","type":"image\/png"}],"author":"Antoine Tardivon","twitter_card":"summary_large_image","twitter_misc":{"\u00c9crit par":"Antoine Tardivon","Dur\u00e9e de lecture estim\u00e9e":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/datascientest.com\/ecart-type-excel","url":"https:\/\/datascientest.com\/ecart-type-excel","name":"ECARTYPE sur Excel : \u00c0 quoi \u00e7a sert ? Comment le calculer ?","isPartOf":{"@id":"https:\/\/datascientest.com\/#website"},"datePublished":"2023-02-21T15:11:55+00:00","dateModified":"2024-02-08T13:00:39+00:00","author":{"@id":"https:\/\/datascientest.com\/#\/schema\/person\/40cb5b6317e138be77b9dd23007cab57"},"description":"Qu'est-ce que l'\u00c9cart Type ? \u00c0 quoi \u00e7a sert ? Et comment le calculer ? Les r\u00e9ponses sont ici.","inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/datascientest.com\/ecart-type-excel"]}]},{"@type":"WebSite","@id":"https:\/\/datascientest.com\/#website","url":"https:\/\/datascientest.com\/","name":"Formation Data Science | DataScientest.com","description":"Leader de la formation en Data Science","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/datascientest.com\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"fr-FR"},{"@type":"Person","@id":"https:\/\/datascientest.com\/#\/schema\/person\/40cb5b6317e138be77b9dd23007cab57","name":"Antoine Tardivon","image":{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/datascientest.com\/#\/schema\/person\/image\/","url":"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/11\/antoine-tardivon.jpeg","contentUrl":"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/11\/antoine-tardivon.jpeg","caption":"Antoine Tardivon"},"description":"Antoine Tardivon est Data Scientist chez DataScientest. Il a pr\u00e9c\u00e9demment effectu\u00e9 un stage en impl\u00e9mentation Python \u00e0 l'University of Helsinki et en recherche Machine Learning chez Thales. Dipl\u00f4m\u00e9 de l'Ecole centrale de Nantes et d'Audencia, il poss\u00e8de des comp\u00e9tences en ing\u00e9nierie et en finance.","sameAs":["https:\/\/www.linkedin.com\/in\/antoine-tardivon-385881204\/","Business Intelligence"],"url":"https:\/\/datascientest.com\/author\/antoinetardivon"}]}},"_links":{"self":[{"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/posts\/190430"}],"collection":[{"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/users\/74"}],"replies":[{"embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/comments?post=190430"}],"version-history":[{"count":0,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/posts\/190430\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/media\/190431"}],"wp:attachment":[{"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/media?parent=190430"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/categories?post=190430"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/tags?post=190430"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}