Given partial data about a linear trend, fits an ideal linear trend using the least squares method and/or predicts further values.
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 yet. Stay tuned!