08 Aug Regression Analysis 101: How to Find Out How Fast Your Blog Is Growing

Raise your hand if you are maniacal about monitoring your blog traffic.

Is your hand raised? Mine is, too. I check out traffic every day, sometimes multiple times a day. Most of the time, it’s great to be so in-the-weeds — if I notice a sudden dip in pageviews, I can quickly react.

Other times, it’s much more helpful to zoom out. With a bird’s-eye view, you can see patterns that are really important, like how fast your blog has been growing. Depending on that answer, you can better staff your team, fight for budget, and allocate resources.

One way to figure out how fast you’re growing is to run a regression analysis on your monthly traffic. (Even if you haven’t had a math class in years, I promise it’ll be fairly painless.)

Download this free guide and learn to design enticing charts and graphs that  are easy to understand.

In this post, we’ll explain what a regression analysis is, when you might use a multiple regression analysis, and how to figure out what your regression analysis is telling you. (Though the example we use is for blog growth specifically, you can run a regression analysis on many of the metrics you have in your business, too.)

As long as you have only one independent variable (ex: time), one dependent variable (ex: blog traffic), and a fairly large sample size, regression analyses can tell you a lot about your blog traffic growth.

To determine the relationship between two variables, we’ll find the best-fitting line for a set of data. This best-fitting line represents the general direction in which the data is going. To understand how fast your traffic is growing, you need to know the components of a regression analysis.

The Anatomy of a Regression Analysis

There are three different things you need to know about a regression to analyze it properly. Here’s what one looks like for reference:

Linear regression analysis of monthly blog traffic growth

1. Scatter plot

To run a regression analysis, first we need to plot our data points — and the best way to display the data is through a scatter plot. The X-axis is the independent variable, and the Y-axis is the dependent variable.

2. Best-fit line

We’ve already covered what a best-fit line actually means, but you should also know which types of lines you should look for. There are three major types of lines you should investigate:


This is a straight line — it means you’re growing steadily. You’re progressing at the same rate over time. Here’s what that line looks like:

Blue line graph depicting a linear regression analysis


This is a line that curves upward very quickly and doesn’t flatten out — you’re progressing at a faster and faster rate over time. Here’s what that line looks like:

Curved red trendline depicting an exponential regression analysis


This is a curved line that flattens over time — basically, you’re progressing at a slower and slower rate over time, and potentially reaching a “ceiling” where you wouldn’t expect to grow much more. Here’s what that line looks like:

Curved blue line depicting a logarithmic regression analysis

There are more types of lines than these, but these are the most important for you to know.

3. R²

R², or R squared, is a number between 0 and 1 that tells you how well the line fits the data set. The closer to 1, the better the line fits the data set — and to draw correlation conclusions from these graphs, you want to be fairly close to 1. So with an R² of 0.98, you can say that 98% of the variance in Y is explained by the variance in X.

Multiple Regression Analysis

Regression analyses don’t all just compare two variables to each other, though. If you have more than one independent variable (or “predictor”) affecting your data, you might want to see if each of them are individually influencing the trend you’re seeing. To do this, you’d need to run a multiple regression analysis.

A multiple regression analysis helps determine if a set of dependent variables have an influence on something’s performance. Think of it like multiple linear regression analyses, where you want to test the individual regression of two or more independent variables on the same dependent variable. For example …

  • In a linear regression analysis, your Y axis = blog traffic and your X axis = time.
  • In a multiple regression analysis, Y = blog traffic, X¹ = time, X² = paid advertising, and X³ = news articles.

How to Interpret Multiple Regression Analysis

In the first example above, you’d simply want to see if time has anything to do with the growth of your blog’s traffic. In the second example, you’d want to see if time, paid article promotions, and news articles each helped grow your blog traffic.

So, when analyzing blog growth, you’d start with one linear regression test in Excel between Y and X¹. Your Y value might be all traffic excluding traffic from X² (paid promotions) and X³ (news articles). Then, run a regression test to find your R², then another with traffic that includes X², and another with traffic that includes X³.

Scatter plot graph showing multiple regression analysis

Consider our original regression analysis graph at the beginning of this article. Now see it right above this paragraph, with additional plots. The red circle on the left could be traffic from paid article promotions, whereas the circle on the right could be traffic from news articles.

