2. Then enter the data in cell B 1:B5, and the data group is y ...?
3. Enter the formula for calculating the slope k in the blank cell: =slope(B 1:B5, A 1:A5).
4. Click Enter to generate the calculation result, and the slope value can be obtained.
5. Enter the calculation formula of intercept b in the blank cell: = intercept (B 1: B5, A 1: A5), and click Enter to generate the calculation result.