Current location - Training Enrollment Network - Mathematics courses - How to calculate the intercept formula in the math table?
How to calculate the intercept formula in the math table?
1. Open the Excel table and list the values of X/Y first.

2. After listing the values, enter the slope formula =SLOPE(B 1:B5, A 1:A5).

3. After inputting the slope formula, enter to get the slope of 0.6842 14633.

4. Input intercept formula = intercept (B 1: B5, A 1: A5).

5. After entering the intercept formula, press enter to get the intercept of -3.4772.