![]() The VBA code is really helpful, but i cannot enter it my excel wont execute The VBA function returns an actual median.Īlternatively, there is a method for estimating the weighted median of grouped data. WeightedMedian = WorksheetFunction.Median(vdata) Where weightedMedian is the following VBA code in a normal module (not a worksheet object):įunction weightedMedian(v As Range, cnt As Range)ĭim n As Long, k As Long, i As Long, j As Longįor i = 1 To v.Rows.Count: For j = 1 To cnt(i) Translate English function names appropriately. Read period as the decimal point (comma, for you). ![]() Standard deviation 6,670011739 variance 44,4890566Ĭaveat: Change parameter separators from comma to semicolon.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |