perform a regression analysis

B

Bernard Liengme

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 non-linear 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
 
R

Roberta

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top