ScenarioThe recent pandemic greatly affected the working environment. According to a survey, post-pandemic employees aremore than ever demanding changes to policies and benefits in the workplace.Your organization, XYZ Company, notes several hurdles to attracting and retaining staff in the post-pandemic climate. Oneexample is the employer's inability to adjust to the remote work arrangement, and another is a lack of pay equitycommitment.In keeping with XYZ Company's goal to treat employees well, management is looking for feedback to measure thecompany's performance as the employer of choice.You work as the Manager of Workforce Analytics within the Human Resources department. The company is growingrapidly, and your boss, Jane, who is the Chief People Officer (CPO), wants to make sure that the company is treating itsemployees equitably. She is analysis-driven, so she taps you to work on several projects to uncover any potential issues.Her objectives are to:1. Describe the current state of salary data using the measures of central tendency and variability.2. Give a point estimate and construct a confidence interval of the number of employees who want to work remotely.3. Conduct a hypothesis test from two populations, male employees and female employees, of a claim that they havethe same mean salary.4. Test a claim that employee pay is on par with industry standards with a hypothesis test from one population.5. Apply a normal distribution to review the current dental insurance plan expenses.6. Identify any correlation between seniority and pay.7. Conduct a regression analysis between employee age and salary.Let's get started and gather insights into the workforce data.

