TREND Function in Google Sheets

Predict values based on existing data trends using the TREND function.

TREND Function

The TREND function in Google Sheets predicts values based on existing data trends.

Syntax

TREND(known_data_y, [known_data_x], [new_data_x], [b])
  • known_data_y: The range of known dependent values.
  • known_data_x (optional): The range of known independent values.
  • new_data_x (optional): The range of new independent values.
  • b (optional): A logical value; TRUE for a constant b value.

Examples

  1. Basic Prediction

Predict values using known data in A1:A5 and B1:B5:

=TREND(A1:A5, B1:B5)
  1. Prediction with New Data

Use the function to predict values for new data in C1:C5:

=TREND(A1:A5, B1:B5, C1:C5)

Notes

  • Ideal for linear trend analysis and forecasting future values.
  • FORECAST: Predict a future value using linear regression.
  • LINEST: Calculate statistics for a line by linear regression.