دالة Google Sheets

LINEST

Calculates the statistics for a line by using the 'least squares' method to calculate a straight line that best fits your data.

إنشاء صيغة بالذكاء الاصطناعي نفس الدالة في Excel

تعمل هذه الدالة في Google Sheets كما تعمل في Excel تمامًا — بالصياغة والوسائط نفسها.

الصيغة

LINEST(known_ys, [known_xs], [const], [stats])

The LINEST function calculates the linear regression parameters for a set of data points. It returns an array of values describing the line, such as the slope and y-intercept, and can optionally provide additional regression statistics.

المعاملات

known_ysمطلوبThe set of y-values already known in the relationship y = mx + b.
known_xsاختياريAn optional set of x-values that you may already know in the relationship y = mx + b.
constاختياريA logical value specifying whether to force the constant b to equal 0.
statsاختياريA logical value specifying whether to return additional regression statistics.

أمثلة

=LINEST({10,20,30}, {1,2,3})

النتيجة: {10, 0}

Calculates the slope (10) and the y-intercept (0) for the given data points.

الأسئلة الشائعة

Why does LINEST return only one value?

If you are not using an array-enabled version of Excel, you must select the output range before entering the formula and press Ctrl+Shift+Enter.

دوال ذات صلة

SLOPE INTERCEPT FORECAST TREND