# excel 2007

posted by .

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

• excel 2007 -

• excel 2007 -

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

• excel 2007 -

I don't know that there is a program within Excel that does that. You can write one yourself, however.

## Similar Questions

1. ### Writing inequalities

you must have an average score of at least 80 to get a B on your report card. You have scores of 61,70,99, and 70. What is the minimium score you must get on the last test to get a B on your report card?
2. ### math

A student has a mean score of 88 on five tests taken. What score must she obtain on her next test to have a mean (average) score of 80 on all six tests?
3. ### 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 report …
4. ### Algebra

Tom took five math tests and got an integer score on each of them. He never scored higher than 90, and his lowest score was the fourth test. If his average score, rounded to the nearest integer, was 82, what is the lowest possible …
5. ### Algebra

Tom took five math tests and got an integer score on each of them. He never scored higher than 90, and his lowest score was the fourth test. If his average score, rounded to the nearest integer, was 82, what is the lowest possible …
6. ### 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 inequality …
7. ### statistics

A student has a mean score of five tests taken. What score must she obtain on her next test to have a mean average of 88 on all six tests?
8. ### Math

Karl's scores on the first five science tests are shown in the table. Test 1 Test 2 Test 3 Test 4 Test 5 85 84 90 95 88 Part A. Write am inequality that represents how to find the score he must receive on the sixth test to have an …
9. ### Algebra

Can someone help me with this? You have 2 tests with scores of 83 and 92, assuming you can't get a score over 100 on any test. Determine all possible scores you can get to score an average of 90 on all 3 tests. Represent the answer
10. ### Java

Need help asap. You are given a list of students' names and their test scores. Design an algorithm that does the following: a. Calculates the average test scores. b. Determines and print the names of all the students whose test score …

More Similar Questions