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

How To Use in Sheets

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

External Links

Making a Prediction

Discover how to make predictions using a spreadsheet. Select the HD quality option for the best full-screen viewing experience. Visit for more videos and tutorials!

0Better Sheets Tutorials

No videos yet. Stay tuned!