multiple nonlinear regression

From: Lian (duan.lian_at_gmail.com)
Date: 08/03/04 

Date: 3 Aug 2004 11:41:46 -0700

Hello,

I had a question about using excel to calculate the regression
equation for many independent variables (I have 7). I'm not too
knowledgable about stats, but I used tools->data analysis-> regression
to get a multiple linear regression equation, but I want to try
polynomial or non-linear, as the R I got was a bit too low. I have no
idea what to expect in the resultant equation , so I don't want to
fill up the worksheet columns with A^2, A^3, B^2, C^3, etc...

I read the posts about LINEST, but when I tried it, all I get is a
number, when I want a list of coefficients or an equation, and when I
tried using ^{1,2,3}, I get a #VALUE! error.

Thank you any help...
Lian

Relevant Pages

  • RE: Regression results
    ... if Microsoft or whatever stock on the ... So far one of the best thing i came over was a multiple regression (LINEST ... Excel uses a number instead; ... Accurately fitting 6th degree polynomials is often very difficult ...
    (microsoft.public.excel.programming)
  • Re: Missing coefficients in multiple regression
    ... RTF file of the Excel 97 and Excel 2003 outputs on the ... Regression Statistics ... But the table of coefficients and some ... >> Microsoft data base unsuccessfully. ...
    (microsoft.public.excel.programming)
  • Re: Missing coefficients in multiple regression
    ... Can you try the LINEST function? ... same zeros since my *guess* is that the Regression data analysis tool ... Excel, PowerPoint, and VBA add-ins, tutorials ... But the table of coefficients and some ...
    (microsoft.public.excel.programming)
  • Re: regression analysis
    ... in Excel 2004 there's a nasty formula bug. ... Or you could use the regression tools in FreeMat, Octave, etc. ... which includes a Regression tool (which can be used for simple and multiple ... you can always use Excel's built-in array-entered LINEST worksheet ...
    (microsoft.public.mac.office.excel)
  • Re: Is time series analysis available in Excel 2003?
    ... my book is not available as a download. ... Excel already had analysis tools that allowed you to designate the input ... independent variable and whether you want to force the regression thru the ... Regression and worksheet formulas can be used for time series analysis. ...
    (microsoft.public.excel.misc)