Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Regression Analysis Format
I've never had to perform multiple regression through Excel before so forgive
any simple mistakes or assumptions. I'm trying to create a relationship between 3 variables (Crossfall, gradient and flow width) and an output (Area). Having arranged the data in a suitable way that Regression Analysis could be carried out I'm presented with 3 variables. However, nowhere does is specify what in format these variables are applied / combined such that I may produce a result. Is it a simple y=Aa+Bb+Cc+I? Or is there something more complex? I have tried with the above format but the equation does not reproduce the figures that I'm after. Cheers, RickH |
#2
|
|||
|
|||
Regression Analysis Format
If I understand your problem correctly:
When you have run your analysis you are presented with some tables, look at the figures in the column named Coeffisients (I think, have to translate from Norwegian). The first one is the constant, and then you have the coeffs for your variables. Your equation will then look sth like this: Area = Crossfall*Coeff + Gradient*Coeff + Flow*Coeff + Constant Try with your data and see what results you get. Did this help or am I far out in the North Sea....????? Knut "RickH" skrev i melding ... I've never had to perform multiple regression through Excel before so forgive any simple mistakes or assumptions. I'm trying to create a relationship between 3 variables (Crossfall, gradient and flow width) and an output (Area). Having arranged the data in a suitable way that Regression Analysis could be carried out I'm presented with 3 variables. However, nowhere does is specify what in format these variables are applied / combined such that I may produce a result. Is it a simple y=Aa+Bb+Cc+I? Or is there something more complex? I have tried with the above format but the equation does not reproduce the figures that I'm after. Cheers, RickH |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Office2000: Conditional format behaves strangely | Excel Discussion (Misc queries) | |||
can't format cell - have tried unlocking and unprotecting | Excel Discussion (Misc queries) | |||
why does currency format change to number format? | Excel Discussion (Misc queries) | |||
Keep custom format in new worksheet | Excel Discussion (Misc queries) | |||
Copying a conditional format | Excel Worksheet Functions |