Free All-in-One Office Suite with PDF Editor
Edit Word, Excel, and PPT for FREE.
Read, edit, and convert PDFs with the powerful PDF toolkit.
Microsoft-like interface, easy to use.
Windows • MacOS • Linux • iOS • Android
How to do a Linear Regression in WPS Spreadsheet
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.
Also Read:
- 1. How to unlock excel sheet in WPS Spreadsheet
- 2. How to Apply Linear Down Gradient Fill in Excel Using WPS Office (Step-by-Step)
- 3. How to set the series fill type in WPS Spreadsheet
- 4. How to show gridlines in WPS Spreadsheet
- 5. How to remove the dotted line in WPS Spreadsheet
- 6. How to view page break preview in WPS Spreadsheet