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.

 standard error of regression coefficient
 Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

## standard error of regression coefficient

#1
November 2nd 09, 09:54 PM posted to microsoft.public.excel.worksheet.functions
 iperlovsky external usenet poster Posts: 50
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,

 Thread Tools Display Modes Linear Mode

 Posting Rules You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off
 Forum Jump User Control Panel Private Messages Subscriptions Who's Online Search Forums Forums Home Excel Newsgroups     Excel Discussion (Misc queries)     Setting up and Configuration of Excel     New Users to Excel     Excel Worksheet Functions     Links and Linking in Excel     Charts and Charting in Excel     Excel Programming About ExcelBanter     About this forum

 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

All times are GMT +1. The time now is 08:40 PM.