[Please name the tab as “population”] Population Standardiza…

[Please name the tab as “population”] Population Standardization and Analysis You are provided with a dataset containing the quarterly population of various states. To compare the population distribution across different time periods, you need to standardize the data for each quarter. ReferenceQuestion_Midterm_Population2.xlsx [Tasks] Calculate Statistics: Calculate the Mean and Standard Deviation (STDEV.S as specified by the instructor) for each quarter (column). Standardize Data: Create a new table (Standardized Population Table) where each population value is standardized using the formula: Note: You must use appropriate Absolute/Mixed References ($) so that a single formula can be applied to the entire table. Count Specific Outliers: Using the standardized table, count how many standardized values (Z-scores) are greater than 1. [Question] How many standardized population values across all quarters and all states are greater than 1?