search for: prices1

I would like to create a subtotal table with custom bands. seq1 = seq(0, 100, by = 5) seq2 = seq(100, 1000, by = 100) Bands = c(seq1, seq2) #Prices Prices = sample(1:1000, 200, replace=F) #corresponding size for the given price above. size = sample(1:1000, 200, replace=F) How would I find the subtotal of the size based on a given price falls within a band? -- View this message in

Hello, list,   I've been struggling with this task for a while looking for an efficient way to solve it: There are two variables 'price' and 'mentioned'. I want to 'enlarge' data so that missing price points within the price range are added to variable price. Also variable 'mentioned' is to receive values 0 in these cases. Note: Price points in original data can