Formula Help - Possibly logest / linest

[HughJars]

Hi

Hope someone can help me with a formula involving multiple x's to find a y

I have a series of x variables, some of which affect the value of y and some do not. I need help creating a formula that if I put in the x variables, and the y value, it will give me the multipliers for the x's. I am unsure if it is linear or not.

Have I explained that correctly? example of x's and y's below.

X Values
[TABLE="width: 776"]
<tbody>[TR]
[TD]177[/TD]
[TD]154[/TD]
[TD]0[/TD]
[TD]116[/TD]
[TD]114[/TD]
[TD]152[/TD]
[TD]61[/TD]
[TD]153[/TD]
[TD]51[/TD]
[TD]50[/TD]
[TD]26[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]176[/TD]
[TD]211[/TD]
[TD]0[/TD]
[TD]102[/TD]
[TD]102[/TD]
[TD]141[/TD]
[TD]78[/TD]
[TD]243[/TD]
[TD]13[/TD]
[TD]55[/TD]
[TD]23[/TD]
[TD]30[/TD]
[/TR]
</tbody>[/TABLE]

Y values for the respective Variables above.

[TABLE="width: 64"]
<tbody>[TR]
[TD]6[/TD]
[/TR]
[TR]
[TD]56[/TD]
[/TR]
</tbody>[/TABLE]

Thanks in advance.

 

[HughJars]

Has anyone got any ideas please - I'm pulling out what little hair i have left

If I knew which X variables were involved, I could just use a std regression, or am I really just looking at trial and error?

Thanks

 

[NiMip]

I'm afraid I don't completely understand what you're after. The x values look random... Do you just want the ratios of each x value to the given y value? How do you mean some affect the y value and some don't? If only some are legitimately part of some mathematical relationship, I don't quite get how you'll determine which are and which aren't.

 

[HughJars]

Hi,

Thanks for the reply. Maybe I can explain it better. Those y values are the result of a formula influenced by only some of those x values. Some have no effect, and I know there is a constant involved somewhere. I think it is probably linear.

What I'm trying to do is work out which ones are involved and which ones aren't. Is there a way of doing this, or will i have to just trial and error with the ones I think are involved.

Thanks