regression

Hello, I have a set of experimental data. I'm using the option trendline to fit a polynomial regression curve. I can retrieve the equation by selecting "Display Equation on chart" then copy/paste to insert the equation in the worksheet and manipulate to extract the coefficients: example: y =...

Hi, I'm interested in running more than one regression (note: NOT multiple regression analysis). For instance, I have 1,000 different SKUs that I want to regress against sales forecasts to find a regression equation for each SKU as well as keep some of the information that Excel provides (T...

I'm trying to build a macro with regression statistics for multivariables. I tried "recording" the regression button from data analysis and manipulating the code but continuously keep getting errors. All I need are the coefficients so I can build an equation for new data. I need to do this...

hi everyone, My program is running a multiple linear regression. The input is a vector "y" and a matrix "x" made for five columns (x1,x2,x3,x4,x5). The following line is the call of my the multiple linear regression : ActiveCell.FormulaR1C1 = _...

Hi all-- I have multiple data sets, each which fit a power curve very well. Each dataset has 30 days worth of data If I graph the data and add a power trendline, I'm able to see an equation on the chart and get a sense for where the data will be at 100 days. How can I accomplish the same...

Any suggestions for finding? Is it available as an add-in? Thanks, Newbie Gerrypicker

So I ran a regression on different "type" scenarios and got the following. I see that the R-Square is not a great fit (<95%) but I was hoping I might be able to use this regression to figure out some relationships and make some determinations about which "Type" would yield the best results. In...

I am desperate. Im trying to meet a deadline today and need your help. I am trying to do a multiple regression in Microsoft excel is : Median home value for owner occupied units (y) = median age structure was built per tenure (x1) + State (GA) (x2) + Median household income (x3) + median number...

I'm trying to use the regression add-in to forecast future sales. I have a number of variables which are text like east, west, north, south. I'm hoping to show the relationship (if one exists) between future sales and East, West, North, South, but I can't figure out how to do this in excel...

I am trying to write a macro that will run a regression analysis for me using ranges that I define in cells A1 (for the Y variable) and B1 (for the X variables). For example, a sample size of 250 will produce the following cell contents: A1 contains "$B$13:$B$263" and B1 contains...

Hi again, I'm trying to run some simple regressions with excel and everytime I try and run it excel "unexpectedly encounters an error and has to close". Anyone else have this problem and/or know how to fix it? Thanks.

Hi everyone... I'm running a simple linear regression in excel that needs to have an intercept of 0. Thus, I ran the regression through Tools / Data Analysis and checked the "Constant is Zero" box. However, I also ran the regression line by plotting the points in a scatterplot, adding a...

I created a trendline and associated equation for some data plotted against Time on the x-axis displayed in MM/DD/YY format. The date for the data ranges from 3/27/06 thru 11/10/08. The trendline equation is… F(x)=-6E-13x^5+1E-07x^4-.0087*x^3+329.1*x^2-6E+06*x+5E+10 The data actually crosses...

I know you can view various trend lines in Excel by adding a trend line to an existing chart. Furthermore, you can view the formula on the chart which provides the equation that describes the tend line shown. Background: In my model, I'm trying to identify numerous (50+) unique polynomial...