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 my prediction?

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