Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
bimodal problem
Hi
I am trying to find the two modes in a bimodal list of numbers. The MODE function in Excel only reports the lowest one it finds. After a reply from Tom I tried to use the FREQUENCY function but couldn't get it to work. I was trying to use it with an array Arr(). Does it only work with ranges ? I have also noticed that that the CountIf function doesn't seem to work with an array. Am I doing something wrong ? If AA.Count(Arr()) 0 Then Shd.Cells(416, i) = AA.Count(Arr()) Shd.Cells(417, i) = AA.Sum(Arr()) Shd.Cells(418, i) = AA.Average(Arr()) Shd.Cells(419, i) = AA.Median(Arr()) Shd.Cells(420, i) = AA.Mode(Arr()) The above statements all work. The statements below don't seem to work. Shd.Cells(421, i) = AA.CountIf(Arr(), 1) Shd.Cells(422, i) = AA.Frequency(Arr(), Shd.Range("E422:E429")) End If TIA Andrew B |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Colon at the end of excel file name(ex: problem.xls:1, problem.xls | New Users to Excel | |||
Bimodal histograms | Charts and Charting in Excel | |||
Started out as an Access problem. Now an Excel problem | Excel Discussion (Misc queries) | |||
Bimodal data | Excel Programming | |||
Problem when multipple users access shared xl-file at the same time, macrocode for solve this problem? | Excel Programming |