Question
he spreadsheet shows the length of 3 movies in each of 3 categories. Choose the formula that could be used in cell B2.
A
B
C
D
E
1
Type of Movie
Movie 1
(min. long)
Movie 2
(min. long)
Movie 3
(min. long)
Mean Length
2
Animated
72
63
84
73
3
Drama
92
104
113
103
4
Action
119
84
109
104
A. 3 * E2 - (B2 + D2)
B. 3 * E2 - (C2 + D2)
C. 3 * E3 - (C3 + D3)
D. (B3 + C3 + D3)/3
A
B
C
D
E
1
Type of Movie
Movie 1
(min. long)
Movie 2
(min. long)
Movie 3
(min. long)
Mean Length
2
Animated
72
63
84
73
3
Drama
92
104
113
103
4
Action
119
84
109
104
A. 3 * E2 - (B2 + D2)
B. 3 * E2 - (C2 + D2)
C. 3 * E3 - (C3 + D3)
D. (B3 + C3 + D3)/3
Answers
Hairy
i came up with b