{"id":222380,"date":"2024-02-06T06:30:00","date_gmt":"2024-02-06T06:30:00","guid":{"rendered":"https:\/\/datascientest.com\/?p=222380"},"modified":"2024-07-11T12:37:51","modified_gmt":"2024-07-11T12:37:51","slug":"regression-lineaire-avec-excel","status":"publish","type":"post","link":"https:\/\/datascientest.com\/regression-lineaire-avec-excel","title":{"rendered":"La r\u00e9gression lin\u00e9aire avec Excel : Guide complet"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"222380\" class=\"elementor elementor-222380\" data-elementor-post-type=\"post\">\n\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-b5c03d8 e-flex e-con-boxed e-con\" data-id=\"b5c03d8\" 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-4034ad4 elementor-widget elementor-widget-heading\" data-id=\"4034ad4\" 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\">Parmi les concepts statistiques \u00e0 ma\u00eetriser absolument pour concevoir des analyses pr\u00e9dictives et des mod\u00e8les d\u2019apprentissage automatique, il y a la r\u00e9gression lin\u00e9aire.<\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-22f4bff elementor-widget elementor-widget-text-editor\" data-id=\"22f4bff\" 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;\">S\u2019il s\u2019agit d\u2019une des bases math\u00e9matiques \u00e0 conna\u00eetre, son calcul peut s\u2019av\u00e9rer plus ou moins complexe. Heureusement, il existe diff\u00e9rents outils permettant de rendre vos pr\u00e9dictions beaucoup plus fiables. C\u2019est notamment le cas du <\/span><b>calcul de la r\u00e9gression lin\u00e9aire avec Excel. <\/b><span style=\"font-weight: 400;\">Alors comment faire ? DataScientest vous explique toutes les \u00e9tapes \u00e0 suivre.<\/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-0d6e505 e-flex e-con-boxed e-con\" data-id=\"0d6e505\" 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-5a3663f elementor-widget elementor-widget-heading\" data-id=\"5a3663f\" 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\">C\u2019est quoi la r\u00e9gression lin\u00e9aire ?<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-30bb2fd elementor-widget elementor-widget-text-editor\" data-id=\"30bb2fd\" 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;\">Avant de voir comment fonctionne la r\u00e9gression lin\u00e9aire avec Excel, il convient de comprendre la <a href=\"https:\/\/datascientest.com\/regression-logistique-quest-ce-que-cest\">r\u00e9gression lin\u00e9aire<\/a>. Un petit rappel s\u2019impose !<\/span><\/p><p><span style=\"font-weight: 400;\">Concr\u00e8tement, la r\u00e9gression lin\u00e9aire permet d<\/span><b>\u2019analyser la relation entre une variable ind\u00e9pendante <\/b><span style=\"font-weight: 400;\">(ou variable explicative)<\/span><b> et une variable d\u00e9pendante<\/b><span style=\"font-weight: 400;\"> (ou variable recherch\u00e9e). Cette technique statistique se manifeste comme suit :<\/span><\/p><p style=\"padding-left: 40px;\"><b>Y = aX + b<\/b><\/p><p><span style=\"font-weight: 400;\">o\u00f9 :<\/span><\/p><ul><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Y= la variable d\u00e9pendante que vous essayez de pr\u00e9dire.<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">X= la variable ind\u00e9pendante permettant d\u2019expliquer Y.<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">a = le coefficient de pente qui repr\u00e9sente la fa\u00e7on dont Y change en fonction de X.<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">b = l&rsquo;ordonn\u00e9e \u00e0 l&rsquo;origine, qui est la valeur de Y lorsque X est \u00e9gal \u00e0 z\u00e9ro.<\/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-e767c7b elementor-widget elementor-widget-text-editor\" data-id=\"e767c7b\" 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\u2019objectif est de<\/span><b> cr\u00e9er un mod\u00e8le pouvant \u00eatre utilis\u00e9 afin de faire des pr\u00e9dictions sur la variable d\u00e9pendante en fonction des valeurs de la variable explicative.\u00a0<\/b><\/p><p><span style=\"font-weight: 400;\">Si la r\u00e9gression lin\u00e9aire permet toujours d\u2019expliquer une variable d\u00e9pendante, elle peut utiliser une seule variable ind\u00e9pendante (c\u2019est la r\u00e9gression lin\u00e9aire simple) ou plusieurs variables ind\u00e9pendantes (c\u2019est la r\u00e9gression lin\u00e9aire multiple).<\/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-992b69e elementor-widget elementor-widget-image\" data-id=\"992b69e\" 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=\"820\" height=\"500\" src=\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/11\/regression-lineaire-excel-1.jpg\" class=\"attachment-full size-full wp-image-222395\" alt=\"\" srcset=\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/11\/regression-lineaire-excel-1.jpg 820w, https:\/\/datascientest.com\/wp-content\/uploads\/2023\/11\/regression-lineaire-excel-1-300x183.jpg 300w, https:\/\/datascientest.com\/wp-content\/uploads\/2023\/11\/regression-lineaire-excel-1-768x468.jpg 768w\" sizes=\"(max-width: 820px) 100vw, 820px\" \/>\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-0deb8ba elementor-align-center button-principale elementor-widget elementor-widget-button\" data-id=\"0deb8ba\" 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-power-bi\">\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\">Se former en analyse de donn\u00e9es<\/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-7f27118 e-flex e-con-boxed e-con\" data-id=\"7f27118\" 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-0b97307 elementor-widget elementor-widget-heading\" data-id=\"0b97307\" 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 utiliser la r\u00e9gression lin\u00e9aire avec Excel ?<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-019ddad elementor-widget elementor-widget-text-editor\" data-id=\"019ddad\" 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;\">Il existe plusieurs fonctions pour calculer une r\u00e9gression lin\u00e9aire dans <a href=\"https:\/\/datascientest.com\/formation-excel\">Excel<\/a>. Elles vous permettent de calculer soit la r\u00e9gression multiple, soit la r\u00e9gression simple, soit les deux.\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-704b130 elementor-widget elementor-widget-heading\" data-id=\"704b130\" 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-medium\">La fonction DroiteReg<\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-c0235e5 elementor-widget elementor-widget-text-editor\" data-id=\"c0235e5\" 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;\">La fonction matricielle DroiteReg (ou Linest en anglais) peut \u00eatre utilis\u00e9e pour calculer<\/span><b> \u00e0 la fois la r\u00e9gression lin\u00e9aire simple ou la r\u00e9gression lin\u00e9aire multiple<\/b><span style=\"font-weight: 400;\"> sur Excel.\u00a0<\/span><\/p><p><span style=\"font-weight: 400;\">Voici la d\u00e9marche \u00e0 suivre :\u00a0<\/span><\/p><ul><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Identifiez vos valeurs d\u00e9pendantes Y et vos valeurs ind\u00e9pendantes X. Celles-ci doivent se trouver dans deux colonnes distinctes.\u00a0<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Cliquez sur la cellule o\u00f9 vous souhaitez afficher les r\u00e9sultats de la r\u00e9gression lin\u00e9aire avec Excel. Il peut s\u2019agir d\u2019une nouvelle feuille de calcul ou d\u2019une plage de cellules vides.<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Entrez la formule \u00ab\u00a0=DroiteReg(Y, X)\u00a0\u00bb o\u00f9 \u00ab\u00a0Y\u00a0\u00bb correspond \u00e0 la plage de cellules contenant les valeurs de la variable d\u00e9pendante (par exemple, les lignes 2 \u00e0 17 de la colonne A) et \u00ab\u00a0X\u00a0\u00bb correspond \u00e0 la plage de cellules contenant les valeurs de la variable ind\u00e9pendante (par exemple, les lignes 2 \u00e0 17 de la colonne B). Pour reprendre l\u2019exemple, vous devrez taper la formule \u00ab\u00a0=DroiteReg(A2:A17, B2:B17)\u00a0\u00bb<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Cliquez sur \u00ab\u00a0Entr\u00e9e\u00a0\u00bb.<\/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-675dd95 elementor-widget elementor-widget-text-editor\" data-id=\"675dd95\" 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 calcule automatiquement la r\u00e9gression lin\u00e9aire et affiche les r\u00e9sultats dans les cellules s\u00e9lectionn\u00e9es. Vous verrez alors<\/span><span style=\"font-weight: 400;\"> deux valeurs appara\u00eetre :<\/span><b> le coefficient de r\u00e9gression (la pente) et l\u2019ordonn\u00e9e \u00e0 l\u2019origine (intercept).<\/b><\/p><p><span style=\"font-weight: 400;\">Si vous souhaitez calculer une r\u00e9gression lin\u00e9aire multiple avec Excel, vous pouvez \u00e9galement utiliser cette formule. Dans ce cas, il suffira d\u2019ajouter les autres colonnes contenant les valeurs de la variable d\u00e9pendante en les s\u00e9parant par des virgules. Par exemple, si votre plage de cellules A peut s\u2019expliquer \u00e0 travers les valeurs contenues dans les colonnes B, C et D, votre formule ressemblera \u00e0 ceci : \u00ab\u00a0=DroiteReg(A2:A17,B2:B17,C2:C17,D2:D17)\u00a0\u00bb. <\/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-ebc741b elementor-widget elementor-widget-heading\" data-id=\"ebc741b\" 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-medium\">La fonction Tendance<\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-fb28f62 elementor-widget elementor-widget-text-editor\" data-id=\"fb28f62\" 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;\">La fonction Tendance (ou Trend en anglais) peut \u00eatre utilis\u00e9e pour calculer <\/span><b>uniquement la r\u00e9gression lin\u00e9aire simple<\/b><span style=\"font-weight: 400;\"> sur Excel. Dans ce cas, la manipulation est similaire \u00e0 la fonction DroiteReg. \u00c0 savoir :\u00a0<\/span><\/p><ul><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Cliquez sur la cellule o\u00f9 vous souhaitez afficher les r\u00e9sultats de la r\u00e9gression lin\u00e9aire avec Excel.<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Entrez la formule \u00ab\u00a0=Tendance(A2:A17, B2:B17)\u00a0\u00bb<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Cliquez sur \u00ab\u00a0Entr\u00e9e\u00a0\u00bb.<\/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-c8e90d0 elementor-widget elementor-widget-text-editor\" data-id=\"c8e90d0\" 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;\">Bien que la formule soit quasi identique \u00e0 la pr\u00e9c\u00e9dente, le r\u00e9sultat est diff\u00e9rent. En effet, la fonction tendance<\/span><b> n\u2019isole pas les param\u00e8tres de pente et d\u2019ordonn\u00e9e \u00e0 l\u2019origine. <\/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-789b44a elementor-widget elementor-widget-image\" data-id=\"789b44a\" 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=\"752\" height=\"600\" src=\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/11\/regression-lineaire-excel-2.jpg\" class=\"attachment-full size-full wp-image-222399\" alt=\"\" srcset=\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/11\/regression-lineaire-excel-2.jpg 752w, https:\/\/datascientest.com\/wp-content\/uploads\/2023\/11\/regression-lineaire-excel-2-300x239.jpg 300w\" sizes=\"(max-width: 752px) 100vw, 752px\" \/>\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-af5ca8d elementor-align-center button-principale elementor-widget elementor-widget-button\" data-id=\"af5ca8d\" 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-power-bi\">\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\">Apprendre \u00e0 utiliser une r\u00e9gression lin\u00e9aire<\/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<div class=\"elementor-element elementor-element-cd1996b elementor-widget elementor-widget-heading\" data-id=\"cd1996b\" 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-medium\">L\u2019option de r\u00e9gression<\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-45eb086 elementor-widget elementor-widget-text-editor\" data-id=\"45eb086\" 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\u2019option <a href=\"https:\/\/datascientest.com\/data-analysis-tout-savoir\">Analyse de Donn\u00e9es<\/a> disponible dans votre feuille de calcul Excel, vous permet d<\/span><b>\u2019obtenir des informations compl\u00e8tes pour la r\u00e9gression lin\u00e9aire<\/b><span style=\"font-weight: 400;\">. Voici les \u00e9tapes \u00e0 suivre :\u00a0<\/span><\/p><ul><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Rendez-vous dans l&rsquo;onglet \u00ab\u00a0Donn\u00e9es\u00a0\u00bb ;\u00a0<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Cliquez sur \u00ab\u00a0Analyse de donn\u00e9es\u00a0\u00bb dans le groupe \u00ab\u00a0Analyse\u00a0\u00bb.\u00a0<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">S\u00e9lectionnez la r\u00e9gression lin\u00e9aire.\u00a0<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Une bo\u00eete de dialogue \u00ab\u00a0Analyse de donn\u00e9es\u00a0\u00bb appara\u00eet. Ici, choisissez \u00ab\u00a0R\u00e9gression\u00a0\u00bb parmi les outils disponibles et renseignez les param\u00e8tres requis :\u00a0<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Dans la zone \u00ab\u00a0Variable d\u00e9pendante\u00a0\u00bb, indiquez la cellule contenant votre variable d\u00e9pendante (Y).<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Dans la zone \u00ab\u00a0Variable(s) ind\u00e9pendante(s)\u00a0\u00bb, indiquez les cellules contenant vos variables ind\u00e9pendantes (X). Si vous avez plusieurs variables ind\u00e9pendantes, s\u00e9parez-les par des virgules.<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Cochez la case \u00ab\u00a0Sortie de r\u00e9gression\u00a0\u00bb pour obtenir des informations suppl\u00e9mentaires sur l&rsquo;analyse, comme les r\u00e9sidus, les statistiques de l&rsquo;ajustement, etc.<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Cliquez sur OK.<\/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-9505956 elementor-widget elementor-widget-text-editor\" data-id=\"9505956\" 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 effectue alors l&rsquo;analyse de r\u00e9gression lin\u00e9aire et affiche les r\u00e9sultats dans la feuille de calcul ou la plage de cellules sp\u00e9cifi\u00e9es. \u00c0 travers cette option, vous verrez appara\u00eetre plusieurs informations suppl\u00e9mentaires, telles que les coefficients de r\u00e9gression, les valeurs de pente et d&rsquo;ordonn\u00e9e \u00e0 l&rsquo;origine, les statistiques de l&rsquo;ajustement, les valeurs de t, de p, 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-223070c elementor-widget elementor-widget-heading\" data-id=\"223070c\" 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-medium\">La repr\u00e9sentation graphique de la r\u00e9gression lin\u00e9aire avec Excel<\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-b862cf3 elementor-widget elementor-widget-text-editor\" data-id=\"b862cf3\" 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;\">Il est aussi possible de <\/span><b>repr\u00e9senter le mod\u00e8le lin\u00e9aire graphiquement avec Excel. <\/b><span style=\"font-weight: 400;\">Voici les \u00e9tapes \u00e0 suivre :\u00a0<\/span><\/p><ul><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">S\u00e9lectionnez l\u2019ensemble de vos donn\u00e9es ;\u00a0<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Cliquez sur \u00ab\u00a0Insertion\u00a0\u00bb, puis \u00ab\u00a0Graphique\u00a0\u00bb ;\u00a0<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Sur le <a href=\"https:\/\/datascientest.com\/scatter-plot\">graphique en nuage de points<\/a>, cliquez sur \u00ab\u00a0outils de graphique\u00a0\u00bb, puis \u00ab\u00a0ajouter un \u00e9l\u00e9ment au graphique\u00a0\u00bb afin de faire appara\u00eetre les titres des axes, le titre du graphique et une l\u00e9gende.\u00a0<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Pour tracer la droite lin\u00e9aire, faites un clic droit sur la courbe et cliquez sur \u00ab\u00a0ajouter une courbe de tendance\u00a0\u00bb.<\/span><\/li><li><span style=\"font-weight: 400;\">S\u00e9lectionner \u00ab\u00a0lin\u00e9aire\u00a0\u00bb, puis cocher \u00ab\u00a0afficher l\u2019\u00e9quation\u00a0\u00bb, puis \u00ab\u00a0afficher le <a href=\"https:\/\/datascientest.com\/coefficient-de-determination\">coefficient de d\u00e9termination\u00a0\u00bb<\/a>.<\/span><\/li><\/ul>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-d7e36ac e-flex e-con-boxed e-con\" data-id=\"d7e36ac\" 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-7950b79 elementor-widget elementor-widget-shortcode\" data-id=\"7950b79\" data-element_type=\"widget\" data-widget_type=\"shortcode.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-shortcode\">\t\t<div data-elementor-type=\"section\" data-elementor-id=\"245947\" class=\"elementor elementor-245947\" data-elementor-post-type=\"elementor_library\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-66b7eb0 e-flex e-con-boxed e-con\" data-id=\"66b7eb0\" 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-dbce002 elementor-widget elementor-widget-html\" data-id=\"dbce002\" data-element_type=\"widget\" data-widget_type=\"html.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<!DOCTYPE html>\n<html lang=\"fr\">\n<head>\n    <meta charset=\"UTF-8\">\n    <meta name=\"viewport\" content=\"width=device-width, initial-scale=1.0\">\n    <style>\n        .container {\n            background-color: #FFEDCC;\n            border-radius: 8px;\n            padding: 20px;\n            width: 80%;\n            max-width: 1000px;\n            margin: auto;\n            text-align: left;\n            box-sizing: border-box;\n        }\n        .icon {\n            width: 60px;\n            height: 70px;\n            vertical-align: middle;\n            margin-right: 10px;\n            margin-top: -10px; \/* Adjust this value to move the icon up or down *\/\n        }\n        .content {\n            font-size: 16px;\n            color: #000000;\n            margin: 10px 0;\n        }\n        .highlight {\n            font-weight: bold;\n        }\n        .link {\n            color: #4628DD;\n            text-decoration: none;\n        }\n        .button {\n            display: inline-block;\n            background-color: #4628DD;\n            color: #FFFFFF;\n            padding: 10px 20px;\n            border-radius: 5px;\n            text-align: center;\n            text-decoration: none;\n            font-size: 16px;\n            margin-top: 20px;\n        }\n        .elementor-heading-title {\n            font-family: \"Urbanist\", Sans-serif;\n            font-size: 28px;\n            font-weight: bold;\n            margin: 0;\n            display: inline-block;\n            vertical-align: middle;\n        }\n        @media (max-width: 600px) {\n            .container {\n                width: 90%;\n                padding: 10px;\n            }\n            .content {\n                font-size: 14px;\n            }\n            .button {\n                font-size: 14px;\n                padding: 8px 16px;\n            }\n        }\n    <\/style>\n<\/head>\n<body>\n    <div class=\"container\">\n        <div>\n            <img decoding=\"async\" src=\"https:\/\/datascientest.com\/wp-content\/uploads\/2024\/07\/ampoule-icon-dst-e1720618321133.png\" alt=\"icon\" class=\"icon\">\n            <p class=\"elementor-heading-title elementor-size-default\">Le saviez-vous ?<\/p>\n        <\/div>\n        <div class=\"content\">\n            Depuis sa cr\u00e9ation en 2017, DataScientest compte d\u00e9j\u00e0 plus de <span class=\"highlight\">15 000 alumni<\/span> !\n            Avec une note moyenne de <span class=\"highlight\">4.8\/5<\/span>, <a href=\"https:\/\/datascientest.com\/formations-data?utm_source=datascientest.com&utm_medium=internal&utm_campaign=banner_lsv&utm_content=link\" class=\"link\" target=\"_blank\" id=\"link-lsv\"><b>nos formations<\/b><\/a>\n            sont parmi les meilleures en Europe. Plus de <span class=\"highlight\">500 entreprises partenaires<\/span>,\n            dont plusieurs du CAC 40, font confiance \u00e0 DataScientest pour former leurs collaborateurs.\n        <\/div>\n        <div style=\"margin-top: 20px;\">\n            <a id=\"button_lsv\" class=\"elementor-button elementor-button-link\" href=\"https:\/\/datascientest.com\/formations-data?utm_source=datascientest.com&utm_medium=internal&utm_campaign=banner_lsv&utm_content=button\" target=\"_blank\">\n                <span class=\"elementor-button-content-wrapper\">\n                    <span class=\"elementor-button-text\">D\u00e9couvrir nos formations<\/span>\n                <\/span>\n            <\/a>\n        <\/div>\n    <\/div>\n<\/body>\n<\/html>\n\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<\/div>\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\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-80876ab e-flex e-con-boxed e-con\" data-id=\"80876ab\" 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-c0d8323 elementor-widget elementor-widget-heading\" data-id=\"c0d8323\" 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\">Ma\u00eetrisez Excel avec DataScientest <\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-9a51eec elementor-widget elementor-widget-text-editor\" data-id=\"9a51eec\" 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 analyser des donn\u00e9es, Microsoft Excel est l\u2019outil \u00e0 conna\u00eetre absolument. Il vous permet de r\u00e9aliser diff\u00e9rents calculs, tels que la r\u00e9gression lin\u00e9aire simple ou multiple\u2026\u00a0<\/span><\/p><p><span style=\"font-weight: 400;\">DataScientest vous propose justement sa <a href=\"https:\/\/datascientest.com\/formation-excel\">formation pour ma\u00eetriser Excel<\/a>.\u00a0<\/span><\/p><p><span style=\"font-weight: 400;\">Et si vous souhaitez d\u00e9velopper des <a href=\"https:\/\/datascientest.com\/machine-learning-clustering-focus-sur-algorithme-cah\">mod\u00e8les de Machine Learning<\/a> complexes, vous aurez aussi besoin de ma\u00eetriser les langages de programmation, comme <a href=\"https:\/\/datascientest.com\/langage-r-tout-savoir\">R<\/a>, <a href=\"https:\/\/datascientest.com\/python-tout-savoir\">Python<\/a>\u2026 Et justement, \u00e0 travers <a href=\"https:\/\/datascientest.com\/formation-data-scientist\">notre formation en data science<\/a>, vous pourrez ma\u00eetriser tous les outils indispensables \u00e0 l\u2019analyse de donn\u00e9es pr\u00e9dictive et \u00e0 l\u2019apprentissage automatique.<\/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-e715a54 elementor-widget elementor-widget-image\" data-id=\"e715a54\" 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=\"1082\" height=\"580\" src=\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/11\/regression-lineaire-excel-3.jpg\" class=\"attachment-full size-full wp-image-222404\" alt=\"\" srcset=\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/11\/regression-lineaire-excel-3.jpg 1082w, https:\/\/datascientest.com\/wp-content\/uploads\/2023\/11\/regression-lineaire-excel-3-300x161.jpg 300w, https:\/\/datascientest.com\/wp-content\/uploads\/2023\/11\/regression-lineaire-excel-3-1024x549.jpg 1024w, https:\/\/datascientest.com\/wp-content\/uploads\/2023\/11\/regression-lineaire-excel-3-768x412.jpg 768w\" sizes=\"(max-width: 1082px) 100vw, 1082px\" \/>\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-23f216d elementor-align-center button-principale elementor-widget elementor-widget-button\" data-id=\"23f216d\" 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=\"\/formations-data\">\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 nos formations en Data<\/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<div class=\"elementor-element elementor-element-eba2f35 elementor-widget elementor-widget-html\" data-id=\"eba2f35\" 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\": \"C\u2019est quoi la r\u00e9gression lin\u00e9aire ?\",\r\n    \"acceptedAnswer\": {\r\n      \"@type\": \"Answer\",\r\n      \"text\": \"Avant de voir comment fonctionne la r\u00e9gression lin\u00e9aire avec Excel, il convient de comprendre la r\u00e9gression lin\u00e9aire. Un petit rappel s\u2019impose ! Concr\u00e8tement, la r\u00e9gression lin\u00e9aire permet d\u2019analyser la relation entre une variable ind\u00e9pendante (ou variable explicative) et une variable d\u00e9pendante (ou variable recherch\u00e9e).\"\r\n    }\r\n  },{\r\n    \"@type\": \"Question\",\r\n    \"name\": \"Comment utiliser la r\u00e9gression lin\u00e9aire avec Excel ?\",\r\n    \"acceptedAnswer\": {\r\n      \"@type\": \"Answer\",\r\n      \"text\": \"Il existe plusieurs fonctions pour calculer une r\u00e9gression lin\u00e9aire dans Excel. Elles vous permettent de calculer soit la r\u00e9gression multiple, soit la r\u00e9gression simple, soit les deux.\r\n      La fonction DroiteReg : la fonction matricielle DroiteReg (ou Linest en anglais) peut \u00eatre utilis\u00e9e pour calculer \u00e0 la fois la r\u00e9gression lin\u00e9aire simple ou la r\u00e9gression lin\u00e9aire multiple sur Excel.\r\n      La fonction Tendance : la fonction Tendance (ou Trend en anglais) peut \u00eatre utilis\u00e9e pour calculer uniquement la r\u00e9gression lin\u00e9aire simple sur Excel. Dans ce cas, la manipulation est similaire \u00e0 la fonction DroiteReg.\r\n      L\u2019option de r\u00e9gression : L\u2019option Analyse de Donn\u00e9es disponible dans votre feuille de calcul Excel, vous permet d\u2019obtenir des informations compl\u00e8tes pour la r\u00e9gression lin\u00e9aire.\"\r\n    }\r\n  }]\r\n}\r\n<\/script>\r\n\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>Parmi les concepts statistiques \u00e0 ma\u00eetriser absolument pour concevoir des analyses pr\u00e9dictives et des mod\u00e8les d\u2019apprentissage automatique, il y a la r\u00e9gression lin\u00e9aire. S\u2019il s\u2019agit d\u2019une des bases math\u00e9matiques \u00e0 conna\u00eetre, son calcul peut s\u2019av\u00e9rer plus ou moins complexe. Heureusement, il existe diff\u00e9rents outils permettant de rendre vos pr\u00e9dictions beaucoup plus fiables. C\u2019est notamment le [&hellip;]<\/p>\n","protected":false},"author":78,"featured_media":222382,"comment_status":"open","ping_status":"open","sticky":false,"template":"elementor_theme","format":"standard","meta":{"content-type":"","inline_featured_image":false},"categories":[2497],"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>La r\u00e9gression lin\u00e9aire avec Excel : Guide complet<\/title>\n<meta name=\"description\" content=\"D\u00e9couvrez les m\u00e9thodes pour calculer la r\u00e9gression lin\u00e9aire avec Excel et r\u00e9alisez des analyses pr\u00e9dictives fiables et pertinentes.\" \/>\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\/regression-lineaire-avec-excel\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"La r\u00e9gression lin\u00e9aire avec Excel : Guide complet\" \/>\n<meta property=\"og:url\" content=\"https:\/\/datascientest.com\/regression-lineaire-avec-excel\" \/>\n<meta property=\"og:site_name\" content=\"Formation Data Science | DataScientest.com\" \/>\n<meta property=\"article:published_time\" content=\"2024-02-06T06:30:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-07-11T12:37:51+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/11\/regression_lineaire_excel.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=\"J\u00e9r\u00e9my Robert\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u00c9crit par\" \/>\n\t<meta name=\"twitter:data1\" content=\"J\u00e9r\u00e9my Robert\" \/>\n\t<meta name=\"twitter:label2\" content=\"Dur\u00e9e de lecture estim\u00e9e\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/datascientest.com\/regression-lineaire-avec-excel\",\"url\":\"https:\/\/datascientest.com\/regression-lineaire-avec-excel\",\"name\":\"La r\u00e9gression lin\u00e9aire avec Excel : Guide complet\",\"isPartOf\":{\"@id\":\"https:\/\/datascientest.com\/#website\"},\"datePublished\":\"2024-02-06T06:30:00+00:00\",\"dateModified\":\"2024-07-11T12:37:51+00:00\",\"author\":{\"@id\":\"https:\/\/datascientest.com\/#\/schema\/person\/7af2361c48e24e79a8aa2360e6e74925\"},\"description\":\"D\u00e9couvrez les m\u00e9thodes pour calculer la r\u00e9gression lin\u00e9aire avec Excel et r\u00e9alisez des analyses pr\u00e9dictives fiables et pertinentes.\",\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/datascientest.com\/regression-lineaire-avec-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\/7af2361c48e24e79a8aa2360e6e74925\",\"name\":\"J\u00e9r\u00e9my Robert\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/datascientest.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/11\/jeremyrobert.jpeg\",\"contentUrl\":\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/11\/jeremyrobert.jpeg\",\"caption\":\"J\u00e9r\u00e9my Robert\"},\"description\":\"J\u00e9r\u00e9my Robert est actuellement Directeur p\u00e9dagogique B2B chez DataScientest.com. Avant de rejoindre DataScientest, il a travaill\u00e9 en tant que Consultant Business Intelligence chez DEAPDATA, o\u00f9 il a g\u00e9r\u00e9 des projets dans les domaines de l'assurance, bancaire et industrie. Il a \u00e9galement \u00e9t\u00e9 Co-fondateur et pr\u00e9sident de Tripzer. En tant que consultant ind\u00e9pendant, J\u00e9r\u00e9my a propos\u00e9 des formations sur MicroStrategy pour divers niveaux professionnels. Il est dipl\u00f4m\u00e9 de l'Universit\u00e9 Paris Cit\u00e9 avec un Master MIAGE, combinant comp\u00e9tences en informatique et gestion.\",\"sameAs\":[\"https:\/\/www.linkedin.com\/in\/jeremyrobert1\/\",\"Data Science\"],\"url\":\"https:\/\/datascientest.com\/author\/jeremyrobert\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"La r\u00e9gression lin\u00e9aire avec Excel : Guide complet","description":"D\u00e9couvrez les m\u00e9thodes pour calculer la r\u00e9gression lin\u00e9aire avec Excel et r\u00e9alisez des analyses pr\u00e9dictives fiables et pertinentes.","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\/regression-lineaire-avec-excel","og_locale":"fr_FR","og_type":"article","og_title":"La r\u00e9gression lin\u00e9aire avec Excel : Guide complet","og_url":"https:\/\/datascientest.com\/regression-lineaire-avec-excel","og_site_name":"Formation Data Science | DataScientest.com","article_published_time":"2024-02-06T06:30:00+00:00","article_modified_time":"2024-07-11T12:37:51+00:00","og_image":[{"width":1200,"height":600,"url":"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/11\/regression_lineaire_excel.png","type":"image\/png"}],"author":"J\u00e9r\u00e9my Robert","twitter_card":"summary_large_image","twitter_misc":{"\u00c9crit par":"J\u00e9r\u00e9my Robert","Dur\u00e9e de lecture estim\u00e9e":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/datascientest.com\/regression-lineaire-avec-excel","url":"https:\/\/datascientest.com\/regression-lineaire-avec-excel","name":"La r\u00e9gression lin\u00e9aire avec Excel : Guide complet","isPartOf":{"@id":"https:\/\/datascientest.com\/#website"},"datePublished":"2024-02-06T06:30:00+00:00","dateModified":"2024-07-11T12:37:51+00:00","author":{"@id":"https:\/\/datascientest.com\/#\/schema\/person\/7af2361c48e24e79a8aa2360e6e74925"},"description":"D\u00e9couvrez les m\u00e9thodes pour calculer la r\u00e9gression lin\u00e9aire avec Excel et r\u00e9alisez des analyses pr\u00e9dictives fiables et pertinentes.","inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/datascientest.com\/regression-lineaire-avec-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\/7af2361c48e24e79a8aa2360e6e74925","name":"J\u00e9r\u00e9my Robert","image":{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/datascientest.com\/#\/schema\/person\/image\/","url":"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/11\/jeremyrobert.jpeg","contentUrl":"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/11\/jeremyrobert.jpeg","caption":"J\u00e9r\u00e9my Robert"},"description":"J\u00e9r\u00e9my Robert est actuellement Directeur p\u00e9dagogique B2B chez DataScientest.com. Avant de rejoindre DataScientest, il a travaill\u00e9 en tant que Consultant Business Intelligence chez DEAPDATA, o\u00f9 il a g\u00e9r\u00e9 des projets dans les domaines de l'assurance, bancaire et industrie. Il a \u00e9galement \u00e9t\u00e9 Co-fondateur et pr\u00e9sident de Tripzer. En tant que consultant ind\u00e9pendant, J\u00e9r\u00e9my a propos\u00e9 des formations sur MicroStrategy pour divers niveaux professionnels. Il est dipl\u00f4m\u00e9 de l'Universit\u00e9 Paris Cit\u00e9 avec un Master MIAGE, combinant comp\u00e9tences en informatique et gestion.","sameAs":["https:\/\/www.linkedin.com\/in\/jeremyrobert1\/","Data Science"],"url":"https:\/\/datascientest.com\/author\/jeremyrobert"}]}},"_links":{"self":[{"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/posts\/222380"}],"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\/78"}],"replies":[{"embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/comments?post=222380"}],"version-history":[{"count":0,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/posts\/222380\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/media\/222382"}],"wp:attachment":[{"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/media?parent=222380"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/categories?post=222380"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/tags?post=222380"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}