Formulas > =LINEST()

How to Use LINEST() in Google Sheets

Description

Given partial data about a linear trend, calculates various parameters about the ideal linear trend using the least-squares method.

How To Actually Use LINEST() in Sheets

LINEST(known_data_y, [known_data_x], [calculate_b], [verbose])

Try LINEST yourself

Use the LINEST function to analyze the linear trend of the data in the range A1:A10 as the dependent variable (Y) and B1:B10 as the independent variable (X). The result should provide the slope and intercept of the trend line.

Hints (2)

Looking for a video tutorial? Members can email me anytime! Check out the blogs below for more info on this formula. Or generate your formula. Find more formulas here at BetterSheets.co/formulas

Transcript-matched member videos for LINEST(). Click through to watch.

Watch more tutorials
Hardest Formula: SumIF | Addition Based on Dates / Values

Hardest Formula: SumIF | Addition Based on Dates / Values

Demystifying the SumIF Formula. Add up your values based on a condition,...

Learn more about the LINEST() formula:

Generate a LINEST() formula for your needs

Describe your task in plain English and get a paste-ready formula that uses LINEST(). 2 free AI generations, no signup. Members get unlimited use.

Generate a LINEST() formula
Ads keep the free stuff free. Members browse ad-free — log in or see pricing.
Big Year 2027 calendar: the whole year on one Google Sheet

Free 2027 calendar.Plan all of 2027 on one Google Sheet, free.

Copy it to your Google Drive.

Free. No password, no card. The sheet link shows up right here.