how do i do a regression in excel?

[Guest]

i was told to go to tools, then data analysis. However, I cannot find the
data analysis option under tools. Is this becase I have an older version of
Excel?

 

[Mike Middleton]

Mike G -

i was told to go to tools, then data analysis. However, I cannot find the
data analysis option under tools. Is this becase I have an older version
of Excel? <

Here's an excerpt from my book "Data Analysis Using Microsoft Excel: Updated
for Office XP":

"If the Data Analysis command doesn't appear on the Tools menu, choose the
Add-Ins command from the Tools menu; in the Add-Ins Available list box,
check the box next to Analysis Tools. If Analysis Tools doesn't appear in
the Add-Ins Available list box, you may need to add the Analysis ToolPak
through a custom installation using the Microsoft Excel Setup program."

- Mike

www.mikemiddleton.com