The 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
