Foundation Skills in Data Analysis for TechnoMart

FOUNDATION SKILLS IN DATA ANALYSIS
TECHNOMART
STUDENT ID:
[Pick the date]

Executive Summary
On basis of statistical analysis of the given sample data, a host of conclusions have been
drawn. It has been found that TechnoMart has an overtime employees since there are some
employees which tend to work for unusually long hours which is definitely a concern.
Further, with regards to union, there is no difference with regards to weekly working hours.
However, the satisfaction levels are higher for the non-union members. Besides, the
representation of union members is higher in labour and production department as compared
to other department. With regards to pre -tax income, years of full time work is the most
appropriate estimator from the variables presented. Also, it has been found that company’s
fear with regards to workers approaching retirement is not supported by the sample data.
Besides, the claim regarding loyalty of employees is true for all employees and males but not
females. Also, the current sample is insufficient for the overtime problem that department
aims to address in future surveys.

Introduction
A sample data of 400 employees was collected through an online questionnaire which
pertained to TechnoMart which is an auto parts manufacturer. The same was passed on by the
HR department of the company to MDB Corporation for further analysis so as to derive
meaningful conclusions with regards to key aspects indicated by the HR representative of
TechnoMart. This objective of this report is to present the findings of the data analysis in
view of the various questions that were posed by the HR department at TechnoMart.
Analysis
This section presents the findings from the statistical analysis of the sample data provided in
context of the specific questions that were raised in your memorandum.
Work Hours at TechnoMart
a) Based on the sample data provided, it has been concluded that only 50% of the sample
employees tend to have a normal working week comprising of 40 or less hours. There is a
high degree of variation in the weekly working hours of employees ranging from a minimum
of 28 hours to a maximum of 89 hours. It is apparent that there are certain employees who
tend to work for unusually long working hours. In the given sample data of employees, there
are 13 employees who tend to work in excess of 72 hours a week which would be considered
very unusual considering that the company has a policy of weekly week being of 40 working
hours. On the lower end, there is no such observation whereby any employee is working
unusually low hours (Eriksson and Kovalainen, 2015). Clearly, it seems that the employees
tend to work for significantly longer hours which may be a result of bad work practices or
inefficiency of employees.
b) Based on the sample data provided, estimation has been made with regards to percentage
workers in the whole company working in excess of 40 hours and 60 hours respectively. With
regards to employees in the company working more than 40 hours per week, the estimate
ranges from 39.6% to 49.4% of all the employees which is quite high. With regards to
employees in the company working more than 60 hours per week, the estimate ranges from
4.1% to 8.9% (Hillier, 2016). It is apparent that long working hours is a potential problem for
the company and underlying reasons for the same need to be explored by the HR department
so as to ensure that in the long run this should not adversely impact job satisfaction and
productivity.