Question: Please help me understand what i am doing wrong in the empty cells: Several statistics refer to outliers. In this problem, an outlier is a

Please help me understand what i am doing wrong in the empty cells:

Several statistics refer to outliers. In this problem, an outlier is a value that is greater than or equal to the 90th percentile value. To calculate the percentile, use the PERCENTILE.INC() function, not the deprecated PERCENTILE() function. You can use this function to establish a threshold of acceptance (the formula result is the value under which 90% of data points are found when arranged in increasing order).

Please help me understand what i am doing wrong in the empty

= Solution must feature SUMIF() and no other functions = Solution must feature MAXIFS() and no other functions = Solution must feature AVERAGEIFS() and no other functions = Solution must feature AVERAGE() and FILTER() function, and no other functions = Solution must feature COUNTIF() = Solution must feature COUNTIFS(), and cannot feature FILTER() or ROWS() = Solution must feature SUMIFS(). Display either TRUE or FALSE. Solution cannot feature FILTER(), IF()/IFS(), SUM(), or SUMIF(). You will need to hard-code the cornerarrow values into the formula. = An outlier is defined as equal to, or above, the 90th percentile value. Solution must feature FILTER() and not feature IF/IFS() = Solution must reference the cell with the outlier cutoff calculation (C19). Solution must feature AVERAGEIFS(), but no other functions = Solution must reference the cell with the outlier cutoff calculation (C19). Solution must feature AVERAGE() and FILTER(), but no other functions = Solution must feature INDEX(), MATCH() and MINIFS(). Solution cannot feature LARGE() = Solution must feature FILTER() and MAXIFS(). Solution cannot feature LARGE(), XLOOKUP(), INDEX(), MATCH(), or XMATCH() = Solution must feature SUMIF() and no other functions = Solution must feature MAXIFS() and no other functions

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!