Estimate of the proportion of employees

Assignment Help Management Information Sys

Reference no: EM132183781

Background

This is an individual assignment, which requires you to analyse a dataset, interpret the results and then report your findings to a person with little or no knowledge of statistical data analysis.

Scenario

Osmidium is an American car parts manufacturer with a factory in Adelaide which employs 2,000 people. The company wishes to study its full-time workforce by developing an employee profile that measures factors such as salary, job satisfaction, and career progress.

You will be playing the role of Alicia Stats, a Senior Analyst at the company. Senior management of Osmidium has asked you to conduct a survey of their employees. You decide to take a random sample of 450 staff and conduct the survey via company internal mail. The results are saved in the data set "AusNetData.xlsx".

Vito Genovese, Human Resources Manager at Osmidium, has written to you regarding the Osmidium employee survey. His letter to you is reproduced below.

Regarding the recently collected data from the Osmidium employee survey, please provide me with answers to the following questions. Your responses will assist our department in constructing the employee profile required by senior management.

1. Please provide an overall summary of employees' hours worked per week.

2. Please provide an estimate of the proportion of employees who are very likely to stay in their job.

3. Senior management is also interested in how hours worked is related to gender. Does there appear to be any relationship between an employee's hours worked and their gender?

4. Can you please provide an overall summary of how Osmidium employees rated their relations with the management?

5. Senior management is interested in which numerical variables, if any, seem to influence an employee's hours worked. Please provide a summary of these relationships ifany.

Please present your written findings in a report (no more than two pages), with an appendix (no more than eight pages) containing the results of your analysis, by no later than 6.00pm, Sunday 9th December 2018.

Part 1: Data Analysis

To prepare a reply to the manager's letter, you will need to use Excel to analyse the data set "AusNetData.xlsx". You will find this file on Moodle.

You will need to apply techniques you have learned during lectures and tutorials in Weeks 1 to 3 such as:
- tables
- graphs, and
- summary measures.

You may initially produce more Excel output than you need, so you will only need to copy and paste the relevant output from these worksheets to a ‘Results' worksheet. Keep in mind the page limit of 8 printed pages for the analysis AND that the presentation of the results will be marked too!

GUIDELINES

The manager has asked for a number of tasks to be done. The following guidelines for each question should be followed:

1. Please provide an overall summary of employees' hours worked per week.
You will need to use numerical analysis methods to summarise overall hours worked. In the report, you will also need to write about averages, variability etc. as presented in the examples in the relevant lecture and tutorial.

2. Please provide an estimate of the proportion of employees who are very likely to stay in their job. You will need determine the variable type and hence what methods you should use to provide this estimate.

3. Senior management is also interested in how hours worked is related to gender. Does there appear to be any relationship between an employee's hours worked and their gender?
You will need to focus on whether there is a difference or not. If yes, make sure you describe them. If not, you should explain why you think there is no difference.

4. Can you please provide an overall summary of how Osmidium employees rated their relations with the management?
You will need to use categorical analysis methods to summarise the variable. In the report you also need to briefly describe your findings. Examples can be found in the relevant lecture and tutorial.

5. Senior management is interested in which numerical variables seem to influence an employee's salary. Please provide a summary of these relationships if any.

Once more you will need to use techniques for the analysis of two variables. You will need to analyse six
(6) numerical relationships. In each case, the type of the relationship - if there is one - and its direction and strength are of interest. Make sure you comment on what you find in each case.

