Analysis-techno art industries employee satisfaction survey

Assignment Help Business Law and Ethics
Reference no: EM131205051 , Length: word count:2000

Analysis of Techno art Industries employee satisfaction survey

Overview

The purpose of this assignment is to investigate a dataset utilising the knowledge learned in Module Two. This will enable conclusions to be drawn that ultimately assist in decision making. You will also draw on information/techniques covered in Module One.

The assignment requires you to analyse a given dataset, interpret the results, and then draw conclusions such that you are able to reply to specific questions being asked of you in the form of a report. (These questions are asked in the following memorandum).
The aims of the assignment is to:

- provide you with some examples of the application of data analysis within an organisation
- test your understanding of the material in the relevant topics
- test your ability to analyse and interpret your results
- test your ability to effectively communicate the results of your analysis to others

Before tackling the assignment, make sure you have prepared yourself well. As a minimum, please read the relevant sections of the prescribed text and listen/watch the pre-recorded material for Modules 1 and 2.

Scenario

TechnoMart Industries is an automobile parts manufacturer with 9800 employees (TechnoMart is a fictitious company and meant to bear no resemblance to any existing organisation). It wishes to study its full-time workforce by developing an employee profile that measures factors such as income, job satisfaction and career progress. Emma Saward, the Vice-President of Human Resources, hires MDB Corporation, a consulting firm, to survey TechnoMart employees. A survey of a random sample of 400 staff was conducted via online questionnaire.

The questionnaire used for the survey can be found in the TechnoMart2015.xls file (All data in the spreadsheet is fictitious). Please ensure you read that questionnaire. To understand what each variable means, please cross-reference to the questionnaire given in the database file.

In the assignment, you play the role of Madison Thomson, an analyst at MDB Corporation. You are often required to report outcomes of your analysis to clients who have little or no knowledge of data analysis. Emma Saward, the Vice-President of Human Resources at TechnoMart Industries, has written to you regarding certain matters relating to the employee satisfaction survey. Her memo to you is reproduced below:Memorandum

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, gender 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

Provide me with an overall summary of hours worked at TechnoMart, keeping in mind that the normal working week is 40 hours. I'm also interested in whether we have many employees that are working more than 60 hours. Can you estimate this for me?

2. Comparison of union and non-union members

In addition to the overall analysis you are carrying out for work hours, I am particularly interested in how union members in the company compare to non-union members in regard to a few key variables. Do union members tend to earn more or less than non-union members? Do they have different perceptions? In particular, I want you to investigate how union members and non-union members compare in regard to:

(a) Hours worked
(b) Occupation
(c) Before-taxes income
(d) Job satisfaction
Based on the above, can you provide me with a brief summary of how the two groups compare.

3. Employees working overtime at TechnoMart
(a) 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?
(b) Likewise, how many employees are working more than 60 hours?

4. 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:
(a) average age of TechnoMart employees
(b) total number of workers across all of TechnoMart who are close to retirement age (55 years or older)

5. Union membership
In a recent Enterprise Bargaining meeting, the union made a number of claims that I would like you to check.
(a) 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 be more than 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?
(b) There is some speculation that the union members work on average more than 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.
(a) 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?
(b) 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

Requirements:

- Your report must be no longer than 2000 words (including the Introduction but excluding any Table of Contents, Charts and Tables, and Appendices). Your Charts/Graphics and Tables are only to be placed in the Data Analysis file i.e. the Excel spreadsheet

- The report is to be written as a stand-alone document (assume Emma will only read your report). Thus, you should not have any references in the report to your data analysis output. Eg. "According to Table 1 in the analysis..."

- Word formatting for the Report: Single-line spacing, no smaller that 10 point font, page margins at least 25mm, good use of white space

- Your report must have an informative title

- Your report must contain an introduction/executive summary that explains in plain language what the report is for and summarises the main findings. The introduction should be no more than 1/2 page

