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