search for: countif

...me based on the frequency with which the columns contain non-zero values. For example, let's say that I want to retain only those columns which contain non-zero values in at least 1% of their rows. In Excel I would calculate a row at the bottom of my data sheet and use the following function =countif(range,">0") to identify the number of non-zero cells in each column. Then, I would divide that by the number of rows to obtain the frequency of non-zero values in each column. Then, I would delete those columns with frequencies < 0.01. But, I'd like to do this in R. I think th...

I'm trying to calculate a cumulative area distribution (graph) of drainage areas. This is defined as P(A > A*). Simple in principle. I can do this in excel, with "COUNTIF", which will count the number of cells in the row "area" that have area A, then determine, for each cell in the row "area, how many cells exceede that area, then dividing that number by the total number of cells, which gives me the probability that drainage area A exceeds draina...

...ave the cell hold the particular ranking (score) for that philospher (i.e. a number between 1:10) I guess such a transformation would also allow me to do clusteranalysis? - But how to do it??? Anyways: what I have done so far is to compute a 10*10 matrix in a spreadsheet application. I do this by countif(range_choice1=philospher1)*10 for each philospher. In ?range_choice2? I multiply by 9, and in ?range_choice3? I multiply with 8 etc. The corresponding matrix I import to r and do dist(t(matrix) and then I use cmdscale$points to draw a plot. It looks nice but I am almost sure I'm doing it wron...

...) and finally passed (Final Mark) in record 2. I'd like to be able to work with the data so that I could summarize the achievement distribution for the first attempt records and then compare it to the achievement distribution for the second attempt records. In Excel I'd use something like COUNTIF($A$2:A2,A2) in a new column and then summarize the "1" values and "2" values. Order Student Number Course Final Mark Completed Date 1 1 12345678 Soc101...

hi everybody I wonder if there is a simple way, but not simple would be ok too, to customize info/welcome page at session start time? what I'd like to do is to put together simple short howto / dos & don'ts page for users, I'm thinking it would be great if it was possible many thanks [[alternative HTML version deleted]]

Hi All, I've been having a little trouble with creating a loop that will run a a series of t.tests for inspection, Below is the code i've tried, and some checks i've looked at. I've used the get(paste()) idea as i was told previously that the use of the eval should try and be avoided. I've run a single syntax to check that my systax is correct and works without any problems