How to do a Linear Regression in WPS Spreadsheet

December 8, 2021
460 Views 0

Graphic skills

Regression, in math, graphs the linear relationship between an independent and a dependent variable, trying to figure out how much one thing depends on another thing.

For example, as light moves through a media, it will become dimmer as it is being extinguished. Absorbance is an expression of the amount of light absorbed by a solution. If we want to check whether there is a linear relationship between concentration and absorbance, how can we achieve it in WPS Spreadsheet?


Use WPS Spreadsheet to open the table. As shown below, generally, the x-axis data is above the y-axis data.

Select the area with data. Click the Insert tab > Scatter chart. A scatter graph will be automatically generated.

How to do a  Linear Regression in WPS Spreadsheets1.gif 

Once the graph is built, just right-click on any data point, then a sub-menu will pop up, where you can add Trendline.

How to do a  Linear Regression in WPS Spreadsheets2.gif 

Also, if you want to make your diagram more informative, click Format Chart Area on the right side of the table. And check Display Equation on chart and Display R-squared value on chart.

How to do a  Linear Regression in WPS Spreadsheets3.gif 

P.s. The R² value measures the proportion of variation in the dependent variable explained by the independent variable or how well the regression fits the data and a higher value indicates a better fit. 

Was this helpful?