Excel VBA的回归功能 [英] Regress function for Excel VBA

问题描述

在excel中使用回归函数，我无法将输出发布到我想要的位置. Excel会继续创建一个新的工作簿来放置结果.我究竟做错了什么?如何在当前工作簿中定位一个空格以粘贴回归的输出?

Using the regress function in excel and I am having trouble getting the output to post in the spot i want. Excel keeps creating a new workbook in which to place the results. What am I doing wrong? How do I target a space in my current workbook to paste the output of the regression?

Application.Run "ATPVBAEN.XLAM!Regress", Worksheets("statistics Database").Range("$C$7:$C$" & (7 + I - 1)), Worksheets("statistics Database").Range("$D$7:$F$" & (7 + I - 1)), False, True, , , True, , True, , Worksheets("statistical Output").Range("$A$1"), , False

语法应该是:

Regress(inpyrng, inpxrng, constant, labels, confid, soutrng, residuals, 
sresiduals, rplots, lplots, routrng, nplots, poutrng)

我正在添加正确的routrng和poutrng(所以我想.我做错了！)

I am adding the proper routrng and poutrng (So I thought. What am i doing wrong!)

推荐答案

我想出了答案:

首先，对于类似我的类似问题，您可以使用密码Wildebeest !!打开.xlam文件.然后，您将看到完整的参数列表以及该功能背后的整个逻辑.

First, for similar questions like mine, You can open the .xlam file with the password Wildebeest!!. Then you will see the full parameters list and the whole logic behind the function.

第二，这个问题的答案是 soutrng 参数.这是首要的退出.

Second, the answer for this question was the soutrng parameter. This is the primairy reg-out.

这篇关于Excel VBA的回归功能的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！