How do I perform multiple regression in Excel using two independe

I have the Simple Regression Function using one X-axis. I need the Multiple
regression function that uses two or more A-axis. I have Excel 2003. The
multiple regression is not shown on the task menu. How can I get it? thanks

Freda -

For multiple regression, you could use the LINEST array-entered worksheet
function, or you could use the Regression tool of the Analysis ToolPak.

To use the Regression tool, choose Tools | Data Analysis | Regression.

If you don't have Data Analysis on the Tools menu, choose Tools | Add-Ins
and check the box for Analysis ToolPak; if Analysis ToolPak isn't listed,
find your Office/Excel installation CD and add that feature (or choose Start
| Control Panel | Add or Remove Programs | Microsoft Office/Excel 2003 |
Change).

- Mike
www.mikemiddleton.com

"Freda" <Freda@discussions.microsoft.com> wrote in message
news:FC04388B-2F9B-46FB-978E-D598B6E95CAE@microsoft.com...
>I have the Simple Regression Function using one X-axis. I need the Multiple
> regression function that uses two or more A-axis. I have Excel 2003. The
> multiple regression is not shown on the task menu. How can I get it?
> thanks

Thanks Mike:
On the Regression function that I have, It only has one dependent axis and
one independent axis. I need a Regression function with two independent
X-axis and one dependent Y-axis. Freda

"Mike Middleton" wrote:

> Freda -
>
> For multiple regression, you could use the LINEST array-entered worksheet
> function, or you could use the Regression tool of the Analysis ToolPak.
>
> To use the Regression tool, choose Tools | Data Analysis | Regression.
>
> If you don't have Data Analysis on the Tools menu, choose Tools | Add-Ins
> and check the box for Analysis ToolPak; if Analysis ToolPak isn't listed,
> find your Office/Excel installation CD and add that feature (or choose Start
> | Control Panel | Add or Remove Programs | Microsoft Office/Excel 2003 |
> Change).
>
> - Mike
> www.mikemiddleton.com
>
> "Freda" <Freda@discussions.microsoft.com> wrote in message
> news:FC04388B-2F9B-46FB-978E-D598B6E95CAE@microsoft.com...
> >I have the Simple Regression Function using one X-axis. I need the Multiple
> > regression function that uses two or more A-axis. I have Excel 2003. The
> > multiple regression is not shown on the task menu. How can I get it?
> > thanks
>
>
>