regression

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

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

Hello, I have 100 sets of data, that i need to run regression on. Since no human would be willing to do it mannually 100 times, there must be some way.. Either to produce 100 set of results at a time, or there is a procedure that i can use to do it. Like type 1 in cell, drag the cell down, then...

I am brainstorming on what would be the best method to compile data, but I keep finding issues with my ideas. I'm hoping some of you have a good solution I can use. Let me describe what I'm doing and looking to do. I have a large workbook that has a summary page, which uses lots of formulas to...

I am trying to use the regression tool from the Analysis Toolpak to run a bunch of regressions. I have everything set up and the code seems to be fine but when I try to run it I get the following error: Run-time error '1004': Cannot run the macro". The macro may not be available in this...

I am testing the a couple of CAPM based models for my dissertation, and I have a healthy amount of stocks to regress, 5000 according to my last calculations, they’d have to be done as 75 stocks at a time, (in a portfolio). The number makes it an unrealistic task to accomplish manually, I have...

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

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

Hi, I have a file that I created to calculate a distribution based on time (periods) and total value to create a distribution curve. This is to be used as a forecast/estimate on a project. Output looks like the below. Now that I have my estimated amounts, I want to be able to apply actual data...

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

I have four years of monthly sales numbers. and 9 months of this years sales. I want to project the remaining months of sales. right now i am using a combo of linest and intercept to project each remaining month, LINEST($C56:K56,$C53:K53)*L53+INTERCEPT($C56:K56,$C53:K53) meaning...

I am using Excel 2010 and getting different RMSE (root mean square error) values when I calculate then myself (in Excel) vs relying on the Data Analysis Regression tool (where it is called the "standard error" in the output table). The differences are only noticeable when I have a relatively low...

The Following code is failing after I recorded a macro of a regression Application.Run "ATPVBAEN.XLAM!Regress", , , False, True, , "", False _ , False, False, False, , False Any help fixing is appreciated! The regression includes labels and the Y data is M11:770 and the X data is...

Hi guys My question may sound a bit dumb so please excuse me :stickouttounge: In regression in data analysis isn't multiple r the coefficient of correlation? And if so shouldn't the function CORREL yield the same answer if used on the same data sets Because I tried comparing the number of the...

given 100 samples, to calculate: numbers of hours spent on study is dependent on numbers of hours spent on social networking site. <tbody> x (social networking site) y (study) x^2 xy 6 4 36 16 24 6 4 36 16 24 6 3 36 9 18 6 3 36 9 18 6 3 36 9 18 6 3 36 9 18 6 3 36 9 18 6 2 36...

Hi, I've got lots of rows of data in Excel (around 3,500), and multiple variables. 1 of my variables is continuous (company revenues) 1 of my variables is a Yes or No 3 of my variables have a few (3-5) discrete options The output is money (continuous). I'm trying to use Excel 2007 to find the...

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

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

I've investigated a whole lot of addins and other software (including stand alone) but have yet to find any that provide an easy (automated) way to remove outliers (say, above/below 2x std). I sure could use something very easy for an app I am building for general users. Anyone know of...