I wish to make a histogram or only a calculation to the repeat of the exact same price. But my problem which I do not understand all choice the consumers was fit it at the table ex: when the table to the favorite animal for every single individual, we’ve got many choices in 1 column how do I do the type of it at the much easier way?
If I understand your question correctly, you want to make a histogram showing the number of times that something sold for exactly the same price, over all the possible different prices.
For example,
1 time at 1.50
2 times at 1.75
4 times at 1.98
9 times at 1.99
1 time at 2.25
2 times at 2.49, etc
The problem will be to group the data so that each selling price is in a category of its own.
You will need to use the Frequency function. Perhaps someone with more experience can help.