Syntax
=TREND(known_ys, [known_xs], [new_xs], [const])Arguments
| Argument | Required | Description |
|---|---|---|
known_ys | Required | The dependent values |
known_xs | Optional | The independent values |
new_xs | Optional | The x values to predict for (the known x values when left out) |
const | Optional | TRUE or left out to calculate the intercept, FALSE to force it to 0 |
How to use TREND
When TREND returns more than one value, the result spills into the cells below and to the right. Keep those cells empty, or you get #SPILL!.
TREND takes 1 required argument and 3 optional arguments. Type =TREND( in a cell and SheetsBat shows the arguments as you go. Optional arguments are shown in square brackets; leave them out to use their default.
Examples
Each result below was calculated by the SheetsBat formula engine.
=TREND({1;9;5;7}, {0;4;2;3}, {5;6})Result Spilled result
| A | |
|---|---|
| 1 | 11 |
| 2 | 13 |
=TREND({2;4;6})Result Spilled result
| A | |
|---|---|
| 1 | 2 |
| 2 | 4 |
| 3 | 6 |
Related statistical functions
- T.DIST.RTReturns the right tailed Student's t distribution.
- T.INVReturns the left tailed inverse of the Student's t distribution.
- T.INV.2TReturns the two tailed inverse of the Student's t distribution.
- T.TESTReturns the probability from a Student's t test that two samples come from populations with the same mean.
- TRIMMEANReturns the mean of the values after leaving out a percentage of the smallest and largest ones.
- VAR.PReturns the variance of a whole population.
- VAR.SEstimates the variance from a sample.
- VARAEstimates the variance from a sample, counting text as 0 and TRUE as 1.
- VARPAReturns the population variance, counting text as 0 and TRUE as 1.