Does anyone know how to predict a value from multiple dependant variables? I
know how to run the data analysis tool to get the "residual output" but
that's it. Also, I have variables which are drivers which are not numbers,
they are characteristics like "region", like US, Japan or Europe. Does
anyone know how I can account for these?

In the "excel help", they say you can do the following:

For example, you can analyze how an athlete's performance is affected by
such factors as age, height, and weight. You can apportion shares in the
performance measure to each of these three factors, based on a set of
performance data, and then use the results to predict the performance of a
new, untested athlete.

I basically need to know how to do that.

Any help would be greatly appreciated:) I am very stressed here trying to
figure this out!

- Audrey