linest

Hey guys, I'm creating an algorithm for daily fantasy basketball and I have hit a little roadblock. Here is the link to download my spreadsheet: <a href=http://www.filedropper.com/linestsolver><img src=http://www.filedropper.com/download_button.png width=127 height=145 border=0/></a><br...

Hey guys, So I am running a daily fantasy regression analysis and I need some help. I have found that certain criteria is better suited for predicting some player's performances than others. So I want to run a solver that will pick which criteria to use to maximize the R squared value. I...

Hey guys, This is my first post on the forum and I'm hoping to get some of the same help others have received. I am running a spreadsheet on excel for a daily fantasy basketball algorithm and so far I have succeeded in developing efficient macros to grab particular player data from a number of...

Using LINEST function with conditionsHow would I apply conditions to data that crosses thresholds. I want to include only the cells that have satisfied condition of n>30 threshold in the LINEST formula. So after each "data sample refresh" I may have to expand or decrease the range used in the...

I am trying to create a trendline for multiple series. Is there a way to "create trendline for all series"? I have also tried to use the linest function to get the trendlines but it does not work because I have gaps in my data. Below is an example of my data which I would like to create a...

I have this formula: =EXP(INDEX(LINEST(LN($P$9:$P$14),$C$9:$C$14),1,2))*EXP(1)^(INDEX(LINEST(LN($P$9:$P$14),$C$9:$C$14),1)*C9) I am essentially calculating the value at specific points on an exponential trendline. I want it to ONLY calculate this equation when there are values in cells P9:P14...

<colgroup><col><col><col></colgroup><tbody> Power (kW) Head (m) Mass Flow (kg/s) 51.58 30.00 206.1922 92.2492 30.00 401.8627 62.2747 30.00 243.2216 83.2188 30.00 325.0214 42.074 30.00 174.3451 36.3087 30.00 154.2164 48.1465 30.00 194.7579 31.211 30.00 135.9637 56.457 30.00...

I have ~144K rows of data and need help tweaking the LINEST function to run multiple regression against my data structure. On a single row, there are 3 columns with X1 variable results, 3 columns with X2 variable results, and 3 columns with Y results. The formula I am trying to use to get X1...

I have two ranges of data in excel (years are the "known x's" and data points are the "known y's"). I am trying to find the exponential trend using an excel formula. Assume years are in range B2:B13 and data points are in range C2:C13. I believe I found the following formula to work...

Hey everyone, I've got two VBA codes that work really well for what I'm doing, mostly: 1. Conditional LINEST function that only finds the x coefficient if the range matches the additional criteria: Function LinestCond(rY As Range, rX As Range, rCond As Range, vCond As Variant, _...

Hi, So I have two columns of data that I need to run a LINEST on, but these two columns will inevitabley have #N/A in some of their cells and there isnt anything I can do about this. That's fine, because I found a partial solution from a previous thread: LINEST question This works for the...

Is there a way to have Linest return the coefficient and intercept in the same column? (i.e., so that the coefficient is in the cell above the intercept instead of to the left of it?) I know I can do this using VBA, but before I resort to that solution I wanted to know if any array whizes out...

Linest is a very useful function but for my purposes it is becoming a pain in my a$$! I am trying to use Linest to return regression info but I would like to pick and choose which calibration gases I want to use and which to exclude. This is something that I do daily and I don't want to pick...

Hello, I'm trying to predict the dollar amount of new loans that my office will book over the next year. I have 10 years of historical data to build from. I started with a trendline forecast which shows what I already know, we're growing positively. Unfortunately, it doesn't accurately...

Hi guys, I'm having a lot of trouble with a spreadsheet I need to make for work. Essentially a test we carry out involves plotting 4 or 5 points on a chart, placing a polynomial trendline and reading the maximum y value from the curve. To simplify this, I've successfully written formulas that...

I am trying to do something similar to this http://www.mrexcel.com/forum/showthread.php?t=352771 but I want the order the polynomial to be variable. Here is what the code looks like with the static order equal to 2. varDataP = Application.Power(Application.Transpose(arr2), Array(1, 2))...

Two questions: 1) How can I pass two arrays into a user defined function? 2) How can I access single members of an array within a function? I'm trying to write a function that will automate my data-work up. I want to pass two arrays to this function, a set of x values, and a set of y...

Hi guys. I've been searching through the forums, but I can't seem to find anything on the subject. I'm using the worksheet funtion "LinEst" in VBA to make regression in a monte carlo simulation. It works just fine with a low number of simulations, but I would like to make 100,000 simulations...

I am looking to report back the regression coefficients for a 2nd order polynomial fitted to a set of data. There is one X variable, and one Y variable, but there are inputs on three different worksheets that I want combined. How do I input into the formula the range of Xs and Ys when they are...

I have instances where my Y variables sometimes contain a zero in the data and i need a formula to skip over that data point in the LINEST calculation. Y variables are in Row 1, Columns A:E X variables are in Row 2, Columns A:E The following formula is returning a #VALUE! error...