LINEARREG_INTERCEPT

<nav class="toc"><ol class="toc-level toc-level-1"><li class="toc-item toc-item-h3"><a class="toc-link toc-link-h3" href="#sample-usage">Sample Usage</a></li><li class="toc-item toc-item-h3"><a class="toc-link toc-link-h3" href="#syntax">Syntax</a></li><li class="toc-item toc-item-h3"><a class="toc-link toc-link-h3" href="#see-also">See Also</a></li><li class="toc-item toc-item-h3"><a class="toc-link toc-link-h3" href="#troubleshooting">Troubleshooting</a></li><li class="toc-item toc-item-h3"><a class="toc-link toc-link-h3" href="#additional-resources">Additional Resources</a></li></ol></nav><blockquote> <p>Linear Regression Intercept</p> </blockquote> <h3 id="sample-usage">Sample Usage</h3> <p><strong>Default</strong> =CS.LINEARREG_INTERCEPT( D2:D101) </p> <p><strong>Required and Optional</strong> =CS.LINEARREG_INTERCEPT( D2:D101, 0, 100, 14) </p> <p><strong>Full Example, with Global Parameters</strong> =CS.LINEARREG_INTERCEPT( D2:D101, 0, 100, 14, A20:B24) </p> <blockquote> <p>For a full list of common parameters, <a href="/functions/common/">Click Here</a>.</p> </blockquote> <h3 id="syntax">Syntax</h3> <pre><code>=CS.LINEARREG_INTERCEPT( inReal, [startIdx], [endIdx], [optInTimePeriod], [globalArgs]) </code></pre> <ul> <li><strong>inReal</strong> - Array of floats.</li> <li><strong>startIdx</strong> - [OPTIONAL] - Start index for input data</li> <li><strong>endIdx</strong> - [OPTIONAL] - End index for input data</li> <li><strong>optInTimePeriod</strong> - [OPTIONAL] - Number of period</li> <li><strong>globalArgs</strong> - [OPTIONAL] - Global arguments available on all functions. See <a href="/functions/common">common</a> for all available options.</li> </ul> <h3 id="see-also">See Also</h3> <p><a href="/functions/technical-indicators/beta">BETA</a> - Beta<br> <a href="/functions/technical-indicators/correl">CORREL</a> - Pearson's Correlation Coefficient (r)<br> <a href="/functions/technical-indicators/linearreg">LINEARREG</a> - Linear Regression<br> <a href="/functions/technical-indicators/linearreg-angle">LINEARREG_ANGLE</a> - Linear Regression Angle<br> <a href="/functions/technical-indicators/linearreg-intercept">LINEARREG_INTERCEPT</a> - Linear Regression Intercept<br> <a href="/functions/technical-indicators/linearreg-slope">LINEARREG_SLOPE</a> - Linear Regression Slope<br> <a href="/functions/technical-indicators/tsf">TSF</a> - Time Series Forecast<br> <a href="/functions/technical-indicators/var">VAR</a> - Variance </p> <hr> <h3 id="troubleshooting">Troubleshooting</h3> <ol> <li>Check your formula syntax for carefully, different functions for the same data may have slightly different required syntax</li> <li>Check the <strong>required arguments</strong> for your function vs the <strong>optional arguments</strong></li> <li>Check your data &#x26; API quotas and limits</li> <li>Check your formulas carefully</li> <li>Check your relative references</li> <li>Use Excels <strong>error checking tools</strong></li> </ol> <h3 id="additional-resources">Additional Resources</h3> <p><em>For Microsoft Excel</em></p> <ul> <li>Web browsers used by add-ins</li> <li>Office versions and requirement sets</li> <li>How to check your Office version</li> <li>Install the latest version of Office</li> <li>Custom Function Requirements</li> </ul> <p><em>For Googlesheets</em></p> <ul> <li>Throughput Quotas &#x26; Limits</li> </ul>