Re: perform a regression analysis
 From: Roberta <Roberta@xxxxxxxxxxxxxxxxxxxxxxxxx>
 Date: Wed, 15 Oct 2008 07:00:04 0700
I followed the steps below and I do not see Data Analysis cmd. I see Data
Validation and What if Analysis. I need the regression pc of Data Analysis
in Excel 2007.
"Bernard Liengme" wrote:
If you have linear data and you want just the slope and intercept, use.
functions SLOPE and INTERCEPT. For more statistics use LINEST
LINEST can also be used for nonlinear fits; see
http://people.stfx.ca/bliengme/ExcelTips/Polynomial.htm
If you wish to use the static Data Analysis tool, you need to load the
Analysis ToolPak.
Click the Office button (bright star to the left), locate Excel Options at
bottom of dialog, in the left panel click AddIns, at the bottom of next
dialog use Manage Addins, click Go
Now make sure the Analysis ToolPak (first one, not the VBA one) is selected.
When you exit the options and look on the Data tab you will see Data
Analysis in the Analysis group
best wishes

Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email
"Becky1103" <Becky1103@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:476CABDCFF2741E6947DA47D329D73CF@xxxxxxxxxxxxxxxx
I need to know how to perform this analysis using Excel 2007.
 References:
 perform a regression analysis
 From: Becky1103
 Re: perform a regression analysis
 From: Bernard Liengme
 perform a regression analysis
 Prev by Date: RE: Sum data with criteria stored in row and column
 Next by Date: fill handle in Excel
 Previous by thread: Re: perform a regression analysis
 Next by thread: tilda in VLOOKUP and MATCH
 Index(es):
Relevant Pages
