excel 2007

I have to average students test scores but if they have taken all five tests, I need to drop the lowest score before averaging

  1. 👍 0
  2. 👎 0
  3. 👁 26
asked by T
  1. What is your question?

  2. I need an excel formula that averages students test scores, dropping the lowest score if all 5 tests are taken

    1. 👍 0
    2. 👎 0
    posted by T
  3. I don't know that there is a program within Excel that does that. You can write one yourself, however.

    1. 👍 0
    2. 👎 0
    posted by DrBob222

Respond to this Question

First Name

Your Response

Similar Questions

  1. programming

    Professor Merlin has asked you to help him. He has 5 students who have taken four tests. He wants a program where he can enter the students name and their four test scores. After entering all 5 students then he wants a grade

    asked by Ajit on July 24, 2014
  2. graduate statistics

    A nursing professor was curious as to whether the students in a very large class she was teaching who turned in their tests first scored differently from the overall mean on the test. The overall mean score on the test was 75 with

    asked by Anonymous on July 3, 2013
  3. Math

    In your​ class, you have scores of 73,85,76, and 92 on the first four of five tests. To get a grade of Upper C, the average of the first five tests scores must be greater than or equal to 70 and less than 80. a) Solve an

    asked by Ms. E on September 30, 2015
  4. Math

    105 91 82 59 97 72 72 88 81 What is the mode of these scores? A.46 B.72 C.82 D.83 B? 2.The test scores of 1 students are shown below 95 63 78 86 84 86 91 95 72 93 87 74 What is the median score of the 6 highest grades? A.86 B.91

    asked by Jerald on March 21, 2013
  5. Word Problem

    A math teacher gives two different tests to measure students' aptitude for math. Scores on the first test are normally distributed with a mean of 25 and a standard deviation of 4.6. Scores on the second test are normally

    asked by Lyndse on March 7, 2010
  6. Algebra

    A student is taking a literature course in which four tests are given. To get a B, he must average at least 80 on the four tests. The student got scores of 82, 76, and 78 on the first three tests. Determine (in terms of

    asked by Liz on October 31, 2011
  7. Math algebra

    To find the average of a set of test scores we divide the sum of the test scores by the number of test scores. On her first four algebra tests,Paula wests scored 88,92,97,and 96. Write an equation that can be used to determine the

    asked by Serena on November 10, 2016
  8. math

    A professor grades students on three tests, four quizzes, and a final examination. Each test counts as two quizzes and the final examination counts as two tests. Sara has test scores of 60, 80, and 89. Sara's quiz scores are 85,

    asked by lisa on March 24, 2013
  9. math

    A professor grades students on three tests, four quizzes, and a final examination. Each test counts as two quizzes and the final examination counts as two tests. Sara has test scores of 60, 80, and 89. Sara's quiz scores are 85,

    asked by tommy on March 24, 2013
  10. math

    Jill knows her average score on five tests is 88. She can find all but one test. She has tests with scores of 96,83,100, and 79. What is the missing test?

    asked by Nelson on April 8, 2011

More Similar Questions