Calculates the y-intercept of a linear regression line using existing x and y values.
פונקציה זו פועלת ב-Google Sheets בדיוק כמו ב-Excel — אותה תחביר ואותם ארגומנטים.
INTERCEPT(known_ys, known_xs)The INTERCEPT function determines the point where a line intersects the y-axis by using the best-fit linear regression line through the provided data points. It is commonly used to analyze the relationship between two variables when one is dependent on the other. The function uses the formula a = ȳ - bx, where b is the slope calculated by the SLOPE function.
=INTERCEPT({2,3,9,1,8}, {6,5,11,7,5})תוצאה: 0.048
Calculates the y-intercept for the provided sets of y and x values.
The INTERCEPT function ignores cells that contain text, logical values, or empty cells.