- The body of your report must be set out in the same order as in the originating memorandum from Emma Saward, with each section (question) clearly marked

- Keep the language simple and the explanations succinct. Avoid the use of technical or statistical jargon as Emma will not necessarily understand even simple statistical terms. As a guide to the meaning of "Plain Language", imagine you are explaining your findings to a person without any statistical training (e.g. someone who has not studied this unit). What type of language would you use in this case?

- Marks will be lost if you use unexplained technical terms, irrelevant material, or have poor presentation/organisation

- All Microsoft Excel output associated with each question in the Memorandum is to be placed in the corresponding tab in the file TechnoMart2015.xlsxData Analysis Instructions/Guidelines

In order to prepare a reply to Emma's memorandum, you will need to examine and analyse the dataset TechnoMart2015.xls thoroughly.

Emma has asked a number of questions and your Data Analysis output (i.e. your charts/tables/graphs) should be structured such that each question is answered on the separate tab/worksheet provided in your Excel document.

In order to effectively answer the questions, your Data Analysis output needs to be appropriate. Accordingly, you'll need to establish which of the following techniques are applicable for each question:

- Summary Measures (Descriptive Statistics)

- Comparative Summary Measures (i.e. Descriptive Statistics for multiple values of a variable)

- Suitable tables and charts or graphics (Topic 3; Chapter 11 of the text) that will illustrate more clearly, other important features of a variable

- Cross Tabulations (sometimes called Contingency Tables), used to establish the relationships (dependencies) between two variables (see Additional Materials under Topic 5 - Probability and Distributions on how to create Cross Tabulations in Excel using Pivot Tables)

- Confidence Intervals. You can assume that a 95% confidence level is appropriate. We use Confidence Intervals when we have no idea about the population parameter we are investigating. Additionally, we would use Confidence Intervals if we are asked to provide an estimate. You can use the relevant Excel template provided in the dataset and copy to the applicable question tab

- Hypothesis Tests. You can assume that a 5% level of significance is appropriate. We Use Hypothesis Tests when we are testing a Claim, a Theory or a Standard. You can use the relevant Excel template provided in the dataset and then copy to the applicable question tab

Additionally, the textbook provides you with step-by-step instructions for several automated statistical processes (e.g. see "Steps for finding Descriptive Statistics", also known as Summary Measures, at the end of Chapter 12).

Reference no: EM131205051

Questions Cloud

Find the equilibrium electron and hole concentrations : Find the equilibrium electron and hole concentrations and the location of the Fermi level for silicon at 27oC if the silicon contains the following concentrations of shallow dopant atoms:
Garbage collector run simulation : Please answer in Word Doc. This is a Labor Relations class. If you do not have experience or knowledge with unions or Labor relations please do not answer Instructions
Development in terms of how training and development : Create a model (in a Powerpoint Slide) that visually depicts training and development in terms of how training and development should be integrated within an organization. A "model" is an illustration of your theory of training and development-bas..
Identify the type of audit opinion issued by each auditor : An Independent Auditor's Report to the Members has been issued for each company for the financial year ended 30 June 2015: Identify the type of audit opinion issued by each auditor, and justify your answer. Do you agree with the type of opinion issue..
Analysis-techno art industries employee satisfaction survey : MIS770 - Analytical Skills Foundations - In the assignment, you play the role of Madison Thomson, an analyst at MDB Corporation. You are often required to report outcomes of your analysis to clients who have little or no knowledge of data analysis.
Determine the source of the data : Check the website for your State Department of Health. Determine whether your state has a statewide cancer, immunization, or public health (syndromic surveillance) registry. If not, select another state of your choosing that does have a statewide ..
Prepare management action plan addressing healthcare problem : Prepare a management action plan (MAP) addressing a specific healthcare problem or scenario.- Clarify the Problem or Opportunity for Improvement (OFI).
Describe the concept of skill mix : Describe the concept of skill mix and why it is important. Develop a scenario that requires the use of skill mix and explain how the actions you chose accomplish skill mix.
Determine the reliability for the first year of operation : A smoke detector is routinely inspected. 80% of the detectors found inoperative had experienced a power surge, and 10% of those found in operating condition had experienced a power surge. 20% of the detectors inspected have failed. What is probabi..

