I have been asked to create a side-by-side box plot of retail price by store. Then filter by store location so only so only the store with the highest average price and the one with lowest average price are shown in the graph. I am having trouble creating the filter that would do this.
On another worksheet, I am attempting to create a histogram to show distribution of retail price. I am also having trouble doing this because after creating a bin for the retail price, it does not give me an option to create a histogram with it. I am a new to this software so any help would be great! Thanks!