Results 1 to 3 of 3
  1. #1
    Lounger
    Join Date
    Oct 2004
    Posts
    31
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Drop lowest score and Weighted average (Excel 2003)

    I have a couple of questions for you regarding Excel.

    1) Students have taken 5 quizzes and their lowest grade can be dropped. How can I have Excel automatically drop each student

  2. #2
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Drop lowest score and Weighted average (Excel 2003)

    1- This formula will average the four highest grades in B2:F2

    <pre>=AVERAGE(LARGE(B2:F2,{1,2,3,4}))
    </pre>


    2- Would this do what you want:

    Final Grade = .2 * LabQuiz + .35 * LabReport + .45 * WhateverMakesUpTheRest
    Legare Coleman

  3. #3
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Drop lowest score and Weighted average (Excel 2003)

    Another technique for #2 (adapt as needed)
    Imagine row 1 and 2 as header
    rows 3 - whatever are student grades
    If col A has names, Col B is for final grade, Col C has "Lab Quiz" grade, Col D has "Lab Report" grade, Col E has the "rest", etc

    In A2 have headers, "Name", B2 is for "final grade", C2 "Lab Quiz", D2 "Lab Report", Col E "Rest",etc
    C1 has 20%, D1: 35%, E1: 45%

    In B3 you can add the formula:
    =sumproduct($C$1:$E$1,C3:E3)

    Then you can copy this down all the rows. You can expand the number of columns and number of "weights" as desired. TO change the weights only involves changing the items in row 1.

    Steve

Posting Permissions

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