Covariance in Excel in biased

=?Utf-8?B?Q292YXJpYW5jZQ==?=

Guest

Posts: n/a

27th Oct 2006

The covariance formula in Excel is divided by n, and it should be divided by
n-1. Thus, the covariance is biased since the variance formula is divided by
n-1.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...el.programming

« Find | What's this new sheet? »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Biased Number Generation?	plh	Microsoft Excel Programming	4	30th Aug 2009 05:18 AM
Excel for dummies - Covariance/Correlation question	Schizoid Man	Microsoft Excel Discussion	1	12th Aug 2006 02:09 PM
how to get covariance of the estimated coefficients using excel	=?Utf-8?B?TW9vaHdhbg==?=	Microsoft Excel Misc	4	4th Apr 2006 06:52 PM
topic for a biased speech to convey other into what i think	=?Utf-8?B?bmJvaHJlcjI0?=	Microsoft Word Document Management	4	29th Mar 2006 03:34 PM
Brand Biased? Separate HDD for WinXP & W2K Pro originally from IBM PC won't Boot	Perplexed2	Windows XP General	4	21st Nov 2003 05:01 PM