The spreadsheet shows the length of 3 movies in each of 3 categories. Choose the formula that could be used in cell B2.
Answer: Option 'B' is correct.
Step-by-step explanation:
Since we have given that
There are three types of movies :
1) Animated
2) Drama
3) Action.
Since At B2 cell, there is Animated movie.
Since we have given the average of three animated movies = 73
Length of 1 movie is at B2 cell.
Length of 2nd movie = 63
Length of 3 rd movie = 84
As we know the formula for "average":
[tex]Average=\dfrac{\text{Sum of all observations}}{\text{Total number of observations}}\\\\\\73=\dfrac{B2+63+84}{3}\\\\3\times 73=B2+63+84\\\\3\times E3-(C2+D2)=B2[/tex]
Hence, Option 'B' is correct.