Hi
I was wondering if anyone knew how to write up a custom variance and covariance function in Excel where the mean (µ) in both formulas are replaced by the median.
Thank you.
Hi
I was wondering if anyone knew how to write up a custom variance and covariance function in Excel where the mean (µ) in both formulas are replaced by the median.
Thank you.
=SUMPRODUCT( (x - MEDIAN(x) )^2) / (COUNT(x) - 1)
=SUMPRODUCT( (x - MEDIAN(x)) * (y - MEDIAN(y))) / COUNT(x)
Last edited by shg; 10-30-2009 at 11:17 AM.
Entia non sunt multiplicanda sine necessitate
Thank you very much.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks