Practically: Trendline for non statisticians

Published: 31 October 2022| Version 2 | DOI: 10.17632/w3hgskv49m.2
Gabriel Magen PhD


This article will discuss how to calculate and display a trendline on a tabular using very simple linear regression, usage of very simple statistical methods for linear regression will be used and and it will be explained and demonstrated on a given data on a data grid. Although we have built in abilities into spreadsheets such as google sheets or microsoft excel, sometimes there is a need to create a trendline manually and for this purpose the methodology of creating trend lines will be explained here. Mainly this is used by programmers to use this method for creating a functionality to display trendlines on charts for some other type of usages to be used at Business intelligence platforms.


Steps to reproduce

a. Create a series of data that you want to visualize as trendline. b. Calculate factors of A & B. c. Generate linear regression formula. d. Use the linear regression formula as the trendline.


Statistics, Software, World Wide Web, Genetic Programming, Webworm, Web-Building, Application Software