Linest

M

mnarasim

Hi,

I have 4 variables A, B, C and D.

I know the relationship between each of the variables with Result i.
each
variable as an independent variable.
How do I use this information to find an equation with all the four
variables that gives me the result. I looked at LINEST but I don't kno
how
each variable affects another- that is why I want to fit an equatio
that
involves those variables.
Any help is appreciated
 
G

Guest

Just to give more background on what I am trying to do:

Variable A is in meters, B is in meters, C is the Ranking, D is the number
of attempts. The Result is the overall factor rated 10 is good, 1 is bad
Let's say A could go from 1 - 100.
If A is between 0-20 meters, and 80-100 meters the Result (overall factor)
is very low.
Similarly for B.
C is the Ranking that could be 1 to 20. Again for low values of C the
Result(overall factor) is very low and high for high values of C.
D is the number of attempts an experiment is performed. If the value of D is
1 that is first attempt then the REsult(factor) is very high. For higher
values of D the Result is very low.
Therefore I know how each variable individually affects the Result(Overall
Factor). I know that these 4 variables are related. Therefore I want to find
an equation using the four variables to calculate the Overall Factor.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

LINEST 1
Linest 1
Linest 2
calculating multiple scenarios 1
How to record changing value of a cell 1
Regressions with data in (changing) rows 2
I dont know which function will do my work 1
Reversed Array 9

Top