linest function

Hello, I'm going to first explain in detail what I'm getting so that there's not confusion. I have the following data in subsequent columns: time(s), volume(cm3), volume(m3), time/volume(s/m3). So, as you can see, the first 2 columns are 'input type columns', in which I insert the values from...

Hi Everyone. I'm working on this complex formula (that's what I think, I know for some of the individuals it will be easy) =((INDEX(LINEST($N$4:$N$19,LN($O$4:$O$19),TRUE,FALSE),1))*(LN(O4)))+INDEX(LINEST($N$4:$N$19,LN($O$4:$O$19),TRUE,FALSE),2) Customers (Column L) Category (Column M) Avg...

I'm looking to predict data in pumping applications. given this. I will have unknow lengths of tables that will constantly have data added and removed. I can't find a way to structure the selected data the way I would like it to be. All data is expected to be quadradic, so my basic LINEST is...

Is there a way to combine two columns into a single array such that it can be used inside the LINEST function? for example, LINEST(known_ys, known_xs, const, stats) where the known_xs are two different columns of the same length from two different tabs, as opposed to be adjoining columns

I am trying to create a UDF for forecasting with polynomial regression. Assistance with the final line of code will be appreciated. The code thus far is as follows: Function Forecast_PolyTest(X As Single, knownYs As Range, knownXs As Range, Order As Integer) Dim k, OrdArr, PwrArr...

I have 2 columns of data in a workbook and need to use VBA to extrapolate data. I need to know Y for any value of X. I have a range of known Ys and Xs (as below) The trickier part here might be that I only want to consider part of the range to extrapolate (say the middle 6 values) - I then to...

I am trying to output the values of the R2 from the linEst function for all the rows of data I have using the following code: Sub getdeflection6() Dim xvalues() As Double, yvalues() As Double, cell As Range Dim alldata As Range Dim results As Variant Dim counter As Integer...

Hy, I have data like: X: 1 2 3 4 5 6 7 8 9 Forecasting Y: 10 15 12 14 15 19 (linest^{1,2}) Is it possible to get Linest ignoring Y blanks and use only X values to which there are numeric values for Y? I...

Hello, I'm trying to run a simple regression analysis on my Y and X variables but I get this error 'Regression - LINEST() function returns error. Please check input ranges again'. I have checked that my columns does not contain any blank cells. What else can be a reason for this? I really need...

dear, everyone now i am doing a assignment about udfs. i want to make a userform to regression some foreign exchange rate data and use the parameters to forecast the exchange rate in next term. i know that the linest function can output the parameters of the regression, but i dont know how to...