WPS Office

Free All-in-One Office Suite with PDF Editor

correct-icon

Edit Word, Excel, and PPT for FREE.

correct-icon

Read, edit, and convert PDFs with the powerful PDF toolkit.

correct-icon

Microsoft-like interface, easy to use.

Free download

Windows • MacOS • Linux • iOS • Android

banner

How to do a Linear Regression in WPS Spreadsheet

February 13, 2023
14.2K Views

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.

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

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.

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. 

15 years of office industry experience, tech lover and copywriter. Follow me for product reviews, comparisons, and recommendations for new apps and software.