| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
perform a regression analysis
I need to know how to perform this analysis using Excel 2007.
|
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
perform a regression analysis
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 -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Becky1103" wrote in message ... I need to know how to perform this analysis using Excel 2007. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
perform a regression analysis
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 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 -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Becky1103" wrote in message ... I need to know how to perform this analysis using Excel 2007. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| What do I need to do to perform a sensitivity analysis | Excel Worksheet Functions | |||
| What do those numbers mean when i perform linear regression on exc | Excel Worksheet Functions | |||
| How do I perform linear regression? | Excel Discussion (Misc queries) | |||
| How do I perform linear regression? | New Users to Excel | |||
| How do I perform multiple regression in Excel using two independe | Excel Worksheet Functions | |||
Linear Mode
