To calculate the intercept, use cells D3:D9 as the y-values and C3:C9 as the x-values from the example spreadsheet. Input will be as follows:
以示例中工作表为例，选取单元格 D3:D9 作为 y 值，单元格 C3:C9 为 x 值，用 INTERCEPT 函数计算线性回归线与 Y 轴的交点。输入：