For the assessment of Foundation skills in data analytics, you need to investigate the dataset interpret the result and than draw the conclusion while analysis the technomart (fictitious company) for

Memorandum

To: Madison Thomson, MDB Corporation

From: Emma Saward, TechnoMart Industries

Subject: Analysis of TechnoMart Industries employee satisfaction survey

Dear Madison,

Management is concerned about the wide variation in work hours between TechnoMart employees and whether factors like employee job satisfaction, occupation and union membership play any part in this variation. TechnoMart also has staff planning issues that need addressing, including planning to replace workers who retire, undertaking a recruitment drive for new employees and providing adequate promotion opportunities within the company.

As part of the last Enterprise Bargaining Agreement, we agreed with the unions that work hours would be reviewed, for all employees. Where possible, employees should not be working excessive amounts of overtime. I know that you recently undertook a survey of employees in TechnoMart. Could you please provide me with answers to the following questions?

1. An overall view of work hours at TechnoMart

1. Provide me with an overall summary of hours worked at TechnoMart, keeping in mind that the normal working week is 40 hours. Please also include commentary on any employees in terms of unusual work hours.

2. I’m also interested in whether we have many employees that are working more than 40 hours. Can you provide me with an accurate estimate of the total number of employees across the whole organization who would work more than 40 hours? Likewise, how many are working more than 60 hours?

2. Comparison of union and non-union members

In addition to the overall analysis you are carrying out for work hours, I am interested in how union members in the company compare to non-union members in regard to a few key variables. In particular, I want you to investigate how union members and non-union members compare in regard to: (a) Hours worked

1. Occupation

2. Job satisfaction

Based on the above, can you provide me with a brief summary of how the two groups compare.

1. Predicting Pre-Tax Income

Of all the variables you have collected, is there any one that stands out as a possible explanation or predictor of those people likely to achieve a higher pretax income than others do?

1. Workers approaching retirement

Senior management are concerned that over the next few years the company will need to undertake a large recruitment drive as our workforce is aging and a substantial number of employees will be retiring. Can you provide me with an estimate of the:

1. average age of TechnoMart employees

2. average time our employees have been working at TechnoMart

5. Union membership

In a recent Enterprise Bargaining meeting, the union made a number of claims that I would like you to check.

1. It was also mentioned that our employees are very loyal to the company and that the union believed the average length of employment at TechnoMart would exceed the industry average of 7.5 years. Could you check if this claim is true for all employees? What about for only male employees? What about only for female employees?

2. There is some speculation that the union members work at least 45 hours per week. Is there any way of confirming this?

6. Future Surveys

Finally, I am interested in your opinion about future surveys of our employees.

1. I am concerned that a sample of only 400 employees seems too small compared to the population of 9800. Could you explain to me how we calculate an ideal sample size?

2. Of particular interest to me is being able to accurately estimate the size of the problem we have with staff working excessive hours (i.e. more than 60 hours a week). In other words, in order to accurately estimate the size of our overtime problem, do I have a sufficient number of staff in my sample who work more than 60 hours? If not, how many should be sampled?

I look forward to your response.

Sincerely,

Emma Saward