| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
running regressions in Excel 2003
my co-worker was able to run regressions in the version prior to the 2003 of
excel by going under the Help menu and using Lotus 123. But the 2003 version of excel no longer has this option. Can anyone point me in the right direction? Naraine |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
running regressions in Excel 2003
Hi Naraine,
What exactly are you trying to do? Can you give us values, formulas and expected results? -- Kind regards, Niek Otten Microsoft MVP - Excel "Naraine Ramkirath" wrote in message ... | my co-worker was able to run regressions in the version prior to the 2003 of | excel by going under the Help menu and using Lotus 123. But the 2003 | version of excel no longer has this option. | | Can anyone point me in the right direction? | | Naraine | | | | | | |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
running regressions in Excel 2003
I would like to compute Constant, & x coefficient
Regression Output: Constant 5034.686 Std Err of Y Est 2845.506 R Squared 0.941982 No. of Observations 20 Degrees of Freedom 18 X Coefficient(s) 113.4543 Std Err of Coef. 6.636594 Mid Salary Range & Male Job Class Actual Points Point Range Actual Points Gender Salary Ranges Job Title Min Mid Max 600-649 647 MC Manager, Environmental Services 68000 76000 84000 647 M Transportation Maintenance Manager 68000 76000 84000 647 M Manager, Transportation Construction 68000 76000 84000 636 M Clerk 68000 76000 84000 550-599 564 MC Ontario Works, Mgr Operations 65000 72500 80000 564 M Manager, Planning 65000 72500 80000 500-549 510 M Performance & Business Planning Mgr. 59000 65500 72000 450-499 485 MC Superintendent, Maintenance & Construction 53000 58500 64000 454 M Site Supervisors (Landfill) 53000 58500 64000 486 M Maintenance Manager 53000 58500 64000 459 M GIS Manager 53000 58500 64000 485 M Roads Forman 53000 58500 64000 400-449 431 MC Archivist 51000 56000 61000 440 M Fleet & Asset Manager 51000 56000 61000 434 M Maintenance & Service Manager 51000 56000 61000 438 M Forester 51000 56000 61000 412 M Purchasing Agent 51000 56000 61000 375-399 390 M Supervisor of Maintenance and Services 43000 47500 52000 350-374 353 MC Supervisor, Maintenance 40000 44000 48000 300-324 322 MC By-Law Enforcement Officer 31000 34500 38000 Regression Output: Constant 5034.686 Std Err of Y Est 2845.506 R Squared 0.941982 No. of Observations 20 Degrees of Freedom 18 X Coefficient(s) 113.4543 Std Err of Coef. 6.636594 "Niek Otten" wrote in message ... Hi Naraine, What exactly are you trying to do? Can you give us values, formulas and expected results? -- Kind regards, Niek Otten Microsoft MVP - Excel "Naraine Ramkirath" wrote in message ... | my co-worker was able to run regressions in the version prior to the 2003 of | excel by going under the Help menu and using Lotus 123. But the 2003 | version of excel no longer has this option. | | Can anyone point me in the right direction? | | Naraine | | | | | | |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
running regressions in Excel 2003
It is not clear from you post what you are regressing on what. Also, I have
never seen native Excel regression output labeled/formatted as you describe, but the numeric values can be obtained either from the LINEST worksheet function or from the Regression tool in the Analysis ToolPak (see Help for either). Jerry "Naraine Ramkirath" wrote: I would like to compute Constant, & x coefficient Regression Output: Constant 5034.686 Std Err of Y Est 2845.506 R Squared 0.941982 No. of Observations 20 Degrees of Freedom 18 X Coefficient(s) 113.4543 Std Err of Coef. 6.636594 Mid Salary Range & Male Job Class Actual Points Point Range Actual Points Gender Salary Ranges Job Title Min Mid Max 600-649 647 MC Manager, Environmental Services 68000 76000 84000 647 M Transportation Maintenance Manager 68000 76000 84000 647 M Manager, Transportation Construction 68000 76000 84000 636 M Clerk 68000 76000 84000 550-599 564 MC Ontario Works, Mgr Operations 65000 72500 80000 564 M Manager, Planning 65000 72500 80000 500-549 510 M Performance & Business Planning Mgr. 59000 65500 72000 450-499 485 MC Superintendent, Maintenance & Construction 53000 58500 64000 454 M Site Supervisors (Landfill) 53000 58500 64000 486 M Maintenance Manager 53000 58500 64000 459 M GIS Manager 53000 58500 64000 485 M Roads Forman 53000 58500 64000 400-449 431 MC Archivist 51000 56000 61000 440 M Fleet & Asset Manager 51000 56000 61000 434 M Maintenance & Service Manager 51000 56000 61000 438 M Forester 51000 56000 61000 412 M Purchasing Agent 51000 56000 61000 375-399 390 M Supervisor of Maintenance and Services 43000 47500 52000 350-374 353 MC Supervisor, Maintenance 40000 44000 48000 300-324 322 MC By-Law Enforcement Officer 31000 34500 38000 Regression Output: Constant 5034.686 Std Err of Y Est 2845.506 R Squared 0.941982 No. of Observations 20 Degrees of Freedom 18 X Coefficient(s) 113.4543 Std Err of Coef. 6.636594 "Niek Otten" wrote in message ... Hi Naraine, What exactly are you trying to do? Can you give us values, formulas and expected results? -- Kind regards, Niek Otten Microsoft MVP - Excel "Naraine Ramkirath" wrote in message ... | my co-worker was able to run regressions in the version prior to the 2003 of | excel by going under the Help menu and using Lotus 123. But the 2003 | version of excel no longer has this option. | | Can anyone point me in the right direction? | | Naraine | | | | | | |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
running regressions in Excel 2003
thank you. I was able to run the regression analysis based on your
directions. "Jerry W. Lewis" wrote in message ... It is not clear from you post what you are regressing on what. Also, I have never seen native Excel regression output labeled/formatted as you describe, but the numeric values can be obtained either from the LINEST worksheet function or from the Regression tool in the Analysis ToolPak (see Help for either). Jerry "Naraine Ramkirath" wrote: I would like to compute Constant, & x coefficient Regression Output: Constant 5034.686 Std Err of Y Est 2845.506 R Squared 0.941982 No. of Observations 20 Degrees of Freedom 18 X Coefficient(s) 113.4543 Std Err of Coef. 6.636594 Mid Salary Range & Male Job Class Actual Points Point Range Actual Points Gender Salary Ranges Job Title Min Mid Max 600-649 647 MC Manager, Environmental Services 68000 76000 84000 647 M Transportation Maintenance Manager 68000 76000 84000 647 M Manager, Transportation Construction 68000 76000 84000 636 M Clerk 68000 76000 84000 550-599 564 MC Ontario Works, Mgr Operations 65000 72500 80000 564 M Manager, Planning 65000 72500 80000 500-549 510 M Performance & Business Planning Mgr. 59000 65500 72000 450-499 485 MC Superintendent, Maintenance & Construction 53000 58500 64000 454 M Site Supervisors (Landfill) 53000 58500 64000 486 M Maintenance Manager 53000 58500 64000 459 M GIS Manager 53000 58500 64000 485 M Roads Forman 53000 58500 64000 400-449 431 MC Archivist 51000 56000 61000 440 M Fleet & Asset Manager 51000 56000 61000 434 M Maintenance & Service Manager 51000 56000 61000 438 M Forester 51000 56000 61000 412 M Purchasing Agent 51000 56000 61000 375-399 390 M Supervisor of Maintenance and Services 43000 47500 52000 350-374 353 MC Supervisor, Maintenance 40000 44000 48000 300-324 322 MC By-Law Enforcement Officer 31000 34500 38000 Regression Output: Constant 5034.686 Std Err of Y Est 2845.506 R Squared 0.941982 No. of Observations 20 Degrees of Freedom 18 X Coefficient(s) 113.4543 Std Err of Coef. 6.636594 "Niek Otten" wrote in message ... Hi Naraine, What exactly are you trying to do? Can you give us values, formulas and expected results? -- Kind regards, Niek Otten Microsoft MVP - Excel "Naraine Ramkirath" wrote in message ... | my co-worker was able to run regressions in the version prior to the 2003 of | excel by going under the Help menu and using Lotus 123. But the 2003 | version of excel no longer has this option. | | Can anyone point me in the right direction? | | Naraine | | | | | | |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
running regressions in Excel 2003
please see attached worksheet...
"Niek Otten" wrote in message ... Hi Naraine, What exactly are you trying to do? Can you give us values, formulas and expected results? -- Kind regards, Niek Otten Microsoft MVP - Excel "Naraine Ramkirath" wrote in message ... | my co-worker was able to run regressions in the version prior to the 2003 of | excel by going under the Help menu and using Lotus 123. But the 2003 | version of excel no longer has this option. | | Can anyone point me in the right direction? | | Naraine | | | | | | |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Running Macros in Excel 2003 | Excel Worksheet Functions | |||
| I used Lotus Help for regressions in MS Excel 99. Now what? | Excel Worksheet Functions | |||
| I am running Excel 2003 from Office 2003 Professional | Excel Discussion (Misc queries) | |||
| If statements (of course) {running excel 2003} | Excel Discussion (Misc queries) | |||
| Macros running slow in Excel 2003 | Excel Discussion (Misc queries) | |||
Hybrid Mode
