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.
27,005,373 questions answered
*
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.