Notice: Payments for answers will end 4/10/2017. Click for more info.
You have new items in your feed. Click to view.
Question and answer
Q: Calculate the average for the first student in cell I8. The formula should drop the lowest score before calculating the average. Hint: You need to use three functions: SUM, MIN, AND COUNT. The first
student's assignment average is 94.2 after dropping the lowest assignment score.
A: Try this, =(sum(b8:h8)-min(b8:h8))/(count(b8:h8)-1) .. Hope this helps.
Get an answer
Original conversation
User: Calculate the average for the first student in cell I8. The formula should drop the lowest score before calculating the average. Hint: You need to use three functions: SUM, MIN, AND COUNT. The first student's assignment average is 94.2 after dropping the lowest assignment score.

Weegy: Try this, =(sum(b8:h8)-min(b8:h8))/(count(b8:h8)-1) .. Hope this helps.
batotoy|Points 1475|

User: Calculate the weighted total points based on the four category points (assignment average, lab points, midterm average, and final exam) and their respective weights (stored in the range B40:B43) in cell Y8. Use relative and absolute cell references as needed in the formula. The first students total weighted score is 90.

Question
Asked 2/27/2013 3:25:37 PM
0 Answers/Comments
New answers
Rating

There are no new answers.

Comments

There are no comments.

Add an answer or comment
Log in or sign up first.
26,493,846 questions answered
Popular Conversations
What is the purpose of the mantra during meditation? A. It ...
Weegy: The purpose of the mantra during meditation is: It allows you to concentrate on one peaceful sound. User: ...
11/12/2017 11:54:48 AM| 3 Answers
The following two sentences are saying the same thing. Emily, my ...
Weegy: The following two sentences are saying the same thing. Emily, my daughter, is in sixth grade. Emily, my daughter ...
11/13/2017 12:26:02 PM| 3 Answers
Which one of the following refers to all of the physical and chemical ...
Weegy: Endorphins are neurotransmitters that pass brain signal from one neuron to another. User: Which one of the ...
11/12/2017 6:31:18 AM| 2 Answers
When magma reaches the Earth's surface it's called A. ...
Weegy: The study of the Earth's magnetic field is known as: paleomagnetism. User: What are two of the processes ...
11/21/2017 7:34:39 PM| 2 Answers
Weegy Stuff
S
L
P
Points 176 [Total 301] Ratings 10 Comments 76 Invitations 0 Offline
S
P
L
P
Points 23 [Total 153] Ratings 0 Comments 23 Invitations 0 Offline
S
P
P
L
P
P
Points 20 [Total 1658] Ratings 0 Comments 20 Invitations 0 Offline
S
Points 10 [Total 10] Ratings 1 Comments 0 Invitations 0 Online
S
Points 4 [Total 4] Ratings 0 Comments 4 Invitations 0 Offline
S
Points 1 [Total 1] Ratings 0 Comments 1 Invitations 0 Offline
S
Points 1 [Total 1] Ratings 0 Comments 1 Invitations 0 Offline
S
Points 1 [Total 1] Ratings 0 Comments 1 Invitations 0 Offline
S
Points 1 [Total 1] Ratings 0 Comments 1 Invitations 0 Offline
S
Points 1 [Total 1] Ratings 0 Comments 1 Invitations 0 Offline
* Excludes moderators and previous
winners (Include)
Home | Contact | Blog | About | Terms | Privacy | © Purple Inc.