B2: In Cell E1, type in Outlier Based on z-Score. In Column E, utilize an If statement to categorize the Z-score in Column D as an Outlier or not by classifying an Outlier as a z-score that is greater than 3 or less than - 3. Make sure that if the cell in D is between -3 and 3, the corresponding cell in E says Not Outlier, otherwise it says Outlier. D2 X Vfx =STANDARDIZE(C2,ChickenPartsData!$D$3256, ChickenPartsData!$D$3261) B D F 1 2 3 4 5 6 7 8 9 10 9/1/20 B/S THIGHS 9/1/20 BACKS AND NECKS (STRIPPED) 9/1/20 BREAST-B/S 9/1/20 BREAST- LINE RUN 9/1/20 BREAST-WITH RIBS 9/1/20 DRUMSTICKS 9/1/20 GIZZARDS (HEARTS) 9/1/20 LEG QUARTERS (BULK) 9/1/20 LEGS 9/1/20 LIVERS (5 POUND TUBS) 9/1/20 TENDERLOINS 9/1/20 THIGHS 9/1/20 WINGS (WHOLE) 9/2/20 B/S THIGHS 9/2/20 BACKS AND NECKS (STRIPPED) 9/2/20 BREAST-B/S 9/2/20 BREAST- LINE RUN 9/2/20 BREAST - WITH RIBS 9/2/20 DRUMSTICKS 9/2/20 GIZZARDS (HEARTS) 9/2/20 LEG QUARTERS (BULK) 9/2/20 LEGS 9/2/20 LIVERS (5 POUND TUBS) 9/2/20 TENDERLOINS 9/2/20 THIGHS 9/2/20 WINGS (WHOLE) 9/3/20 B/S THIGHS 9/3/20 BACKS AND NECKS (STRIPPED) 9/3/20 BREAST-B/S 9/3/20 BREAST- LINE RUN 9/3/20 BREAST - WITH RIBS 9/3/20 DRUMSTICKS 9/3/20 GIZZARDS (HEARTS) 9/3/20 LEG QUARTERS (BULK) 9/3/20 LEGS 83 Z-score Outlier Based on Z-Score Number of outliers based on Interquartile Range 10] -1.1342834 115 0.27705183 75 -0.2605997 75 -0.2605997 32 -0.8385751 75 -0.2605997 22 -0.972988 40 -0.7310448 65 -0.3950126 175 1.08352911 28 -0.8923402 196 1.36579616 81 -0.179952 10 -1.1342834 115 0.27705183 75 -0.2605997 75 -0.2605997 32 -0.8385751 75 -0.2605997 22 -0.972988 40 -0.7310448 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 65 -0.3950126 175 1.08352911 27 -0.9057815 196 1.36579616 79 -0.2068345 10 -1.1342834 115 0.27705183 75 -0.2605997 75 -0.2605997 32 -0.8385751 75 -0.2605997 22 -0.972988 40 -0.7310448 B2: In Cell E1, type in Outlier Based on z-Score. In Column E, utilize an If statement to categorize the Z-score in Column D as an Outlier or not by classifying an Outlier as a z-score that is greater than 3 or less than - 3. Make sure that if the cell in D is between -3 and 3, the corresponding cell in E says Not Outlier, otherwise it says Outlier. D2 X Vfx =STANDARDIZE(C2,ChickenPartsData!$D$3256, ChickenPartsData!$D$3261) B D F 1 2 3 4 5 6 7 8 9 10 9/1/20 B/S THIGHS 9/1/20 BACKS AND NECKS (STRIPPED) 9/1/20 BREAST-B/S 9/1/20 BREAST- LINE RUN 9/1/20 BREAST-WITH RIBS 9/1/20 DRUMSTICKS 9/1/20 GIZZARDS (HEARTS) 9/1/20 LEG QUARTERS (BULK) 9/1/20 LEGS 9/1/20 LIVERS (5 POUND TUBS) 9/1/20 TENDERLOINS 9/1/20 THIGHS 9/1/20 WINGS (WHOLE) 9/2/20 B/S THIGHS 9/2/20 BACKS AND NECKS (STRIPPED) 9/2/20 BREAST-B/S 9/2/20 BREAST- LINE RUN 9/2/20 BREAST - WITH RIBS 9/2/20 DRUMSTICKS 9/2/20 GIZZARDS (HEARTS) 9/2/20 LEG QUARTERS (BULK) 9/2/20 LEGS 9/2/20 LIVERS (5 POUND TUBS) 9/2/20 TENDERLOINS 9/2/20 THIGHS 9/2/20 WINGS (WHOLE) 9/3/20 B/S THIGHS 9/3/20 BACKS AND NECKS (STRIPPED) 9/3/20 BREAST-B/S 9/3/20 BREAST- LINE RUN 9/3/20 BREAST - WITH RIBS 9/3/20 DRUMSTICKS 9/3/20 GIZZARDS (HEARTS) 9/3/20 LEG QUARTERS (BULK) 9/3/20 LEGS 83 Z-score Outlier Based on Z-Score Number of outliers based on Interquartile Range 10] -1.1342834 115 0.27705183 75 -0.2605997 75 -0.2605997 32 -0.8385751 75 -0.2605997 22 -0.972988 40 -0.7310448 65 -0.3950126 175 1.08352911 28 -0.8923402 196 1.36579616 81 -0.179952 10 -1.1342834 115 0.27705183 75 -0.2605997 75 -0.2605997 32 -0.8385751 75 -0.2605997 22 -0.972988 40 -0.7310448 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 65 -0.3950126 175 1.08352911 27 -0.9057815 196 1.36579616 79 -0.2068345 10 -1.1342834 115 0.27705183 75 -0.2605997 75 -0.2605997 32 -0.8385751 75 -0.2605997 22 -0.972988 40 -0.7310448