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.
27,015,224 questions answered
Popular Conversations
Body composition refers to the amount of fat and muscle that the body ...
Weegy: Body composition refers to the amount of fat and muscle that the body has. TRUE.
5/27/2017 12:17:58 PM| 1 Answers
Name the following chemical compound. K2CO3 A. krypton carbonate ...
Weegy: K2CO3 is a symbol for: Potassium Carbonate User: Name the following chemical compound. K3N A. krypton ...
5/27/2017 5:46:29 PM| 1 Answers
Giving human characteristics to objects or ideas is
Weegy: Giving human characteristics to objects or ideas is PERSONIFICATION.
5/19/2017 10:58:38 PM| 1 Answers
Calculate the product 1/3 and 1/5
Weegy: The product of 1/3 and 1/4 is 1/12. Solution: 1/3 * 1/4 = 1/12
5/23/2017 9:39:31 PM| 1 Answers
2n - 1, where n = 7
Weegy: 2n - 1, where n = 7; 2*7 - 1 = 14 - 1 = 13
5/27/2017 3:20:32 PM| 0 Answers
The position from which you write about your subject is called your ...
Weegy: The position from which you write about your subject is called your point of view.
5/27/2017 3:19:05 PM| 0 Answers
Weegy Stuff
S
Points 26 [Total 26] Ratings 0 Comments 26 Invitations 0 Offline
S
Points 11 [Total 11] Ratings 0 Comments 1 Invitations 1 Offline
S
Points 10 [Total 10] Ratings 1 Comments 0 Invitations 0 Offline
S
Points 10 [Total 10] Ratings 1 Comments 0 Invitations 0 Offline
S
Points 10 [Total 366] Ratings 1 Comments 0 Invitations 0 Offline
S
Points 10 [Total 10] Ratings 1 Comments 0 Invitations 0 Offline
S
Points 10 [Total 10] Ratings 1 Comments 0 Invitations 0 Offline
S
P
P
L
P
P
P
Points 7 [Total 1730] Ratings 0 Comments 7 Invitations 0 Offline
S
Points 2 [Total 2] Ratings 0 Comments 2 Invitations 0 Offline
S
Points 2 [Total 467] Ratings 0 Comments 2 Invitations 0 Offline
* Excludes moderators and previous
winners (Include)
Home | Contact | Blog | About | Terms | Privacy | © Purple Inc.