regression analysis

  1. L

    Need VBA for SumProduct of Array and Constant raised by Array for Regression

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

    How to get a relationship equation in between variables of a multi-physics problem?

    I have a multiphysics problem in which my output voltage data is dependent on the input oscillation frequency. There are four physics coupled in the problem. I have experimental voltage data available w.r.t time. However, I don't have an extensive input frequency data points. I would like to...
  4. 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...
  5. 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...
  6. T

    Cointegration and granger's causality test in Excel

    I have following data: A -> 100 150 123 145 167 200 250 300 270 B-> 290 300 280 276 234 234 288 345 399 How can I perform stationarity,cointegration,Granger's test in Excel?
  7. R

    Regression lagged variables

    hi im trying to do a multiple regression analysis with lagged variables but everything i try excel says i need the same amount of x and y ranges. example A B C D RGDP RGDP-1 RGDP-1^2 RGDP-1^3 1 2 1 1 1...
  8. E

    Automate Regressions

    Hi Is there a way of writing a macro that can search through a set of values in excel and based on a particular value in a particular row set when running the macro, regress the next 90 values in two adjacent columns? For example. search column A for a value 'StockSplit'. If row 32 in column A =...
  9. B

    Regression analysis to fit data into Log Normal Distribution in VBA

    Hello everyone, I would like to run regression analysis in VBA. I have a set of data that I want to fit into a LogNormal distribution. I called the parameters of the Lognormal distribution "sigma" and "mju". To accomplish this, I am trying to create a function in VBA, called...
  10. 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...
  11. A

    1 Equation for 4 variables

    Can I use excel to get make an equation for 4 variables (x,y,z,w) e.g a,b,c,d,3,f,g,h,i, would be constants w = ax + by + cz + dx^2 + ey^2 + fz^2 + gxy + hyz + iyz I tried regression but the equation looks like w = ax + by + cz + c Is it possible on ay other software e.g MATLAB
  12. S

    Regression Modeling in Query

    I want to use regression analysis to estimate savings. I have 2 tbls, TblA and TblB TblA - has ID, yr, mn, Svg for actual months (if proj started in Mar and today is May, it will have only March, April and May data ONLY) TblB - has ID, yr, mn, Pvol for 12 months I want to correlate Actual...

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