2.1 Scenario Your company has previously commissioned you, Minjee lee {Chief Analyst), to develop a survey to help them obtain an overview of all facets of the company's employees. Now, in order to obtain a better understanding of the make up and type of their employees, your CEO {Margot Robbie), wants you to process and analyse the data set and then answer several questions. The questions you need to answer are contained in the following memorandum. Margot does not have an analytics background, so it's important that you utilise \"plain, easy to understand language\" in your answers. If you believe you need to include anytechnical terms, then you must explain these in a clear and succinct manner using layman's terms. 2.2 Memorandum Date: 25th August, 2022 To: Minjee Lee, Chief Analyst From: Margot Robbie, CEO Subject: Analysis of Employee Survey Data Dear Minjee, Can you please carry out an analysis of the recent Employee Survey data [contained in the file EmployeeSurvey.xlsx] and prepare a report containing answers to the following questions. Q1. Summaries of key variables of interest Can you please provide me with separate summaries of the following variables,just by themselves? In other words, please investigate each variable individually without reference to any other variable in the dataset. [3} \"Income\" the amount we paid our employees last financial year. [b] \"JobSatisfaction\" - how satised are our employees working for the organisation. Q2. Exploring relationships between two variables {a} lwould like to know ifthere is a link between the level of annual income {"lncome\") and the number of years our employees have worked since the age of 16 {"Work'r'ears"). Historically I suspect that the more years you worked, the higher your Income becomes, but in order to assist us with future budgeting, I'd like to know if this is still the case. Therefore, I'd like you to establish from your sample data if there is any relationship between these two variables. [b] I'm also interested to establish if there is a relationship between gender ("Gender\") and an individual's status as a union member {"MemberUnion"). {c} Further, it would be helpful if we knew if the age ("Age\") of a person had any relationship to how an employee describes their relations in the workplace with management [\"ManEmployeeRel\"). Q3. Estimating employee measures {a} To assist the organisation with its future budgets, I would like you to estimate the number of hours our employees as a whole would work per week ["WorkHrs\") the days of a 40 hour week have long gone. [b] As you would realise, employee happiness with their organisation has a direct effect on a company's culture and productivity, therefore I'm interested to kn ow if you can estimate the proportion of all employees who are Very Proud or Somewhat Proud ["ProudOrg\") to work for the company. Q4. Employee claims {a} | read a report recently that indicated that the annual salary paid to staff in our industry (\"Income") was $62,000. I'd like to think that we were paying our staff more than this figure. Is there any evidence to suggest that this is the case? (b) Another finding in that report concerned what job characteristics ("JobCharacteristics") were most important to employees. It claimed that less than 40% of employees enjoyed their work. Can you also check this claim against your survey data of our employees? Q5. Appropriate sample size Finally, I am concerned that the sample of 400 employees is too small to provide accurate results as this seems hardly enough data. If we ever decide to survey our employees again, I would like to be able to: (a) calculate approximately the average annual income ("Income") we are paying our staff to within $5,000, and (b) estimate the proportion of employees that are satisfied ( "JobSatisfaction") with their job to within 3%. Therefore, how many employees would we need to include in the next survey to satisfy both of these requirements? Regards, Margot