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
i came up with b
To find the mean length of movies in each category, you need to calculate the average (mean) of the lengths of the three movies of that category.
In this case, you want to find the formula for cell B2, which corresponds to the mean length of the animated movies.
The correct formula to use would be option D. (B3 + C3 + D3)/3
Explanation:
- B3, C3, and D3 represent the lengths of the three movies in the "Animated" category.
- The sum (B3 + C3 + D3) will give you the total length of those three movies.
- Dividing the sum by 3 will give you the average, or mean, length of the three movies in that category.
So, using option D as the formula for cell B2 will calculate the mean length of the animated movies.