How to Get Regression Analysis in Excel

Running a regression analysis in Excel is a fantastic way to understand the relationships hidden within your data. Instead of guessing how your marketing spend affects sales or how website traffic influences sign-ups, regression gives you a concrete, mathematical model. This guide will walk you through two straightforward methods to perform regression analysis directly within Excel.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

What Is Regression Analysis, Exactly?

At its core, regression analysis helps you understand how a dependent variable (the main thing you're trying to predict or explain) changes when one or more independent variables (the factors you think have an influence) change.

Think of it like this: a marketing manager wants to know if spending more money on online ads leads to more website visitors. In this case:

• The Dependent Variable (Y) is "Website Visitors." It's the outcome she wants to measure.
• The Independent Variable (X) is "Ad Spend." It's the factor she controls and believes influences the outcome.

By running a regression, she can not only see if there’s a relationship but also predict how many extra visitors she might get for every additional $100 she spends on ads. When you use one independent variable, it's called simple regression. When you use two or more (like ad spend and email marketing subscribers), it’s called multiple regression.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Before You Start: Prepping Your Data for Analysis

Your results are only as good as your data. Before you begin, make sure your information is organized cleanly in Excel. Arrange your data in columns, with your dependent variable (Y) in one column and your independent variable(s) (X) in adjacent columns. Having clear headers for each column is also a great practice.

For our example, let's set up a simple table with monthly data:

Method 1: The Quick Visual with a Scatter Plot

If you need a fast, visual representation of the relationship between two variables, a scatter plot with a trendline is the perfect tool. It lets you see the connection at a glance and gives you the core components of the regression analysis.

Step 1: Create a Scatter Plot

1. Highlight the two columns of data you want to analyze, including the headers ("Monthly Ad Spend" and "Website Visitors").
2. Click on the Insert tab in the Excel ribbon.
3. In the Charts section, find the icon that looks like a set of dots and click on it. This is the Insert Scatter (X, Y) or Bubble Chart option.
4. Select the first and simple scatter plot option. Excel will immediately generate a chart showing your data points.

Step 2: Add a Trendline and View the Equation

Now, let's add the regression line and the important statistics.

1. Click anywhere on the chart. You'll see a green plus icon (Chart Elements) appear on the right side. Click it.
2. Check the box next to Trendline. A line will appear on your chart.
3. Click the small arrow to the right of Trendline and select More Options.... This will open up the "Format Trendline" pane.
4. In the pane, scroll down and check two important boxes:

Your chart will now have a straight line running through your data points, along with an equation like y = 1.84x + 693.33 and an R² value like R² = 0.9632.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

Step 3: What Does It All Mean?

So you have the visual, but what does the text on the chart tell you?

• The Equation (y = mx + b): In our example, y = 1.84x + 693.33 translates to Website Visitors = 1.84 * Ad Spend + 693.33.
• R-squared (R²): This value, also called the "coefficient of determination," is a number between 0 and 1 that tells you how much of the variation in your dependent variable is explained by your independent variable. Our R² of 0.9632 means that about 96.3% of the variation in website traffic can be explained by changes in ad spend. That's a very strong relationship! The closer to 1 (or 100%), the better the model fits your data.

Method 2: The Deep Dive with the Analysis ToolPak

For a more detailed statistical breakdown, including metrics like P-values that tell you if your results are statistically significant, you'll want to use Excel's Analysis ToolPak. It's built-in but usually needs to be activated first.

Step 1: Enable the Analysis ToolPak Add-in

If you've never used it, you'll need to turn it on one time. It's a quick process.

• For Windows: Go to File > Options > Add-ins. At the bottom, where it says "Manage:", choose Excel Add-ins and click Go.... In the dialog box, check Analysis ToolPak and click OK.
• For Mac: Go to Tools in the top menu bar, then click Excel Add-ins.... Check Analysis ToolPak and click OK.

You'll now see a "Data Analysis" button on the far right of the Data tab in your Excel ribbon.

Step 2: Run the Regression Analysis

1. Navigate to the Data tab and click on Data Analysis.
2. A dialog box will appear. Scroll down the list, select Regression, and click OK.
3. Now, you need to fill in a few fields:
4. Click OK.

Step 3: Interpreting the Key Numbers in a New Tab

Excel will generate a fairly intimidating table of statistics. Don't worry! You only need to focus on a few key values to start.

SUMMARY OUTPUT: Regression Statistics

• R Square: This is the same R² value from our chart method. It shows the proportion of variance explained by your model.
• Adjusted R Square: This is a slightly modified version of R-squared that's more accurate for multiple regression, as it accounts for the number of variables in the model.

ANOVA Block

• Significance F: Look at this value first. It tells you the overall statistical significance of your model. If this number is very small (typically less than 0.05), it suggests that your model has a high probability of being a valid predictor, not just something that occurred by chance.

Coefficients Block

This is where you find the components that build your predictive regression formula.

• Coefficients: These numbers are used to build your regression equation. The Intercept coefficient (693.33) is your baseline. The "Monthly Ad Spend" coefficient (1.84) is the slope — the impact your independent variable has. Your equation is the same as before: Website Visitors = 1.84 * Ad Spend + 693.33.
• P-value: This number tests the significance of each individual variable. A low P-value (typically < 0.05) means that the variable is a significant predictor of your dependent variable. In our example, the P-value for "Ad Spend" is extremely low (0.0003), confirming that it has a statistically significant impact on website traffic. The P-value for the intercept is a bit higher (0.081), but we usually focus more on the variables.

By combining the visual ease of a scatter plot with the statistical depth of the Analysis ToolPak, you can build a confident, data-backed understanding of the dynamics at play in your business.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Final Thoughts

Learning how to perform regression analysis transforms Excel from a simple data storage tool into a powerful predictive engine. Whether you're looking for a quick visual on a scatter plot or a deep statistical dive with the Analysis ToolPak, you now have the skills to uncover the drivers of your most important metrics.

While Excel is great for this, the process often starts with the tedious task of manually tracking down data and exporting CSVs from different platforms. This is where we built Graphed to simplify things. Since our platform connects directly to your marketing and sales tools like Google Analytics, Facebook Ads, or Shopify, all your data is in one place. You can simply ask a question like, "Show me how my ad spend impacts my revenue," and Graphed builds the analysis and visualizations instantly, with real-time data always feeding the report.