|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
November 2nd 09, 09:54 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
standard error of regression coefficient
Does anyone know how to calculate this using excel formulas?
Sb = Se/sqrt((x-xbar)^2) Where Se = sqrt(sum((y-yhat)^2/(n-k-1))) I imagin it can be replicated with mmult and transpose comb, but am not sure how? Thanks, 
|
| Ads |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Standard Error Question | Barb Reinhardt | Excel Worksheet Functions | 0 | March 20th 08 11:43 PM |
| Standard Error Bars. | A S-D | Excel Discussion (Misc queries) | 1 | July 5th 06 11:52 AM |
| Regression - Standard Error X Variable 1 | Claude S | Excel Worksheet Functions | 2 | November 19th 05 10:08 AM |
| HOw do I set up Standard Error in a spreadsheet? | Laela | Excel Worksheet Functions | 1 | June 1st 05 12:22 AM |
| Standard Error | Maral | Excel Worksheet Functions | 2 | December 4th 04 06:45 PM |
Linear Mode
