{"id":29130,"date":"2023-05-26T17:14:27","date_gmt":"2023-05-26T15:14:27","guid":{"rendered":"https:\/\/www.myexcelonline.com\/?p=29130"},"modified":"2024-03-22T18:33:03","modified_gmt":"2024-03-22T17:33:03","slug":"regression-in-excel","status":"publish","type":"post","link":"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/regression-in-excel\/","title":{"rendered":"6 Simple Steps for Conducting Regression in Excel"},"content":{"rendered":"<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/BA61B1BE-71B6-4E26-9B36-BF3B4831A022.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-29311 size-large\" title=\"6 Simple Steps for Conducting Regression in Excel\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/BA61B1BE-71B6-4E26-9B36-BF3B4831A022-1024x576.png\" alt=\"6 Simple Steps for Conducting Regression in Excel\" width=\"1024\" height=\"576\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/BA61B1BE-71B6-4E26-9B36-BF3B4831A022-1024x576.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/BA61B1BE-71B6-4E26-9B36-BF3B4831A022-300x169.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/BA61B1BE-71B6-4E26-9B36-BF3B4831A022-768x432.png 768w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/BA61B1BE-71B6-4E26-9B36-BF3B4831A022.png 1280w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/a><\/p>\n<p>Regression is a statistical method used to <strong>determine the strength of the relationship between dependent and independent variables<\/strong>. The main goal of this technique is to <strong>predict and forecast the dependent variable<\/strong> based on the value of independent variables.<\/p>\n<p>The dependent variable is the outcome variable that we are trying to predict and the independent variables are the ones that are used to make the prediction. We can easily run regression in <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/free-microsoft-excel-online-course\/\" target=\"_blank\" rel=\"noopener\">Excel<\/a> using the in-built regression tools to understand and interpret the relationship between the variables.<\/p>\n<p>Regression Analysis is a powerful tool used in <strong>various fields like economics, finance, healthcare, insurance<\/strong>, etc to understand the impact of independent variables on dependent variables.<\/p>\n<h4>In this article, we will be learning\u00a0 how to run Regression in Excel &#8211;<\/h4>\n<p>Let&#8217;s look at each one of these in detail!<\/p>\n<div class=\"om-placeholder\">\n<h4><\/h4>\n<h4>Download the Excel Workbook below to follow along and understand all about Regression Analysis &#8211;<\/h4>\n<\/div>\n<p><a class=\"IRPP_minimalist icon-download\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/Regression-in-Excel.xlsx\" target=\"_blank\"><span class=\"ctaText px-3 text-capitalize\"><strong>download excel workbook<\/strong><\/span><span class=\"postTitle px-3\">Regression-in-Excel.xlsx<\/span><\/a><\/p>\n<p>&nbsp;<\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_57_1 counter-flat ez-toc-counter ez-toc-transparent ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title \" >Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li><a href=\"#\" class=\"scroll-to-download\">Free Practice Workbook<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/regression-in-excel\/#What_is_Regression\" title=\"What is Regression?\">What is Regression?<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/regression-in-excel\/#Install_Data_Analysis\" title=\"Install Data Analysis\">Install Data Analysis<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/regression-in-excel\/#How_to_Run_Regression_in_Excel\" title=\"How to Run Regression in Excel?\">How to Run Regression in Excel?<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/regression-in-excel\/#Summary_Output\" title=\"Summary Output\">Summary Output<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/regression-in-excel\/#ANOVA\" title=\"ANOVA\">ANOVA<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/regression-in-excel\/#Regression_Coefficients\" title=\"Regression Coefficients\">Regression Coefficients<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/regression-in-excel\/#Create_Linear_Regression_Graph\" title=\"Create Linear Regression Graph\">Create Linear Regression Graph<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/regression-in-excel\/#Conclusion\" title=\"Conclusion\">Conclusion<\/a><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"What_is_Regression\"><\/span><span style=\"color: #ff6600;\"><strong><span id=\"1\">What is Regression?<\/span><\/strong><\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Regression is a<strong> statistical method used for the estimation of relationships<\/strong> between two variables &#8211; one dependent variable (Y) and one or more independent variables (X). It is used to determine how the <strong>value of Y changes with respect to the change in the value of X.<\/strong><\/p>\n<p>We try to<strong> regress the value of the dependent variable using the independent variables<\/strong>. Let&#8217;s understand this with the help of an <strong>example<\/strong> &#8211;<\/p>\n<p>Suppose we have the past data on the total<strong> monthly sales amount of a product and the amount spent on advertising the product<\/strong>. We can easily run a regression between the two variables to analyze whether there is a relationship between the two.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/Screenshot-276.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-29169\" title=\"6 Simple Steps for Conducting Regression in Excel\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/Screenshot-276.png\" alt=\"6 Simple Steps for Conducting Regression in Excel\" width=\"285\" height=\"555\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/Screenshot-276.png 285w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/Screenshot-276-154x300.png 154w\" sizes=\"(max-width: 285px) 100vw, 285px\" \/><\/a><\/p>\n<p>In this case, the independent variable (X) is the amount spent on advertising and the dependent variable (Y) is the total sales amount. We can also use regression to <strong>predict the future sales of the product based on the forecasted advertising amount.<\/strong><\/p>\n<p>&nbsp;<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Install_Data_Analysis\"><\/span><span style=\"color: #ff6600;\"><strong><span id=\"4\">Install Data Analysis<\/span><\/strong><\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Click on Data Tab in Excel Ribbon and look for Data Analysis. If not found, follow the steps below to install it &#8211;<\/p>\n<p><strong><span style=\"color: #ff0000;\">STEP 1:<\/span><\/strong> Go to <strong>Search Bar<\/strong> and type <strong>Add-Ins<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/Screenshot-257.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-29146\" title=\"6 Simple Steps for Conducting Regression in Excel\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/Screenshot-257.png\" alt=\"6 Simple Steps for Conducting Regression in Excel\" width=\"1323\" height=\"359\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/Screenshot-257.png 1323w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/Screenshot-257-300x81.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/Screenshot-257-1024x278.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/Screenshot-257-768x208.png 768w\" sizes=\"(max-width: 1323px) 100vw, 1323px\" \/><\/a><\/p>\n<p><strong><span style=\"color: #ff0000;\">STEP 2:<\/span><\/strong> Select <strong>Analysis ToolPak<\/strong> and Click <strong>OK<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/Screenshot-259.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-29147\" title=\"6 Simple Steps for Conducting Regression in Excel\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/Screenshot-259.png\" alt=\"6 Simple Steps for Conducting Regression in Excel\" width=\"286\" height=\"347\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/Screenshot-259.png 403w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/Screenshot-259-247x300.png 247w\" sizes=\"(max-width: 286px) 100vw, 286px\" \/><\/a><\/p>\n<p>You will now see Data Analysis in the Data Tab!<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/Screenshot-260.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-29151\" title=\"6 Simple Steps for Conducting Regression in Excel\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/Screenshot-260.png\" alt=\"6 Simple Steps for Conducting Regression in Excel\" width=\"1849\" height=\"224\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/Screenshot-260.png 1849w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/Screenshot-260-300x36.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/Screenshot-260-1024x124.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/Screenshot-260-768x93.png 768w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/Screenshot-260-1536x186.png 1536w\" sizes=\"(max-width: 1849px) 100vw, 1849px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<h2><span class=\"ez-toc-section\" id=\"How_to_Run_Regression_in_Excel\"><\/span><span style=\"color: #ff6600;\"><strong><span id=\"2\">How to Run Regression in Excel?<\/span><\/strong><\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><strong>Follow the steps<\/strong> below to run regression in Excel using in-built regression tools &#8211;<\/p>\n<p><strong><span style=\"color: #ff0000;\">STEP 1:<\/span><\/strong> Go to <strong>Data Tab<\/strong> &gt; <strong>Data Analysis<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/Screenshot-260.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-29151\" title=\"6 Simple Steps for Conducting Regression in Excel\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/Screenshot-260.png\" alt=\"6 Simple Steps for Conducting Regression in Excel\" width=\"1849\" height=\"224\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/Screenshot-260.png 1849w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/Screenshot-260-300x36.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/Screenshot-260-1024x124.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/Screenshot-260-768x93.png 768w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/Screenshot-260-1536x186.png 1536w\" sizes=\"(max-width: 1849px) 100vw, 1849px\" \/><\/a><\/p>\n<p><strong><span style=\"color: #ff0000;\">STEP 2:<\/span><\/strong> In the Data Analysis dialog box, click on <strong>Regression<\/strong> and then <strong>OK<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/Screenshot-263.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-29158\" title=\"6 Simple Steps for Conducting Regression in Excel\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/Screenshot-263.png\" alt=\"6 Simple Steps for Conducting Regression in Excel\" width=\"577\" height=\"250\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/Screenshot-263.png 577w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/Screenshot-263-300x130.png 300w\" sizes=\"(max-width: 577px) 100vw, 577px\" \/><\/a><\/p>\n<p><strong><span style=\"color: #ff0000;\">STEP 3:<\/span><\/strong> In the Regression dialog box, <strong>input the Y range i.e. the dependent variable<\/strong>. Here, it is the column containing the<strong> sales amount<\/strong> ($A$2:$A$19).<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/Screenshot-269.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-29160\" title=\"6 Simple Steps for Conducting Regression in Excel\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/Screenshot-269.png\" alt=\"6 Simple Steps for Conducting Regression in Excel\" width=\"1151\" height=\"577\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/Screenshot-269.png 1151w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/Screenshot-269-300x150.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/Screenshot-269-1024x513.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/Screenshot-269-768x385.png 768w\" sizes=\"(max-width: 1151px) 100vw, 1151px\" \/><\/a><\/p>\n<p><strong><span style=\"color: #ff0000;\">STEP 4:<\/span><\/strong> Input the <strong>X range i.e. the independent variable<\/strong>. Here, it is the column containing the <strong>advertising amount<\/strong> ($B$2:$B$19).<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/Screenshot-270.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-29161\" title=\"6 Simple Steps for Conducting Regression in Excel\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/Screenshot-270.png\" alt=\"6 Simple Steps for Conducting Regression in Excel\" width=\"1160\" height=\"600\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/Screenshot-270.png 1160w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/Screenshot-270-300x155.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/Screenshot-270-1024x530.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/Screenshot-270-768x397.png 768w\" sizes=\"(max-width: 1160px) 100vw, 1160px\" \/><\/a><\/p>\n<p><strong><span style=\"color: #ff0000;\">STEP 5:<\/span><\/strong> Input the <strong>output range<\/strong> i.e. the cell location where you want to display the output summary. Here, it is $D$1.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/Screenshot-271.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-29162\" title=\"6 Simple Steps for Conducting Regression in Excel\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/Screenshot-271.png\" alt=\"6 Simple Steps for Conducting Regression in Excel\" width=\"610\" height=\"477\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/Screenshot-271.png 610w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/Screenshot-271-300x235.png 300w\" sizes=\"(max-width: 610px) 100vw, 610px\" \/><\/a><\/p>\n<p><strong><span style=\"color: #ff0000;\">STEP 6:<\/span><\/strong> Check the <strong>Residuals<\/strong> box.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/Screenshot-272.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-29163\" title=\"6 Simple Steps for Conducting Regression in Excel\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/Screenshot-272.png\" alt=\"6 Simple Steps for Conducting Regression in Excel\" width=\"614\" height=\"476\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/Screenshot-272.png 614w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/Screenshot-272-300x233.png 300w\" sizes=\"(max-width: 614px) 100vw, 614px\" \/><\/a><\/p>\n<p>The output summary will now be displayed in the worksheet.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/Screenshot-273.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-29164 size-full\" title=\"6 Simple Steps for Conducting Regression in Excel\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/Screenshot-273.png\" alt=\"6 Simple Steps for Conducting Regression in Excel\" width=\"1241\" height=\"576\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/Screenshot-273.png 1241w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/Screenshot-273-300x139.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/Screenshot-273-1024x475.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/Screenshot-273-768x356.png 768w\" sizes=\"(max-width: 1241px) 100vw, 1241px\" \/><\/a><\/p>\n<p>Let&#8217;s understand this summary output in detail!<\/p>\n<p>&nbsp;<\/p>\n<h3><strong><span id=\"3\" style=\"color: #ff0000!important;\">Interpret the Results<\/span><\/strong><\/h3>\n<p>Once you run regression in Excel, all the calculations are performed and the result is displayed. It is important to understand the meaning of the terms used in the output to clearly interpret the result.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Summary_Output\"><\/span><span style=\"color: #ff6600;\"><strong>Summary Output<\/strong><\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>This tells us how well the linear regression fits the data source.<\/p>\n<p><strong>Multiple R &#8211; <\/strong>It tells us the <strong>strength of the relationship<\/strong> between the two variables. The larger the number, the stronger the relation. The value ranges from -1 to 1:<\/p>\n<ul>\n<li style=\"text-align: left;\"><strong>1<\/strong> indicates a strong positive relationship<\/li>\n<li style=\"text-align: left;\"><strong>-1<\/strong> indicates a strong negative relationship<\/li>\n<li style=\"text-align: left;\"><strong>0<\/strong> indicates no relation<\/li>\n<\/ul>\n<p>Here, the value is 0.916 which means that there is a strong positive relation between the sales amount and the amount spent on advertising.<\/p>\n<p><strong>R Square &#8211; <\/strong>It tells us how much of the variation of a dependent variable is explained by an independent variable in a regression. It is an indicator of the goodness of fit. Generally, an R square of 95% is considered as a good fit.<\/p>\n<p>In our example, the value is 0.84 which means 84% of the dependent variable is explained by the independent variable.<\/p>\n<p><strong>Adjusted R Square &#8211; <\/strong>This value is considered an adjusted value for R square when we are running a multiple regression.<\/p>\n<p><strong>Standard Error &#8211;<\/strong> It is another goodness of fit measure that tells us the precision of the regression analysis.<\/p>\n<p>&nbsp;<\/p>\n<h2><span class=\"ez-toc-section\" id=\"ANOVA\"><\/span><span style=\"color: #ff6600;\"><strong>ANOVA<\/strong><\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>This analysis of the variance table tells us about the level of variability within the regression model.<\/p>\n<ul>\n<li><strong>df<\/strong> is the degree of freedom associated with the source of variances.<\/li>\n<li><strong>SS<\/strong> is the sum of squares. The smaller the value, the better the model fits the <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/insert-a-pivot-chart-straight-from-data-source\/\" target=\"_blank\" rel=\"noopener\">source data<\/a>.<\/li>\n<li><strong>MS<\/strong> is the mean square.<\/li>\n<li><strong>F<\/strong> is the F-test for determining the overall significance of a regression model.<\/li>\n<li><strong>Significance f<\/strong> is the p-value for the F-test. It tells us if the results are statistically significant and reliable. Generally, if the value is less than 0.05 the model is good to go.<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Regression_Coefficients\"><\/span><span style=\"color: #ff6600;\"><strong>Regression Coefficients<\/strong><\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Based on these two values mentioned in the table, we can easily create a Regression Equation &#8211;<\/p>\n<p><strong>Y = Intercept + X * Coefficient<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/Screen-Shot-2023-05-26-at-4.14.32-AM.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-29350\" title=\"6 Simple Steps for Conducting Regression in Excel\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/Screen-Shot-2023-05-26-at-4.14.32-AM.png\" alt=\"6 Simple Steps for Conducting Regression in Excel\" width=\"422\" height=\"81\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/Screen-Shot-2023-05-26-at-4.14.32-AM.png 657w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/Screen-Shot-2023-05-26-at-4.14.32-AM-300x58.png 300w\" sizes=\"(max-width: 422px) 100vw, 422px\" \/><\/a><\/p>\n<p>After running the regression analysis, we have obtained the following results:<\/p>\n<ul>\n<li><strong>Intercept<\/strong> &#8211; 313.3<\/li>\n<li><strong> Coefficient<\/strong> &#8211; 7.2<\/li>\n<\/ul>\n<p>So, the Equation will be:<\/p>\n<p>Sales Amount = 313.3 + 7.2 * Advertising Amount<\/p>\n<p>Using this equation, we can<strong> predict the sales amount based on the forecasted amount that will be spent on advertisin<\/strong>g. If the<strong> forecasted value is 250<\/strong>, the sales amount will be &#8211;<\/p>\n<p>= 313.3+7.2*250<\/p>\n<p>=2113<\/p>\n<p>So, if we spend $250 on advertising then the sales amount should be around $2113.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/Screenshot-275.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-29168\" title=\"6 Simple Steps for Conducting Regression in Excel\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/Screenshot-275.png\" alt=\"6 Simple Steps for Conducting Regression in Excel\" width=\"427\" height=\"143\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/Screenshot-275.png 427w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/Screenshot-275-300x100.png 300w\" sizes=\"(max-width: 427px) 100vw, 427px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Create_Linear_Regression_Graph\"><\/span><span style=\"color: #ff6600;\"><strong><span id=\"5\">Create Linear Regression Graph<\/span><\/strong><\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>To visualize the relationship between the two variables using a regression graph, follow the steps mentioned below &#8211;<\/p>\n<p><strong><span style=\"color: #ff0000;\">STEP 1:<\/span><\/strong> Select the <strong>Data<\/strong> including the headers.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/Screenshot-276.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-29169\" title=\"6 Simple Steps for Conducting Regression in Excel\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/Screenshot-276.png\" alt=\"6 Simple Steps for Conducting Regression in Excel\" width=\"262\" height=\"510\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/Screenshot-276.png 285w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/Screenshot-276-154x300.png 154w\" sizes=\"(max-width: 262px) 100vw, 262px\" \/><\/a><\/p>\n<p><strong><span style=\"color: #ff0000;\">STEP 2:<\/span><\/strong> Go to <strong>Insert<\/strong> and select <strong>Scatter<\/strong> under the Charts section. Select an appropriate <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/xy-scatter-chart-related-variables\/\" target=\"_blank\" rel=\"noopener\">Scatter Chart<\/a> as required.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/Screenshot-277.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-29170\" title=\"6 Simple Steps for Conducting Regression in Excel\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/Screenshot-277.png\" alt=\"6 Simple Steps for Conducting Regression in Excel\" width=\"824\" height=\"432\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/Screenshot-277.png 957w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/Screenshot-277-300x157.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/Screenshot-277-768x403.png 768w\" sizes=\"(max-width: 824px) 100vw, 824px\" \/><\/a><\/p>\n<p>A <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/draw-a-logo-with-a-scatter-chart\/\" target=\"_blank\" rel=\"noopener\">Scatter Chart<\/a> will be added to the worksheet.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/Screenshot-278.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-29171\" title=\"6 Simple Steps for Conducting Regression in Excel\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/Screenshot-278.png\" alt=\"6 Simple Steps for Conducting Regression in Excel\" width=\"537\" height=\"341\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/Screenshot-278.png 683w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/Screenshot-278-300x191.png 300w\" sizes=\"(max-width: 537px) 100vw, 537px\" \/><\/a><\/p>\n<p><strong><span style=\"color: #ff0000;\">STEP 3:<\/span><\/strong> <strong>Right-click<\/strong> on any of the data points and select <strong>Add Trendline<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/Screenshot-279.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-29172\" title=\"6 Simple Steps for Conducting Regression in Excel\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/Screenshot-279.png\" alt=\"6 Simple Steps for Conducting Regression in Excel\" width=\"664\" height=\"368\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/Screenshot-279.png 824w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/Screenshot-279-300x166.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/Screenshot-279-768x426.png 768w\" sizes=\"(max-width: 664px) 100vw, 664px\" \/><\/a><\/p>\n<p><strong><span style=\"color: #ff0000;\">STEP 4:<\/span><\/strong> In the Format Trendline dialog box, select <strong>Linear<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/Screenshot-280-Copy.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-29173\" title=\"6 Simple Steps for Conducting Regression in Excel\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/Screenshot-280-Copy.png\" alt=\"6 Simple Steps for Conducting Regression in Excel\" width=\"286\" height=\"569\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/Screenshot-280-Copy.png 332w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/Screenshot-280-Copy-151x300.png 151w\" sizes=\"(max-width: 286px) 100vw, 286px\" \/><\/a><\/p>\n<p>A Regression Line will be added to the graph.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/Screenshot-280.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-29174\" title=\"6 Simple Steps for Conducting Regression in Excel\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/Screenshot-280.png\" alt=\"6 Simple Steps for Conducting Regression in Excel\" width=\"580\" height=\"364\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/Screenshot-280.png 704w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/05\/Screenshot-280-300x188.png 300w\" sizes=\"(max-width: 580px) 100vw, 580px\" \/><\/a><\/p>\n<p><a href=\"https:\/\/youtu.be\/rzR2Z97d16M\" target=\"_blank\" rel=\"nofollow noopener\"><strong>Click here<\/strong><\/a> for a definitive guide on How to Make a Graph in <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/free-excel-templates-and-spreadsheets\/\" target=\"_blank\" rel=\"noopener\">Excel<\/a>!<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Conclusion\"><\/span><span style=\"color: #ff6600;\">Conclusion<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><strong>Further Learning:<\/strong><\/p>\n<ul>\n<li><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/excel-chart-helper-infographic\/\" target=\"_blank\" rel=\"noopener\">Excel Chart Template Infographic<\/a><\/li>\n<li><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/project-milestone-chart-using-excel\/\" target=\"_blank\" rel=\"noopener\">Project Milestone Chart Using Excel<\/a><\/li>\n<li><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/create-sunburst-chart-excel-2016\/\" target=\"_blank\" rel=\"noopener\">Create an Excel Sunburst Chart With Excel 2016<\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Regression is a statistical method used to determine the strength of the relationship between dependent and independent variables. The main goal of this technique is to predict and forecast the dependent variable based on the value of independent variables. The dependent variable is the outcome variable that we are trying to predict and the independent [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":29311,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"cos_headline_score":0,"cos_seo_score":0,"cos_headline_text":"","cos_headline_has_been_analyzed":false,"cos_last_analyzed_headline":[],"om_disable_all_campaigns":false},"categories":[499],"tags":[1238,1239,1237],"acf":[],"_links":{"self":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/29130"}],"collection":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/comments?post=29130"}],"version-history":[{"count":0,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/29130\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media\/29311"}],"wp:attachment":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media?parent=29130"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/categories?post=29130"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/tags?post=29130"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}