Given partial data about a linear trend, fits an ideal linear trend using the least squares method and/or predicts further values.
81% OFF online library of tutorials for mastering Google Sheets
TREND()
Description
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.