angelajwms -
I suggest you return Mac Excel 2008 to the vendor and get a refund. Then
purchase Mac Excel 2004 (eBay, ...).
Mac Excel 2004 has the Analysis ToolPak wizards with the Regression tool.
Mac Excel 2008 does not have the Analysis ToolPak (because the wizards are
written in VBA, and Mac Excel 2008 does not include VBA), so it does not
have the Regression tool wizard.
To do regression analysis in Mac Excel 2008, you can use worksheet
functions: INTERCEPT, SLOPE, RSQ, and STEYX for simple regression, and
LINEST for multiple regression.
Also, for simple regression in Mac Excel 2008, you can create an XY
(Scatter) chart type and use the Add Trendline feature.
- Mike Middleton
http://www.DecisionToolworks.com
Decision Analysis Add-ins for Excel