The stata manual for collapse (p. 7) states that using aweight when calculating the sum with collapse normalizes the weights to sum to number of observations in a group. Can someone please explain what does that exactly mean? How does the exact formula look like for the weights when I calculate the sum in cell? And when should I use what weights (aweight vs f/i/pweight)?