I have several peole who are using their credit cards each month. The current limit on the credit card is $1500. What they are actually spending is anywhere from $220 to $890. I want to see how the actual card spend is distributed because if for example I see 50% of people spending on average $300 then I may recommend they use a card with a lower limit. If I see there is also another high percentage of people using the card alot (approx $700) then I may put those people on a higher limit credit card. Is a distribution chart something that could help me with that? If so, how would I arrange my data to be able to plot it?
Thanks in advance for any guidance!