Question: Hypothesis Testing Click the 'scenario' button below to review the topic and then answer the following question: The leadership wants to ensure that the employee pay is on par with industry standards. For an engineering manager, the industry average is $170,000. Using a 0.05 significance level, construct a confidence interval (round to dollar) to test the claim that for the engineering managers in the company, the mean salary is at least $170,000. State the null hypothesis and alternative hypothesis in symbolic form using transliteration 'mu', and find the sample mean salary. Explain whether you reject or fail to reject the null hypothesis, and state a final conclusion that addresses the original claim. Scenario : Inferential Stats\fAge | 1 Gender Country Race/Ethnicity Department Position 29 Male United States Management Level Asian Salary Engineering 35 Male Software Development Engineer United States Employee Asian $113,995 Engineering 25 Male Staff Software Development Engineer United States Employee Asian $146,412 Engineering Software Development Engineer Employee 28 Male United States $98,752 Asian Engineering Software Development Engineer Employee 38 Male United States $102.143 White Solution Engineers Senior Solution Engineer Employee $215,000 64 Male United States White Field Sales Major Account Manager Employee $270,900 42 Male United States White Professional Services Services Consultant Employee $116,110 49 Male United States Asian Engineering Director Software Development Engineering Director $270,634 35 Male United States Asian Technical Support Technical Support Engineer Employee $93, 197 62 Male United States White Engineering Data Researcher Employee $84,435 42 Male United States Asian Product Management Product Management Professional Employee $146,036 52 Male United States White Professional Services Services Consultant Employee $128,073 48 Female United States White Field Sales Regional Vice President Field Sales Regional Vice President $360,900 36 Male United States Asian Engineering Senior Software Development Engineer Employee $129,302 31 Female United States White Product Management Senior UX Designer Employee $113,720 49 Female United States White Finance Executive Assistant Employee $131,320 48 Female United States White Finance Credit/Collections Support Specialist Ill Employee $58,711 38 Female United States White Finance Senior Accountant Employee $97,280 $138,955 49 Female United States Asian IT Senior Manager IT Operations Senior Manager $111,916 46 Female United States White Marketing Event Marketing Manager Manager Employee $86,493 38 Female United States Asian Finance Sales Compensation Analyst Employee $233,400 60 Male United States White Solution Engineers Business Value Advisor Vice President $241,570 57 Female United States White Technical Support Vice President Technical Support United States Asian Senior Desktop Support Specialist Employee $70, 666 32 Male Executive Assistant Employee $113,410 49 Female United States White Sales Senior Director Content Senior Director $188,208 62 Male United States White Marketing Senior Manager $130,543 United States White Marketing Senior Manager Marketing Channels and Operations 33 Female Employee $85,670 27 Female United States White Marketing Senior Digital Marketing Manager Employee $112,838 United States $125,200 37 Male Two or More Races Customer Success Senior Services Consultant Customer Success Principal Technical Account Manager Employee United States White Senior Manager $184,555 50 Female Engineering Senior Manager Site Reliability Engineering $96,270 33 Male United States Two or More Races United States White Marketing Senior Corporate Communications Specialist Employee 30 Female Business Development Specialist Employee $63,554 26 Male United States Black or African American Sales Vice President $317,982 Human Resources Vice President Human Capital $66,035 58 Male United States White IT Assoc Programmer/ Analyst Employee 26 Male United States White Customer Success Customer Success Manager Employee $115,920 Employee $56,450 52 Female United States White Marketing Partner Marketing Manager $234,500 24 Female United States Field Sales Major Account Manager Employee $72,279 44 Male United States White upport Engineer Employee Asian Technical Support Employee $105, 756 29 Female United States Executive Assistant $62,735 40 Female United States White Marketing IT Desktop Support Technician Employee $220,358 Director 56 Male United States Asian Human Resources Director Recruiting $130,370 Employee 48 Male United States White Senior HR Business Partner $86,660 White Human Resources Employee 33 Female United States Marketing Senior Graphics Designer $125,820 Employee United States White Marketing Product Marketing Manager $130,420 35 Female Employee $88,420 38 Female United States White Enterprise Regional Account Manager Asian Field Sales Employee 30 Male Senior Recruiter $101,092 142 United States Human Resources Employee $84, 735 143 30 Female United States White Finance Senior Financial Planner/ Analyst Employee $98 752 White Customer Success Manager 144 31 Female United States Customer Success Employee White Software Development Engineer 145 34 Male United States Engineering 146 28 Female United States Asian DatasetE F G H Gender Country Race/Ethnicity Department V Position Management Level Salary 28 Female United States Asian Engineering Software Development Engineer Employee $98,752 40 Female United States White Sales Revenue Enablement Manager Employee $157,959 33 Male United States Asian Technical Support Technical Support Engineer Employee $72, 146 29 Female United States White Finance Senior Accountant Employee $91,024 58 Male United States White Field Sales Major Account Manager Employee $280,900 41 Male United States White Field Sales Major Account Manager Employee $270,900 39 Female United States White Sales Revenue Enablement Manager Employee $137,480 24 Male United States White Finance Sales Compensation Analyst Employee $55,900 48 Male United States White Field Sales Major Account Manager Employee $260,900 55 53 Male United States White Field Sales Major Account Manager Employee $280,900 156 59 Male United States White Field Sales Major Account Manager Employee $270,900 157 51 Female United States White Facilities Receptionist II Employee $21,584 158 35 Female United States White Finance Accounting Support Specialist II Employee $58, 192 159 57 Male United States White Field Sales Major Account Manager Employee $285,900 160 28 Male United States Two or More Races Customer Success Customer Success Manager Employee $104, 150 161 31 Male United States Asian Product Management UX Designer Employee $102, 192 162 55 Male United States White Field Sales Major Account Manager Employee $280,900 163 54 Male United States White Field Sales Major Account Manager Employee $280,900 164 56 Female United States White Product Management Senior Vice President Product Management Senior Vice President $428,400 165 53 Male United States White Field Sales Major Account Manager Employee $280,900 39 Female United States Asian Product Management Vice President Product Management Vice President $322,820 166 55 Male United States White Field Sales Major Account Manager Employee $274,400 167 168 34 Female United States White Finance Senior Manager Accounting Senior Manager $163,720 $115,088 169 46 Female United States White Professional Services Services Project Manager Employee Major Account Manager Employee $280,900 170 40 Female United States White Field Sales 171 56 Female ited States Asian Field Sales Major Account Manager Employee $260,900 Vice President $354,620 51 Male United States White Finance Vice President Corporate Development 172 $316,525 173 36 Male United State Asian duct Mana Senior Director Product Management Senior Director Senior Director $238,400 174 49 Female United States Asian Product Management Senior Director Product Management 175 25 Female United States White Customer Success Services Consultant Employee $74,025 176 White Product Management UX Designer Employee $132,900 37 Female United States Employee $270,420 177 54 Male United States White Field Sales Major Account Manager Employee $200,420 178 29 Male United States White Solution Engineers Senior Solution Engineer United States White Solution Engineers Solution Engineer Employee $155,420 179 30 Male Human Resources Senior Recruiter Employee $80,420 180 28 Female United States Hispanic or Latino Major Account Manager Employee $260,420 181 62 Male United States White Field Sales Content Specialist Employee $84,020 182 35 Female United State White Marketing Hispanic or Latino Marketing Senior Director Demand Generation Senior Director $287,920 183 44 Female United States Major Account Manager Employee $280,420 184 51 Male United States White Field Sales Employee . $88,420 Content Engineer 185 28 Male United States Asian Engineering Manager $121,420 33 Male United States White Finance Manager Accounting 186 Manager $180,420 Manager Consulting Services 187 63 Female United States White Professional Services Employee $180,420 188 26 Male United States White Field Sales Regional Account Manager $127,420 Senior UX Designer Employee 189 36 Female United States Hispanic or Latino Product Management Employee $88, 420 United States Asian Engineering Content Engineer 190 25 Male Project Manager Creative Employee $77,420 191 31 Female United States White Marketing $115,920 192 United States Hispanic or Latino Customer Success Manager Employee 47 Male Customer Success Business Development Specialist Employee $60,420 193 22 Male United States White Sales White Field Sales Major Account Manager Employee $280,420 $300 420 194 40 Male United States Major Account Manager Employee 195 43 Male I Inited States White Field Sales Dataset ReadyG Age Gender Country Race/Ethnicity Department Position Management Level V Salary ZZ Male United States Vvnite Sales Business Development Specialist Employee $60,424 40 Male United States White Field Sales Major Account Manager Employee $280,420 43 Male United States White Field Sales Major Account Manager Employee $300,420 25 Male United States White Sales Business Development Specialist Employee $60,420 46 Male United States White Field Sales Major Account Manager Employee $300,420) 24 Male United States White Sales Business Development Specialist Employee $60,420 44 Male United States White Solution Engineers Solution Engineer Employee $170,420 22 Male United States White Technical Support Technical Support Engineer Employee $60,920 White Sales Business Development Specialist Employee $60,420 28 Male United States $95,420 26 Male United States White Finance Senior Financial Planner/ Analyst Employee Engineering $88,420 25 Male United States Asian Content Engineer Employee $60,420 23 Male United States White Sales Business Development Specialist Employee United States Major Account Manager $300,420 43 Male White Field Sales Employee Employee $60,420 22 Male United States White Sales Business Development Specialist $125,420 30 Female Product Management Employee United States White Senior UX Designer Major Account Manager Employee $280,420 42 Male United States White Field Sales United States White Engineering Vice President 46 Male Vice President Engineering $399, 152 $270, 151 40 Male United States White Engineering Senior Director Engineering Senior Director Engineering Director $232, 170 41 Female United States Asian Director Software Development Engineering Employee $255,420 33 Male United States White Field Sales Major Account Manager Technical Support Senior Technical Support Engineer Employee $69, 126 34 Male United States White $104,920 White Product Management Product Management Professional Employee 25 Female United States Employee $172,900 29 Male United States White Solution Engineers Senior Solution Engineer $90, 164 United States White Technical Support Senior Technical Support Engineer Employee 47 Male Employee $106,020 28 Female United States White Customer Success Customer Success Manager Employee $104,920 United States White IT Senior System Administrator 38 Male Technical Support Engineer Employee $69,280 43 Male United States White Technical Support Senior Services Consultant Employee $136, 406 United States Black or African American Professional Services Employee $62,735 46 Male United States White IT Senior Desktop Support Technician Employee $117,900 45 Female Professional Services Senior Services Consultant $66,420 46 Male United States White Technical Support Engineer Employee 32 Male United States White Technical Support $50,420 Desktop Support Specialist Employee Hispanic or Latino IT Employee $152,220 23 Male United States Customer Success Principal Technical Account Manager $200,420 36 Male United States Hispanic or Latino Employee Solution Engineers Solution Engineer 48 Male United States White