| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I perform multiple regression in Excel using two independe
I have the Simple Regression Function using one X-axis. I need the Multiple
regression function that uses two or more A-axis. I have Excel 2003. The multiple regression is not shown on the task menu. How can I get it? thanks |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I perform multiple regression in Excel using two independe
Freda -
For multiple regression, you could use the LINEST array-entered worksheet function, or you could use the Regression tool of the Analysis ToolPak. To use the Regression tool, choose Tools | Data Analysis | Regression. If you don't have Data Analysis on the Tools menu, choose Tools | Add-Ins and check the box for Analysis ToolPak; if Analysis ToolPak isn't listed, find your Office/Excel installation CD and add that feature (or choose Start | Control Panel | Add or Remove Programs | Microsoft Office/Excel 2003 | Change). - Mike www.mikemiddleton.com "Freda" wrote in message ... I have the Simple Regression Function using one X-axis. I need the Multiple regression function that uses two or more A-axis. I have Excel 2003. The multiple regression is not shown on the task menu. How can I get it? thanks |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I perform multiple regression in Excel using two indepe
Thanks Mike:
On the Regression function that I have, It only has one dependent axis and one independent axis. I need a Regression function with two independent X-axis and one dependent Y-axis. Freda "Mike Middleton" wrote: Freda - For multiple regression, you could use the LINEST array-entered worksheet function, or you could use the Regression tool of the Analysis ToolPak. To use the Regression tool, choose Tools | Data Analysis | Regression. If you don't have Data Analysis on the Tools menu, choose Tools | Add-Ins and check the box for Analysis ToolPak; if Analysis ToolPak isn't listed, find your Office/Excel installation CD and add that feature (or choose Start | Control Panel | Add or Remove Programs | Microsoft Office/Excel 2003 | Change). - Mike www.mikemiddleton.com "Freda" wrote in message ... I have the Simple Regression Function using one X-axis. I need the Multiple regression function that uses two or more A-axis. I have Excel 2003. The multiple regression is not shown on the task menu. How can I get it? thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Multiple Regression in Excel 2002 SP3 (Office XP)? | Excel Worksheet Functions | |||
| Multiple Excel on Task bar | Excel Discussion (Misc queries) | |||
| formula for linear regression | Excel Worksheet Functions | |||
| How can I have excel search and add multiple cells to find a targe | Excel Discussion (Misc queries) | |||
| Excel gets subtotals out of order using multiple sorts and subtot. | Excel Discussion (Misc queries) | |||
Linear Mode
