USING MICROSOFT EXCEL
USING THE RIGHT LEFT AND MID FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Use a function to calculate the average of the Movie Scores column where the Movie Genre is Horror.
|
|
=AVERAGE
|
|
|
=AVERAGEIF
|
|
|
=SUM
|
|
|
=SUMIF
|
Explanation:
Detailed explanation-1: -Multiply the number of individuals selecting each rating by the corresponding rating value (1 – 5) Add the results of those calculations together. Divide that result by the total number of responses to the question.
Detailed explanation-2: -The AVG() function returns the average value of a numeric column.
Detailed explanation-3: -The average length for action, adventure, comedy, drama, fantasy, horror and romance movies is around 92 minutes, while for animations and documentaries is approximately 74 minutes.
Detailed explanation-4: -The “empirical method” identifies the genre of a film by comparing it to a list of films already deemed to fall within a certain genre.
There is 1 question to complete.