Either of these independent variables can change the R² value of your trendline, and suddenly there’s an exponential regression between your news articles and your total blog traffic.

To figure out how your traffic is trending, you basically need to run a regression analysis using each of the three lines mentioned above, and then compare their R² values. The one with the highest R² is the best fit for your data.

Warning: You may find that none of them have a high R² or that the highest R² isn’t actually that close to 1 — that means your data doesn’t fit any of these lines exceptionally well. In those cases, you should gather more data and then re-run the regression analysis.

Here’s how you can run a regression analysis in Excel.

1. Export your data into Excel.

In our example, we’ll be loading blog traffic numbers into Excel. (HubSpot customers, you can find this information in your Sources report — and make sure to select your blog subdomain from the top dropdown before exporting.)

Once you get the export open in Excel, make sure to remove all other information besides the row for each month and the row for traffic. HubSpot customers, you can find all the information you need under the “Visits” tab.

Button to export current view of your data from HubSpot

2. Graph the data using the scatter plot function.

Having located your exported file, your data will open in a new Excel spreadsheet. Organize your data the way you want them in each cell. When analyzing blog traffic over time, for example, it makes sense for “Time” to take the X axis and “Traffic” to take the Y axis. So we’ll dedicate two separate rows in Excel for these metrics.

Button above a blank Excel spreadsheet where you can insert a Scatter Plot chart

3. Open your trendline options.

In the top navigation, choose ‘Chart Layout‘ > ‘Trendline.’ This will open a dropdown menu of options for trendline types. These include:

  • Linear.
  • Exponential.
  • Linear Forecast.
  • Two Period Moving Average.

You can also select ‘Trendline Options,’ where you can set additional preferences for the trendline you want to use.

Dropdown menu in Excel with the Trendline Options button highlighted

4. Choose which type of trendline you’d like to test.

Under ‘Type,’ select which line style you want to use in your regression analysis. For our blog traffic test, we’ll use linear, as shown in the screenshot below.

Arrow pointed at the Linear trendline in a window of trendline options

5. Find your R² value.

Remember what R² is? This number between 0 and 1 indicates how much your trend line actually fits the shape of your scatter plot. Select ‘Options,’ then ‘Display R-squared value on Chart.’ R² will appear next to your line. After you’re done, click ‘OK.’

Box checked to display R-squared value on chart in Excel

6. Record R² back in your spreadsheet.

In the cells to the left of your graph, record the R² value that was displayed at the end of your scatter plot’s trendline.

Plan on running more than one regression analysis, each with different trendlines, then recording each of their R² values in their own cells in your original spreadsheet — as shown below. This will allow you to determine which type of trendline best explains the shape of your scatter plot. The type of line with the R² closest to the number 1 is your best-fitting trendline.

 R-squared value recorded in a cell in Excel

7. Remove your trendline.

Click on the line, then hit “delete” on your keyboard. Time to see if a different trendline more closely supports your data trend.

8. Run steps 4-7 again using new types of trendlines.

Repeat steps 4 through 7 for exponential and logarithmic lines. The more trendlines for which you find R² values, the more accurate your regression analysis will be. You want to be absolutely sure of the type of trend your data is showing, and stopping after one linear regression analysis is often not enough testing to draw a conclusion from.

Window of trendline options in Excel

9. Compare R² values. Whichever is nearest to 1 is the best fit.

If you’re linear, you’re growing at a steady rate. If you’re exponential, you’re growing at an increasing rate. If you’re logarithmic, your growth is slowing.

It’s possible that none of them are a great fit — see the warning above for more information on this.

In our example, exponential regression is the best fit because it has the highest R², at 0.896, and all are relatively close to 1. (Click the image below to enlarge it.) This means the exponential line is the best fit for your blog growth, and since it’s increasing exponentially, you have been growing quickly.

Regression analysis with a trendline on a scatter plot in Excel

That’s it, folks! By now, you should have an idea of how fast your blog is growing. Remember, this is only an indication of your past growth. Anything can happen in the future to throw off your traffic.

Image credits: Math is Fun, SOS Math

free guide to data visualization

Source: Hubspot

No Comments

Sorry, the comment form is closed at this time.

Translate »