我可以使用一个函数来获得趋势线方程吗? [英] Is there a function i can use to get the equation for the trendline?
问题描述
我知道我可以通过检查显示方程式将其显示在图表上,但我想知道是否有一个公式可以将方程式本身散布在一个单元格中?
I know I can get it on the graph by checking show equation but I was wondering if there's a formula that spits out the equation itself in a cell?
我需要对成千上万个单独的数据集执行此操作,并且绘制它们的图形只是一种选择.
I need to do this for thousands of separate data sets and graphing them is just not an option.
推荐答案
LINEST函数使用最小二乘"方法计算最适合您的数据的直线,从而计算出一条直线的统计信息,然后返回一个数组描述该行. (来自Excel帮助)
不确定,但是您可能需要先启用Analysis Toolpack加载项,然后才能使用该功能.
The LINEST function calculates the statistics for a line by using the "least squares" method to calculate a straight line that best fits your data, and then returns an array that describes the line. (from Excel help)
Not sure, but you may need to enable the Analysis Toolpack addin before being able to use that function.
这篇关于我可以使用一个函数来获得趋势线方程吗?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!