×
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

MULTIVARIABLE REGRESSION

MULTIVARIABLE REGRESSION

MULTIVARIABLE REGRESSION

(OP)
I have a come across a problem involving 6 different variables and 2 outputs. How do i go about finding the coefficients for this data. Does anyone know how i can tackle this problem? I thank you in advance.

RE: MULTIVARIABLE REGRESSION

The on-line help on the Linest() function covers the procedure for a single unknown, or multiple unknowns.

If it doesn't cover what you want to do could you give us more specifics.

Doug Jenkins
Interactive Design Services
http://newtonexcelbach.wordpress.com/
 

RE: MULTIVARIABLE REGRESSION

Excel has very powerful multivariable regression capabilities.  Look in the Help file under "regression".  It is part of the Data Analysis Pack that is not installed by default, so you may have to jump through a few hoops to get it to work.

Katmar Software
Engineering & Risk Analysis Software
http://katmarsoftware.com

RE: MULTIVARIABLE REGRESSION

(OP)
GregLocock : Hi there. yeah i am new here. i am expecting a polynomial equation for this data. i have attached the data file along with this reply.i hope the data will give you an idea of my problem.thanks for the reply.

IDS:thank you for the info. i will look into it.

katmar: thanks for your suggestion.



Appreciate all for your replies.

Regards.

 

RE: MULTIVARIABLE REGRESSION

If you look at your data, the AFR term is constant.  I would expect that it won't be significant in the final result.  So you only really have 5 factors.

 

RE: MULTIVARIABLE REGRESSION

I thought I would try to process your data, but it is not clear which are the dependent and independent variables.  What form of equation are you looking to create?

Katmar Software
Engineering & Risk Analysis Software
http://katmarsoftware.com

RE: MULTIVARIABLE REGRESSION

By turning on Autofilter, it appears that at least 5 the following components are the inputs:  IVO, EVC, N, MAF and AFR.

Looking at IVO=14, EVC=45, there are several examples when N, MAF and AFR are the same (e.g., there are 2 records with N=3000, MAF=300, AFR=14.3) but slightly different anwers for NOx, SDNMEP and TORQUE.

Just from simple examination of the data, the value of N (3000 vs 1000) seams to affect NOx (N decreases, NOx Decreases) and MAF affects TORQUE (MAF decrease, TORQUE decreases)

RE: MULTIVARIABLE REGRESSION

I'm assuming the last 2 columns contain the outputs.

I can get a pretty good linear regression model for torque as a function of 4 of the inputs.  R-squared is 92.5% so I don't see a need to go to a polynomial.

For the SDNMEP, the linear model is based on the same 4 inputs, but the R-squared is 46%.  May want to look at a quadratic or cube model here.

RE: MULTIVARIABLE REGRESSION

Greg - I hadn't heard of Antaeus before (and I note that Wikipedia hasn't heard of it either).

Now being downloaded (free for academic and non-commercial use it says).

Doug Jenkins
Interactive Design Services
http://newtonexcelbach.wordpress.com/
 

RE: MULTIVARIABLE REGRESSION

Greg,

The Antaeus output looks impressive.  I'm assuming that it's an interaction matrix.  Will it also permit you to develop a regression equation?

Like I said, a linear model works fine if torque is an output.

For the SDNMEP, it's more complicated.  I didn't bother to pursue it since I only assumed it was an output.  It seems more logical to me to start with the inputs and finish with the outputs.

Maybe the newbee will clarify what are the inputs and what are the outputs.  Or maybe this is homework!

RE: MULTIVARIABLE REGRESSION

(OP)
magoo: thanks for ur info. it gave me some idea

katmar: the IVO, EVC,N,MAF,AFR and NOx are my independent variables. the other 2 are the dependent variables. the task is that i'll need to find out what form of equation is suitable for this data.

greg: y do you think say that NOx is an output?

THE PROBLEM I AM FACING IS THAT I DO NOT KNOW HOW TO CONVERT ALL THE INPUTS INTO A VECTOR ,SO THAT I COULD PLOT IT IN A GRAPH.CAN ANYONE SHOW ME HOW TO GO ABOUT IT?

I THANK U IN ADVANCE

RE: MULTIVARIABLE REGRESSION

Sure sounds like homework to me.  Sorry.

RE: MULTIVARIABLE REGRESSION

Oh go on, do tell me how you were injecting NOx into the engine.

Never the less, you've been given several sufficient links for a regression in Excel, and some comments indicating that a linear model may not suffice.

Short of doing your homework for you, I think you need to ask specific questions having actually tried to follow the advice thus far.

Cheers

Greg Locock


New here? Try reading these, they might help FAQ731-376: Eng-Tips.com Forum Policies  http://eng-tips.com/market.cfm?

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