Reviews

len1205051

9/14/2016 1:25:20 AM

Introduction/Executive summary - Provides an outstanding descriptions and conclusions that is carefully considered and insightful.Data Analysis and Graphics - Skilful and comprehensive analysis of data using many different techniques. Uses data visualisations to produce novel insights. An exemplary presentation of the analysis. Interpreting Results and Communication - Provides an outstanding descriptions and conclusions that is carefully considered and insightful. The written communication is truly professional, logical and easy to follow.Overall Assignment PresentationAn exemplary presentation of the analysis. The memorandum is truly professional, logical and easy to follow.

len1205051

9/14/2016 1:23:59 AM

Your completed assignment should be in two separate files: • Report: a Word document of no more than 2000 words and not containing any charts/tables/graphs • Data Analysis: an Excel document (i.e. the TechnoMart2015.xls file) containing separate tabs/worksheets with charts/tables/graphs for each question. Please note that all interpretations should be presented in your “Report” and the excel document should only contain your intermediate analysis and final output Please name/rename each file using the format yourstudentid.docx and yourstudentid.xls or, if you are submitting as a group, then all members IDs. Only one submission per group is required.Note: The Cloud Unit site is the ONLY method of submission acceptable.If you need to request an extension, please email the Unit Chair by no later than Wednesday 14th September, 2016. Students who fail to submit an assessment on time without an approved extension will not be marked. These will be held until final grading and may be taken into consideration in a pass/fail situation.

Write a Review

 

Business Law and Ethics Questions & Answers

  Throughout this week you studied the topic of eminent

throughout this week you studied the topic of eminent domain which is the power to take private property for public use

  Discuss the ethical issues that can arise in contracting

Assignment: Managing the Contractor-Customer Relationship, Discuss the ethical issues that can arise in contracting

  Describe the victim-offender relationship

Describe the victim-offender relationship, including the following: How victims are viewed by perpetrators of date rape, The special problems of date rape prosecutions, How society and jurors may view date rape (blaming the victim based on the percei..

  Can you explain why juveniles of color have higher rates

What correctional policies can be created from the principles of restorative justice (based on indigenous justice principles)? Are these values more compatible with some offenses than others? More appropriate for some types of offenders than other..

  What is the definition of a defacto partnership

BLO5606 - Australia's Visa System Task. What is the definition of a 'defacto partnership'? Does Emma qualify as Jason's defacto partner? What other option would you recommend to Jason in the circumstances

  Summary - emergence of tort law

Write one page summary with its referance without plagirsim. The topic is : Emergence of Tort Law

  When looking at the relationship between social justice and

when looking at the relationship between social justice and juvenile justice there are two over arching concepts when

  Effects with the continuous centralization of national power

What are some potential effects with the continuous centralization of national power on the US federal system?

  How is a court most likely to rule explain

College Copy Shop (CCS) compiles, copies, and sells reading materials to students on the instructions of their professors, who indicate which parts of which publications should be included. How is a court most likely to rule? Explain

  What has been agreed to in negotiated settlement agreement

What were the key allegations in the case? Explain. What has been agreed to in the negotiated settlement agreement? Identify at least 2 significant reforms addressed in the agreement

  Arguments for and against corporate social responsibility

Explain the arguments for and against corporate social responsibility, Discuss the challenges faced by a government in the implementation of corporate social responsibility policy

  An insurer has a duty to defend an insured

In determining whether an insurer has a duty to defend an insured, should a court ask whether the insured had a "reasonable expectation" of coverage? Explain.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd