81% OFF online library of tutorials for mastering Google Sheets

One time purchase $199

TREND()

Description

Given partial data about a linear trend, fits an ideal linear trend using the least squares method and/or predicts further values.

How To Use in Sheets

TREND(known_data_y, [known_data_x], [new_data_x], [b])

External Links

Using TREND and AUTOFILL in Google Sheets

This video supports the Twelve Days of Christmas project in Applied Math, focusing on the syntax for TREND formula in Google Sheets.

0Better Sheets Tutorials

No videos featuring this formula, yet. Stay tuned! In the mean time check out blogs below, and more formulas here at Better Sheets.