Sample Usage

Syntax

Troubleshooting

Additional Reso...

> Linear Regression Angle

### Sample Usage

**Default**
<typography-paragraph code copyable>
  =CS.LINEARREG_ANGLE( D2:D101)
</typography-paragraph>

**Required and Optional**
<typography-paragraph code copyable>
    =CS.LINEARREG_ANGLE( D2:D101, 0, 100, 14)
</typography-paragraph>

**Full Example, with Global Parameters**
<typography-paragraph code copyable="=CS.LINEARREG_ANGLE( D2:D101, 0, 100, 14, A20:B24)">
    =CS.LINEARREG_ANGLE( D2:D101, 0, 100, 14, A20:B24)
</typography-paragraph>

> For a full list of common parameters, [Click Here](/functions/common/).

### Syntax

```
=CS.LINEARREG_ANGLE( inReal, [startIdx], [endIdx], [optInTimePeriod], [globalArgs])
```

- **inReal** - Array of floats.
- **startIdx** - [OPTIONAL] - Start index for input data
- **endIdx** - [OPTIONAL] - End index for input data
- **optInTimePeriod** - [OPTIONAL] - Number of period
- **globalArgs** - [OPTIONAL] - Global arguments available on all functions. See [common](/functions/common) for all available options.

### See Also

[BETA](/functions/technical-indicators/beta) - Beta  
[CORREL](/functions/technical-indicators/correl) - Pearson&#x27;s Correlation Coefficient (r)  
[LINEARREG](/functions/technical-indicators/linearreg) - Linear Regression  
[LINEARREG_ANGLE](/functions/technical-indicators/linearreg-angle) - Linear Regression Angle  
[LINEARREG_INTERCEPT](/functions/technical-indicators/linearreg-intercept) - Linear Regression Intercept  
[LINEARREG_SLOPE](/functions/technical-indicators/linearreg-slope) - Linear Regression Slope  
[TSF](/functions/technical-indicators/tsf) - Time Series Forecast  
[VAR](/functions/technical-indicators/var) - Variance  

---

### Troubleshooting

1. Check your formula syntax for carefully, different functions for the same data may have slightly different required syntax
2. Check the **required arguments** for your function vs the **optional arguments**
3. Check your data & API quotas and limits
4. Check your formulas carefully
5. Check your relative references
6. Use Excels **error checking tools**

### Additional Resources

_For Microsoft Excel_

- <a href="https://docs.microsoft.com/en-us/office/dev/add-ins/concepts/browsers-used-by-office-web-add-ins" rel="noopener noreferrer" target="_blank">Web browsers used by add-ins</a>
- <a href="https://docs.microsoft.com/en-us/office/dev/add-ins/develop/office-versions-and-requirement-sets" rel="noopener noreferrer" target="_blank">Office versions and requirement sets</a>
- <a href="https://docs.microsoft.com/en-us/office/dev/add-ins/develop/office-versions-and-requirement-sets#how-to-check-your-office-version" rel="noopener noreferrer" target="_blank">How to check your Office version</a>
- <a href="https://docs.microsoft.com/en-us/office/dev/add-ins/develop/install-latest-office-version" rel="noopener noreferrer" target="_blank">Install the latest version of Office</a>
- <a href="https://docs.microsoft.com/en-us/office/dev/add-ins/excel/custom-functions-architecture" rel="noopener noreferrer" target="_blank">Custom Function Requirements</a>

_For Googlesheets_

- <a href="https://developers.google.com/apps-script/guides/services/quotas" rel="noopener noreferrer" target="_blank">Throughput Quotas & Limits</a>


How to use LINEARREG_ANGLE in Excel and Google Sheets