In Excel, demonstrate conditional formatting, the countif function, and 1 other function of your own choosing. You will need to find or create your own data for this!
I used conditional formatting with icons to mark all the invalid data (suspected outliers), and the COUNTIF function to count the occurrences in the dataset that fell between a certain range. I also used the CONCATENATE function to format the headers and two other functions to generate the dataset, RAND and RANDBETWEEN. The first generates random numbers between 0 and 1 (to compose the fractional part of the number) and the second generates integers in a range specified by the user. I also created a secondary dataset out of matrix products. I calculated the average and standard deviation of the two datasets by using the AVERAGE AND STDEVP formulas.
