+ Reply to Thread
Results 1 to 3 of 3

8 point rating system

  1. #1
    Registered User
    Join Date
    05-31-2020
    Location
    Mumbai
    MS-Off Ver
    Office 365
    Posts
    1

    8 point rating system

    Dear Team,

    I have a score board system, on a 8 point basis, but when I give it to the jury, the evaluation form would be on 5 point rating scale.
    Even I give, 5 point rating scale, how would that be calculated on 8 score.

    In all I have 13 question, divided in 3 section
    1st Section - 6 question - 4 point
    2nd Section - 4 question - 2 point
    3rd Section - 4 question - 2 point

    Can someone help me.

  2. #2
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,338

    Re: 8 point rating system

    HOW TO ATTACH YOUR SAMPLE WORKBOOK:

    Fast answers need clear examples. Post a small Excel sheet (not a picture) showing realistic & representative sample data WITHOUT confidential information (10-20 rows, not thousands...) and some manually calculated results. Just before posting, scroll down to GO ADVANCED, click, and then scroll down to MANAGE ATTACHMENTS and click again. Now follow the instructions at the top of that screen.
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

  3. #3
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    15,858

    Re: 8 point rating system

    Hi Pranavesh and welcome to the forum,

    You need a common denominator to get both the 8 and 5 system to correclty divide. You need to get to a 40 point scale and then you can do your problem. You have 14 questions which then also implies you need a basis of 7 in your computation. With the 7 as an added factor that takes your 40 point system to a 280 point system. Therefore make each question equal to 40 points and you will be able to reduce your answer to 8 or 5 systems.

    Hope this helps
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. How do I create a rating system?
    By JekyDC in forum Excel General
    Replies: 2
    Last Post: 10-02-2015, 01:55 PM
  2. [SOLVED] Rating system
    By Mavi28 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 08-05-2015, 10:25 PM
  3. ELO Rating system
    By Melis K. in forum Excel General
    Replies: 3
    Last Post: 11-23-2013, 01:06 PM
  4. Rating system build
    By adamwestrop in forum Excel General
    Replies: 10
    Last Post: 08-16-2011, 03:05 PM
  5. Building a rating system
    By adamwestrop in forum Excel General
    Replies: 2
    Last Post: 08-16-2011, 03:59 AM
  6. Rating system
    By TTL in forum Excel General
    Replies: 1
    Last Post: 07-10-2007, 12:17 AM
  7. help with my rating system
    By sarina1113 in forum Excel General
    Replies: 3
    Last Post: 10-05-2006, 05:55 PM

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