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
81% OFF online library of tutorials for mastering Google Sheets
One time purchase $199
Description
How To Use in Sheets
TREND(known_data_y, [known_data_x], [new_data_x], [b])
External Links
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.