I want to calculate the median result of poll results where I know the number of votes each option received but the data isn't in the right format for the median function. For example, the Excel data looks like this:
Response: 1 2 3
# Votes: 10 15 10
This data shows that response 1 got 10 votes, response 2 got 15 votes and response 3 got 10 votes so the median is clearly 2. The question is how to get Excel to calculate this since the data isn't in the right format for the median function?
First post so please be kind
Bookmarks