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

177	154	0	116	114	152	61	153	51	50	26	0
176	211	0	102	102	141	78	243	13	55	23	30

<tbody>
</tbody>

Y values for the respective Variables above.

6

56

<tbody>
</tbody>

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