Results 1 to 9 of 9

Help with calculation of median

Threaded View

sssss Help with calculation of... 03-26-2010, 08:44 AM
NBVC Re: Help with calculation of... 03-26-2010, 08:50 AM
sssss Re: Help with calculation of... 03-26-2010, 09:05 AM
Dav Re: Help with calculation of... 03-26-2010, 09:20 AM
NBVC Re: Help with calculation of... 03-26-2010, 09:24 AM
DonkeyOte Re: Help with calculation of... 03-26-2010, 09:25 AM
sssss Re: Help with calculation of... 03-26-2010, 09:29 AM
NBVC Re: Help with calculation of... 03-26-2010, 09:32 AM
sssss Re: Help with calculation of... 03-26-2010, 09:43 AM
  1. #1
    Registered User
    Join Date
    03-26-2010
    Location
    London
    MS-Off Ver
    Excel 2003
    Posts
    4

    Help with calculation of median

    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
    Last edited by sssss; 03-26-2010 at 09:44 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1