+ Reply to Thread
Results 1 to 2 of 2

Adjusted total based on importance of ranking score

  1. #1
    Registered User
    Join Date
    07-28-2010
    Location
    New Zealand
    MS-Off Ver
    Excel 2002
    Posts
    1

    Adjusted total based on importance of ranking score

    Hi there,

    I'm currently putting together an evaulation form to grade User Interface designs. I need some help creating a formula and it's not really something I'm familiar with.

    I have several criteria that I am ranking out of 5 as well as an "importance" score depending on how important the particular criteria is to the user interface.

    Eg:

    Reading characters on the screen is easy - Score: 4 out of 5 - Importance: 5 out of 5
    Uses Highlighting to help simplify task - Score: 1 out of 5 - Importance: 2 out of 5
    Organisation of information is clear - Score: 5 out of 5 - Importance: 5 out of 5
    Sequence/flow of screens is clear - Score: 3 out of 5 - Importance: 4 out of 5

    For example 'Uses Highlighting to help simplify task' scores poorly (1 out of 5), however it's not really that important to the user interface (2 out of 5).

    So what I need is a formula that can give me an adjusted percentage for the Score and Importance. The Importance score is like a Weighting (is that the right term?) to show a true percentage that can be compared with other user interface evaluations.

    Hopefully this makes sense....any help or advice would be much appreciated!

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Adjusted total based on importance of ranking score

    The weighted score is the sum of the products of the scores time the importance values divided by the sum of the importance values.
    Entia non sunt multiplicanda sine necessitate

+ Reply to Thread

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