×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

multi-variables Regression

multi-variables Regression

multi-variables Regression

(OP)
thread770-214997: Multivariable regression in Excell

Hi everyone,
I am trying to find the regression equation for a set of data with 2 independent variables using LINEST function in EXCEL.

I re-tabulated my data in order to use the LINEST function. The equation I would like to get is from the second order like this:
Y = c + a1*x1 + a2*x1^2 + b1*x2 + b2*x2^2

and like this as well:
Y = c + a1*x1 + a2*x1^2 + b1*x2 + b2*x2^2 + b3*x1*x2

I tried to use the same method used in this link but I could not get any results. http://www.eng-tips.com/viewthread.cfm?qid=214997#...

I have attached my EXCEL file, have a look please. http://files.engineering.com/getfile.aspx?folder=4...

May any one please help me with that?
Please give some explanation about how to get the coefficients such as the ones included in the referred thread =LINEST(Y1:Y10,B1:B10^{1,2,3,0,0,0,1,2,3}*C1:C10^{0,0,0,1,2,3,1,1,1},TRUE,TRUE)


I would like to mention something else: my original data has 4 variants Y=f(x1,x2,x3,x4) but I tried to make my question simple. Therefore, should I use the same method when dealing with more complex data?

Many Thanks
Alaa


RE: multi-variables Regression

The ^{0} trick wont work because you have zeroes in your data and 0^0 is undefined. Instead, just create the x1*x1, x2*x2 and x1*x2 columns and refer to them explicitly:

=LINEST(D3:D123,E3:H123,TRUE,FALSE)

or E3:I123 to include the x1*x2 term.

Remember to hit ctrl-shift-enter when entering the formula.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources