Foundation Skills in Data Analysis Report
6 Pages2095 Words67 Views
Added on 2020-03-23
Foundation Skills in Data Analysis Report
Added on 2020-03-23
ShareRelated Documents
Foundation Skills in DataAnalysis[Type the document subtitle]STUDENT ID:[Pick the date]
Foundation Skills in Data AnalysisMEMORANDUMDate: 21st September 2017To: Hannah Zhou, Vice-President of Human ResourcesFrom: Sandy Stedwell, Research and Analysis DepartmentSubject: Re:Analysis of SuperPart Employee survey DataDear Hannah, In line with the tour request as per the memorandum on August 24, the data analysis of thesample data which our team had collected is completed. In this analysis, a host of statisticaltools and techniques have been highlighted in order to draw reliable conclusions for theorganisation as a while. The first aspect which has been observed is the high concentration ofemployees in the middle ages especially ranging from 30 years to 50 years. A worrisomeaspect is that the proportion of young employees especially in age group of 18-25 yearsseems lacking. Also the underlying relation of occupation, weekly work hours, before taxincome with age has been explored but is found to be without any statistical significance. Apositive aspect for the company is in the form of high satisfaction level which has beenobserved. Also, the satisfaction level does not tend to vary in a statistically significant mannerwith unionisation. Further, the hours of work per week is not related to the underlyingsatisfaction level of employees. Like the industry, going ahead, it is expected that thecompany also would face attrition concerns for which suitable measures need to beintroduced by the company. The claim in relation of non-unionised workers giving weeklyhours in excess of 45 hours has not been found true. Besides, statistical support has not beenfound for the unionisation level to be lesser than the national average level. Further, it isestimated that the overall sample size which equals 400 employees should suffice for futuresurvey requirement to be fulfilled.
Foundation Skills in Data AnalysisThe detailed findings of the statistical analysis in relation to the various issues raised areshared below.1)Based on the statistical analysis highlighted in the attached excel, it is apparent that themean employee age for the sample is 39.41 years. But since the various age groupsbelonging to different ages is essential for your analysis, usage of quartiles is preferred. Asper this, about one-fourth or 25% of employees have been found to be less than 32 years inage. This statistic along with the high mean employee age hints at the inability of thecompany at attracting young aged employees between 18-25 age group. This is alsosupported by about one –fourth of employees aged between 32 and 38 years. Also, thedistribution of age has a positive skew which further hints at the presence of exceptionallyold employees but no such indication occurs for very young which is a concerning factor.Also, it is noticeable that half of the sample employees have their ages between 32 yearsand 46 years and most of these would be found in the middle management causing somecrowding. Considering that three-fourths employees in the sample set are still less than 46years, hence retirement should not a major concern for the company. Clearly, many of theemployees are still pretty far from their retirement age and hence managing and nurturingthe existing talent would be more pivotal. However, the young employees must also jointhe organisation and it needs to be a key focus are otherwise the career progression wouldtypically be difficult especially on account of similar age levels of a host of employees.Also, it seems quite strange that there is so much under-representation of the young peopleand clearly relevant steps need to be taken in this regard as this should be a priority areamoving ahead.2)The key concern is to highlight the relation of age with some particular variables.(a)The association between the occupation and the employee age is not very significant.This is quite evident from the age distribution of those workers who are working aslabourers. It may be expected that considering the strenuous nature of the job, itshould be dominated by young people but this is not the case as contribution ofsample employees in 18-31 age bracket and 44-56 age bracket is almost the same.Also, the representation the age group 44-56 has a very low representation in terms ofroles related to management which is surprising. Therefore, the above evidence
End of preview
Want to access all the pages? Upload your documents or become a member.
Related Documents
Foundation Skills in Data Analysis (Doc)lg...
|7
|2207
|127
MIS770 Analytical Skills Foundationslg...
|10
|2258
|348
Foundation Skills in Data Analysis | Assignmentlg...
|11
|2149
|183
Foundation Skills in Data Analytics Assignmentlg...
|7
|1664
|35
Foundation Skills in Data Analysis for TechnoMartlg...
|8
|2372
|285
Foundation Skills in Data Analysis - TechnoMartlg...
|8
|2277
|308