All ideas
IMDB MOVIE ANALYSIS DOUBT
TASK 1- i had used these formulas as you have told MEAN:- =AVERAGE(IF($A$2:$A$3757,C2,$B2$B3757)) MEDIAN:-=MEDIAN(IF($A$2:$A$3757=C2,$B2$B3757)) MODE:-=MODE(IF($A$2:$A$3757=C2,$B2$B3757)) MAX:- =MAX(IF($A$2:$A$3757=C2,$B2$B3757)) MIN:- =MIN(IF($A$2:$A$3757=C2,$B2$B3757)) STDEV:- =STDEV.P(IF($A$2:$A$3757=C2,$B2$B3757)) VAR:- =VAR.P(IF($A$2:$A$3757=C2,$B2$B3757)) BUT SOME CELLS ARE NOT SHOWING RESULT I HAD ATTACHED THE IMAGE OF EXCEL SHEET PLEASE CHECK IT AND TELL ME WHY IT IS COMING LIKE THIS.
