1. B

    Using arrays in LINEST for multi variable regressions

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

    Regression Macro Stops Unexpectedly

    Hello, I created a macro to run a linear regression automatically, and when I execute the code it works properly. However, when a coworker tries, it is as if the macro stops unexpectedly with no error or anything. It just doesn't continue on. This is a snippet of the code. It completes the...
  3. E

    Error running regression Macro

    Hello, I have been working on automating a spreadsheet that contains a Regression Analysis. I have ran through it numerous times and it works just fine. However, when I send it to a coworker she gets an error saying "Run time error. Cannot run macro." She has macros enabled, but for whatever...
  4. E

    Variable Range in VBA Regression

    Hello, I am trying to automate a linear regression but want it to work for variable sized data sets. This is what I have for a given set. The Y data always starts at X5 and the X data always starts at Y5, but the length of the column changes. Any ideas as to how I would allow for the regression...
  5. S

    Data Analysis Toolpak - Regression

    Hello- I am constantly receiving the error "Regression Input range contains numeric data" when using the regression analysis in the data tool pak. I have performed a data validation check to ensure no non-numeric values exist. This error is only occurring on the regression, not correlation...
  6. C

    Looping Regression Analysis using VBA

    Dear All, Thanks for reading. I am wondering if anyone could help me write a macro in order to loop the regression function. I have a total of 56 dependent variables and 3 independent variables which remain constant for all the regressions. Every regression is just using the next column for...
  7. K

    Excel Solver

    I'm taking an intro to supply chain management online and am struggling with using Excel Solver. The class is online, so read the chapters and complete homework. Professor is very unresponsive as well. I am struggling with how to set up my linear regression. I need to create optimum...
  8. T

    Least squares regression

    So I have the actual Regression table however I can’t fogure out the formula for the x y axis. Can you help?
  9. A

    How to find coefficiences of Multiple regression model

    Hi, I want to find coefficiences in Multiple regression model with dependent variable Y and 4 independent variable X1, X2, X3, X4 by VBA. I am a newbie to VBA, so any assistance would be appreciated. Thank you
  10. C

    Excel 2016 Regression error #NUM!

    Hi, I am trying to find out which of seven scores (if any) are good predictors of another value (predicted?). When I run the regression analysis I get an error #NUM ! in the Grade 7 P value and I can't figure out why. Any help would be MUCH appreciated. <colgroup><col style="width:48pt"...
  11. S

    How to perform a regression from within a programmed macro

    I have worksheets of data in the same format (different data / same format) - I am needing to routinely needing to perform a regression analysis on this data. A recorded macro (shortcut key) would be very helpful. I have attempted and continue to strike out to record a macro that: goes to data...
  12. P

    Best Way to Forecast with this Data

    Hi - I need help determining the best way to forecast for the following year end forecast value. The 'Xs' represent the data I have available to me to leverage. Ideas??? Thanks!!! <tbody> Months: 1 2 3 4 5 6 7 8 9 10 11 12 Total 2018 x x x x *FORECAST* 2017 x x x x x x x x x x...
  13. C

    regression vba where the range of X and Y will change

    Hi, I have the code below which runs a regression for me in Excel 2010. You will see that the DV range (X) is dynamic from AV27 down, so when the quantity of data changes it references it properly - this is fine. The same goes for the IV range (Y) but it is dynamic only in terms of the quantity...
  14. B

    VBA data analysis loop problem

    Hi there, I'm after a macro that can loop through a data table that i've prepared so that Excel can run multiple regressions at the same time using the "Data Analysis Tool pack" So current my data table is set up so that every dependent variable is right before the subsequent independent...
  15. D

    How to set up qualatative data as a set of binary variables for regression analysis?

    I am doing a regression analysis and have some data from a survey. One column is ethnicity. The way the data is set up is: <tbody> Yearly Salary Ethnicity Age 100 Black 25 87 White 24 57 Black 65 94 Hispanic 45 </tbody> But I would like it set up so that each ethnicity is it's own...
  16. P

    LINEST returning wrong R^2

    I have a data set with only 2 variables (x and y) and I am using LINEST to set the intercept to zero and return additional statistics. The r^2 value that LINEST returns is completely wrong though. LINEST Returns a r^2 value of 0.999239357 where the actual r^2 value is 0.6544 that I get from a...
  17. L

    Regression - LINEST() Function Error

    Hi Excel experts, I'm trying to run a linear regression on two columns with integers as values after filtering them for blanks (missing values) and after filtering the rows based on "yes"/"no" values of another column in the table. When I run the regression, I get the following error...
  18. S

    Regression Issues!!!

    Hi guys, So basically I have to run some regression analysis on a University assignment I am doing. I have chosen to investigate the efficiency of point kicking in the Aviva Rugby Premier League. My two independent variables are: - Points Conceded - League Points My independent variable...
  19. D

    R-Squared LINEST does not match chart value

    I have a data set of x and y values, my aim is to come up with a formula which I can use to input an x value to give me the expected y value. When I plot my data on a scatter chart, using a 3rd order polynomial trend line I get an r-squared value of 0.8402. When I use LINEST to get an r-squared...
  20. D

    Multiple regression issues in analysis toolpak

    Dear MrExcel community, Is there any easy and automatic way to compute predictions including confidence intervals after a multiple regression using the Analysis Toolpak? Also, the analysis toolpak regression tool reports an error whenever I have missing data points in my range selection. What...

Watch MrExcel Video

This Week's Hot Topics

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