Identify the оutliers аmоng the AGI vаlues fоr the counties in “RаwData1” Tap, and highlight both the outliers and erroneous values in yellow. The criteria for identifying outliers and erroneous values are as follows: TaxData_Final2.xlsx Outlier: Cases where the Z-score of the AGI is less than -3 or greater than 3; alternatively, cases where the AGI value is greater than the average plus 3 times the standard deviation, or less than the average minus 3 times the standard deviation. Erroneous Value: Cases where the value for "Total Number of Tax Returns" is negative or is greater than the "Adjusted Gross Income (In Thousands)." Identify and delete the erroneous values within “RawData2” Tap. Subsequently, by using the cleaned data, fulfill the following requirements (Erroneous Value Condition: A value is considered erroneous if the "Total Number of Tax Returns" is negative or exceeds the "Adjusted Gross Income (In Thousands).”): Create a pivot table on a new tab using the cleaned data. Generate a pivot table with an AGI range spanning from a minimum of 10 to a maximum of 150, using an interval of 20. Then, highlight the background color of the cell containing the count of counties with an AGI between 30 and 50 in yellow. Create another new pivot table on a separate new tab using the cleaned data. Generate a pivot table with an AGI range spanning from a minimum of 10 to a maximum of 150, using an interval of 20. Then, identify the state with the highest number of counties where the AGI exceeds 70. Finally, highlight the background color of the cell containing that state's name in yellow.