linest

  1. S

    Maximize R squared using solver DOCUMENT ATTACHED (may be difficult)

    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...
  2. S

    LINEST on specific non-adjacent columns

    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...
  3. S

    LINEST/REGRESSION skipping blanks

    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...
  4. W

    Using LINEST function with conditions

    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...
  5. E

    How to create multiple trend lines without clicking on each line in the graph

    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...
  6. derek.hughes

    Array formula?

    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...
  7. A

    Carrying out LINEST to selections of data in 2 columns

    <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...
  8. J

    Help with multiple regression using LINEST function

    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...
  9. C

    LN() function, excel 2010

    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...
  10. R

    Weighted/Conditional LINEST VBA (Coefficient/Y-Intercept)

    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, _...
  11. R

    How do I Ignore #N/A with LINEST ? I have Partial Solution already...

    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...
  12. K

    Changing Linest Format

    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...
  13. R

    Using Linest and Index/Match together

    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...
  14. M

    Predicting Loan Growth

    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...
  15. M

    4th Order Polynomials - Please Help!

    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...
  16. Ralajer

    LinEst in VBA - Dynamic Order of Regression

    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))...
  17. T

    User Defined Functions and Arrays

    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...
  18. J

    LinEst with more than 65536 rows

    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...
  19. S

    Linest question

    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...
  20. B

    LINEST & CELLS w/ ZERO

    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...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top