You have new items in your feed. Click to view.
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.
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
Rating

*
Get answers from Weegy and a team of really smart lives experts.
S
L
Points 247 [Total 265] Ratings 0 Comments 177 Invitations 7 Offline
S
L
Points 130 [Total 130] Ratings 0 Comments 130 Invitations 0 Offline
S
L
R
Points 125 [Total 276] Ratings 1 Comments 5 Invitations 11 Offline
S
R
L
R
P
R
P
R
Points 66 [Total 734] Ratings 0 Comments 6 Invitations 6 Offline
S
1
L
L
P
R
P
L
P
P
R
P
R
P
R
P
P
Points 62 [Total 13329] Ratings 0 Comments 62 Invitations 0 Offline
S
L
1
R
Points 34 [Total 1450] Ratings 2 Comments 14 Invitations 0 Offline
S
L
Points 10 [Total 187] Ratings 0 Comments 0 Invitations 1 Offline
S
Points 10 [Total 13] Ratings 0 Comments 10 Invitations 0 Offline
S
Points 10 [Total 10] Ratings 0 Comments 0 Invitations 1 Offline
S
Points 2 [Total 2] Ratings 0 Comments 2 Invitations 0 Offline
* Excludes moderators and previous
winners (Include)
Home | Contact | Blog | About | Terms | Privacy | © Purple Inc.