=INTERCEPT(known_y's, known_x's)One free generation or explanation per browser, shared across Excel and Google Sheets. Account usage limits apply afterward.
Need more than a single INTERCEPT formula? Try our free AI for Excel — it reads your entire spreadsheet, answers questions in plain English, and builds charts and analysis in the same chat.
known_y's:
The dependent array or range of data points (y-values) that you want to analyze.
known_x's:
The independent array or range of data points (x-values) that correspond to the y-values in known_y's.
The INTERCEPT function in Excel is a statistical tool that calculates the point where a line intersects the y-axis in a linear regression model. In simpler terms, it helps you find the value of the dependent variable (y) when the independent variable (x) is zero, making it useful for understanding relationships between variables.
Imagine you are analyzing the relationship between advertising spend and sales revenue for a small business, and you have the following data in an Excel spreadsheet:
| Advertising Spend | Sales Revenue |
|---|---|
| 100 | 200 |
| 150 | 250 |
| 200 | 300 |
| 250 | 350 |
| 300 | 400 |
You want to find the y-intercept of the linear regression line that best fits this data.
To calculate the y-intercept, you would use the INTERCEPT formula as follows:
=INTERCEPT(B2:B6, A2:A6)When you apply the formula, it calculates the y-intercept of the linear regression line based on the provided data. The output would be:
| Y-Intercept |
|---|
| 100 |
Here, the y-intercept indicates that when the advertising spend is zero, the expected sales revenue would be 100.
The INTERCEPT function is particularly useful when you need to understand the relationship between two variables in a linear context. It allows you to make predictions and understand how changes in one variable might affect another.
Understanding how to use the INTERCEPT function can significantly enhance your data analysis capabilities in Excel, enabling you to extract meaningful insights from your datasets.
Happy calculating!
You have a table where Column A contains the number of hours worked by employees and Column B contains their corresponding sales figures. You can use the INTERCEPT function to determine the expected sales figure when no hours are worked, which helps in understanding the baseline sales performance. This can assist in evaluating the effectiveness of employee efforts and in making strategic decisions regarding staffing and sales targets without needing to delve into more complex regression analysis.
Beyond the INTERCEPT function: Better Analyst is a full Excel AI that goes well past individual formulas. Upload any spreadsheet and ask questions in plain English — you'll get formulas, data analysis, and charts back in seconds. It's a free AI Excel assistant that works with any .xlsx, .xls, or .csv file — no plugins, no Microsoft 365 required.
Don't have a spreadsheet yet? Use our free AI spreadsheet generator to turn a text prompt into a downloadable Excel file — a full AI Excel sheet maker that builds headers, columns, and formulas from your description.
Create a free account for formula help, explanations, and spreadsheet analysis. Usage limits depend on your plan.
Browse our complete library of Excel formula guides
Compare your options
Open a neutral research prompt in the AI tool you already use. Compare capabilities, limitations, and fit before you choose.
AI answers can be incomplete. Check source links, current pricing, and product documentation before deciding.