Linda -

For a single explanatory variable, use (1) an XY (Scatter) chart and Add
Trendline or (2) the INTERCEPT and SLOPE worksheet functions.

For one or more explanatory variables, use (3) the Regression tool of the
Analysis ToolPak or (4) the array-entered LINEST worksheet function.

- Mike
www.mikemiddleton.com

"Linda" wrote in message
...
Does anyone know how to develop a linear predictive equation for one set
of
variables based on using a different independent variabe?