用NumPy重现Excel的LINEST函数 [英] Reproducing Excel's LINEST function with NumPy

问题描述

我必须使用Excel的LINEST函数来计算线性回归中的误差.我希望使用Numpy的polyfit函数重现结果.我希望重现以下LINEST用法:

I have to use Excel's LINEST function to compute error in my linear regression. I was hoping to reproduce the results using Numpy's polyfit function. I was hoping to reproduce the following LINEST usage:

LINEST(y's，x's ,, TRUE)

与polyfit.我不确定如何使两个函数产生相同的值，因为我尝试过的任何方法都不会产生相似的结果.

with polyfit. I'm not sure how I can get the two functions to produce the same values because nothing I've tried gives similar results.

我尝试了以下操作:

numpy.polyfit(x，y，3)

和其他各种值位于第三位置.

and various other values in the third position.

推荐答案

这个问题实际上是我对NumPy的polyfit函数和LINEST的误解造成的.执行以下操作:

This question is actually a result of my misunderstanding of NumPy's polyfit function and LINEST. Doing the following:

 numpy.polyfit(x,y,1)

为我提供了正确的结果，因为它使用样本 x 和 y 值(例如LINEST)执行了线性回归.

gave me the correct result because it performs a linear regression using the sample x and y values like LINEST.

这篇关于用NumPy重现Excel的LINEST函数的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！