Current location - Loan Platform Complete Network - Foreign exchange account opening - What is the formula for calculating the slope?
What is the formula for calculating the slope?
1. First, enter data in cell A 1:A5, which is X.

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.