Part 2: Report (that is, your reply to the Manager's letter)
Write a letter to the manager, explaining essential information and conclusions from your data analysis. You are allowed no more than two pages to convey your written findings.

- Keep the English simple and the explanations brief.
- Avoid the use of technical statistical terminology. Your reader will not necessarily understand even simple statistical terms, thus your task is to explain your analysis using plain, understandable language.

Assignment Checklist:

Part 1 (Data Analysis)
1. Have you applied the correct analysis techniques?
2. Is the analysis in the same order as the manager's requests?
3. Is every table and every graph clearly labelled?
4. Are there tables or graphs that are broken across 2 pages? (If yes, make sure you change that!)
5. Is the analysis output no more than 8 pages long?

Part 2 (Report)
1. Is your report written in plain language?
2. Is it free of grammar and spelling mistakes?
3. Is it free of technical language?
4. Is it free of Excel output (tables, graphs)?
5. Are the answers numbered and in the same order as the manager's requests?
6. Is the report no more than 2 pages long?

Attachment:- Business Analytics.rar

Reference no: EM132183781

Questions Cloud

Impact of the layoff in employees : What will you do to minimize the impact of the layoff in employees?

What is the minimum variance portfolio : FIN 3300 Investments Assignment - Risk/Return Trade-off (Markowitz Efficient Frontier), University of Denver, USA. What is the minimum variance portfolio

Briefly describe the creator of the document : Briefly describe the creator of the document. (To answer this question, you may need to use information obtained from the introduction to the source).

Explain the differences between call and puts : Explain the differences between call and puts, not just in definition, but in actual workings of the option, price changes, time value, the Greeks,

Estimate of the proportion of employees : MIS171 Business Analytics - Deakin University - Does there appear to be any relationship between an employee's hours worked and their gender

Describe what score you made and why you think you got : Describe what score you made and why you think you got the score.

Business press about major action taken by corporation : Read an article in the business press about a major action taken by a corporation. The Economist or Harvard Business Review, to name a few.

When and where was the document created : When and where was the document created? (Again, you may need to use information obtained from the introduction to the source, or other course materials.

What benefits does leasing offer compared to the purchase : Compare and contrast two types of leases and describe the advantages and disadvantages of each. Which type of lease would produce the lowest risk?

Reviews

len2183781

12/2/2018 11:22:56 PM

PART 2 : MEMORANDUM CONTENT Marks Available Marks Allocated Excellent Good OK Needs Work Poor 5 Provided an excellent Most of your summary was Your summary was OK. Some of your Generally a poor summary of all aspects well written. However, you have explanations were OK. summary.You may have in non-technical language. either missed explaining some However, you have generally not provided a used technical terms or your descriptions may be aspects or have not concise and accurate confusing or poorly provided a clear summary. structured. enough summary.

len2183781

12/2/2018 11:22:44 PM

5. Excellent Good OK Needs Work Poor 3 All scatter diagrams Most of the analysis was of Some of the analysis Some of your output Generally poor analysis included correct trend a high standard. Some of was well done. was OK. However, you with either numerous lines/curves, showed your scatter diagrams may However you have have a number of errors or incorrect the corresponding R^2 have included some small made a number of mistakes in your scatter techniques used or value, and had the mistakes. mistakes. E.g. put the diagrams or have missing results. Poor variables on the correct dependent/independent missing results. organisation of output. axes. variables on the wrong axis

len2183781

12/2/2018 11:22:35 PM

4. Excellent Good OK Needs Work Poor 1.5 Correct frequency table Most of the analysis was of Some of the analysis Some of your output Generally poor analysis which includes a high standard. Perhaps was well done. was OK. However, you with either numerous percentages. some small mistakes (eg. However there were may have used errors or incorrect

len2183781

12/2/2018 11:22:27 PM

3. Excellent Good OK Needs Work Poor 3 Comparative summary Most of the analysis was of Some of the analysis Some of your output Generally poor analysis measures calculated a high standard. Some of was well done. was OK. However, you with either numerous correctly, suitable your output may have However there were have made a number of errors or incorrect tables and graphs used. No irrelevant contained small mistakes or could be improved. Results either a few errors in your analysis OR you mistakes or have missing results. techniques used or missing results. Poor output and results very were well organised. had missing analysis. Organisation of output organisation of output. well organised. may need improvement.

len2183781

12/2/2018 11:22:20 PM

2. Excellent Good OK Needs Work Poor 1.5 Sample proportions Most of the analysis was of Some of the analysis Some of your output Generally poor analysis with counts calculated a high standard. Some of was well done. was OK. However, you with either numerous correctly. No irrelevant your output may have However there were have made a number of errors or incorrect output and results very well organised. contained small mistakes or could be improved. Results either a few errors in your analysis OR you mistakes or have missing results. techniques used or missing results. Poor Appropriate chart were well organised. had missing analysis. Organisation of output organisation of output. may need improvement.

len2183781

12/2/2018 11:22:12 PM

T3 2018 MIS171/MISP171: Business Analytics - Assignment 1 1. Student-ID Names PART 1 DATA ANALYSIS Marks Available Marks Allocated Excellent Good OK Needs Work Poor 3 All summary measures Most of the analysis was of Some of the analysis Some of your output Generally poor analysis calculated correctly, a high standard. Some of was well done. was OK. However, you with either numerous suitable tables and your output may have However there were have made a number of errors or incorrect graphs used. No contained small mistakes or either a few errors in mistakes or have techniques used or irrelevant output and could be improved. Results your analysis OR you missing results. missing results. Poor results very well were well organised. had missing analysis. Organisation of output organisation of output. organised. may need improvement

len2183781

12/2/2018 11:21:49 PM

Both parts may be contained in a single file, but their content must be separated. That is, you will submit one document only. The electronic submission will consist of two parts. Failure to separate Part 1 and Part 2 will be penalised. The Assignment must be submitted electronically and 10% of available marks will be deducted for late

len2183781

12/2/2018 11:21:25 PM

You DONOTneed toperformanyadditionalanalysisotherthan whatyouhavelearned inweeks 1, 2 and 3 though doingsomayattractadditionalmarksbutonlyifappropriateandinformative. You may initially produce more Excel output than you need, so you will only need to copy and paste the relevant output from these worksheets to a ‘Results’ worksheet. Keep in mind the page limit of 8 printed pages for the analysis AND that the presentation of the results will be marked too!

Write a Review

Required(*) Message

Management Information Sys Questions & Answers

Perform some research on such a company

It has been stated that IT provides a competitive edge to organizations. Can you think of a company that uses IT strategically? Perform some research on such a company and discuss its case in this thread

Compare the six core processes in the sdlc

Compare the six (6) core processes in the SDLC. Give your opinion on which one you believe is the least important in developing software, and explain why. Give your opinion on which one you believe is the most important in developing software, and..

Identify five normal and abnormal scenarios for the case

Provide one (1) sample of a descriptive statement and one (1) sample of a prescriptive statement from the case study descriptions.

How about internal and external threats

List and Describe the methods firms use to ensure the integrity of their software, their hardware, their networks, and their partners?Was Hardware, Software and Networks addressed?Was Wired and Wireless addressed?How about Internal and External thre..

Importance of governance and compliance to employees

Given the need for governance and compliance within the workplace, suggest two (2) methods that an organization could employ to distill the importance of governance and compliance to employees

Rfid internet search resultswhen you entered rfid into the

rfid internet search resultswhen you entered rfid into the internet search engine of the top twenty results how many

What is the relevance of data mining in organizations

What is the relevance of data mining in organizations? Databases require both a physical and conceptual model. Compare these models. How do they differ?

An opportunity to observe two adults in a local food store

An opportunity to observe two adults in a local food store last weekend. The two people were females. I could see two of them standing close to one another.

What technologies you believe provide the biggest challenge

Assess the challenges e-Business and e-Commerce technologies present to the field of Information Technology. Describe what technologies you believe provide the biggest challenge and provide a strategy to overcome that technological challenge. Supp..

Design a data warehouse schema using the star-schema

FIT5195 Business Intelligence & Data Warehousing. Design a data warehouse schema using the star-schema approach based on your Thomsen diagrams in assignment part a. Consider options for the technical architecture for the data warehouse, recommending..

Evaluate the pros and cons in agile and waterfall project

Evaluate the pros and cons in agile and Waterfall project management in terms of planning and the execution of projects.

What role can company executives play in an implementation

What are the skills, knowledge, and abilities required to be a project manager? Name five critical success factors and why they are important to the success of a project.

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!

Submit Assignment

User Account

All Pages