有没有一个函数可以用来得到趋势线的方程? [英] 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 帮助)
不确定，但您可能需要先启用分析工具包插件才能使用该功能.

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屋！