TrainityTrainity
All ideas

IMDB

Task A- i had separated the genres and then find the unique genres, now i had genres in column A , IMDB score in column B, and unique genres in column C, and following formula i had used MEAN= =AVERAGE(A2:A3757, C2, B2:B3757), and then drag this formula down for each unique genre. MEDIAN= =MEDIAN(B2:B3757)and then drag this formula down for each unique genre. MODE= =MODE(B2:B3757)and then drag this formula down for each unique genre. MAX= =MAX(B2:B3757)then drag this formula down for each unique genre. MIN= =MIN(B2:B3757)and then drag this formula down for each unique genre. STDEV= =STDEV(A2:A3757, C2, B2:B3757) then drag this formula down for each unique genre. VARIANCE= =VAR(A2A3757, C2, B2:B3757) then drag this formula down for each unique genre. i had attached the image also , please tell me if it is correct or not.