Practically: Trendline for non statisticians
Description
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.
Files
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.